Excel 2007 Tutorial

Thisautomaticallyentersthecellnames

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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

This note was uploaded on 03/26/2010 for the course PHY 158 taught by Professor Staff during the Spring '08 term at SUNY Buffalo.

Ask a homework question - tutors are online