Organize Data with Excel
Tables and graphs generated by MS Excel can be cut and pasted in a document file of a word processing program.
MS Excel is available for both PCs and Macs in the phonetics lab as well as CLIC. There are minor differences between PC and Mac versions, but basic functions are the same.
Create a table which presents measurement values
Decide how you want to organize a summary table for measurement values.
To insert row titles, column titles and measurement values in cells: Select a cell by placing an arrow on the cell and clicking a mouse once. Type in a text or a number into the cell. Double-check values that you typed in!
You can copy the table template, which is used for todays section, to summarize VOT values. Bring your own floppy disk and copy an excel file named "excel table" in the "Ling104/204" folder on the desktop of Kelly (Mac in the General Lab). The table template is a Mac Excel file, but it can be read by Windows Excel as well. Please do not open this template file in Excel for your homework!!!
Calculate mean values:
Type the formula: SUM(E2:G2)/3
Press Return (Enter) Key, then the typed operation is executed.
Click on the cell with the first mean, copy it and paste it in the other MEAN cells. The mean is automatically re-computed for the data in each row.
You can select the entire summary table, copy it and paste it in a document file of a word processing program.
Create a graph chart
Select all relevant cells, and click on the Chart Wizard button on the tool bar.
Select the area of the spreadsheet where you want the graph chart to appear, and click on OK in the last window.
To edit the format of a graph (e.g. font size, text, scale of Y-axis), double-click on a graph, and double-click the part of the graph that you want to edit.
Like a summary table, you can copy a graph and paste it in a document file of a word processing program.
Print tables & graphs
You can also print tables and graphs on the spreadsheet and attach them to your write-up.
Easy way (take this option if you see the set print area button on the tool bar): Select relevant cells, and click on the set print area button, which has a shining printer picture.
Hard way: Select the Page Setup command under the File menu. Select the Sheet tab. In the Print Area box, enter the range to print.
Print Preview: It is a good idea to privew your printout. Select Print Preview under the File menu. You can adjust many things such as a print scale, margins, header and so on.
Whatever you created with excel can be cut and pasted in a document file of a word-processing program.