Unformatted text preview: ct the first cell containing your data and drag the mouse down to the end of your data. This automatically enters the cell names: Once all the data are selected, close the parentheses and press enter. B) Calculating the standard deviation in Excel To calculate the standard deviation of a set of data, do the same thing as when calculating the average, except now you type: =STDEV(“first cell”:”last cell”) C) Making Graphs and Trendlines Type the x‐values and y‐values into adjacent columns, with the x‐ values to the left of the y‐values. Highlight the data values you want to plot Go to the insert tab: Under the charts section, click on scatter, and select the first option, scatter...
View Full Document
- Spring '08
- Physics, cell. Cell D5, select add trendline