{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel 2007 Tutorial

# Thisautomaticallyentersthecellnames

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

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

{[ snackBarMessage ]}

Ask a homework question - tutors are online