{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Making graphs in Excel

# Making graphs in Excel - Basic Graphing in Excel The...

This preview shows pages 1–5. Sign up to view the full content.

Basic Graphing in Excel The following is a sample of the data you will collect from performing the height measurements. Notice that below the data is a space to calculate the mean and standard deviation of each column of data. To calculate the mean of a particular column, you will enter the formula “=average(B2:B11)” (without the quotes) or whatever the data range is for your particular data set. In this case, it was between cell B2 and cell B11. Notice below that the mean for column B is now calculated in cell B12 and the formula shows up in the ƒ x field at the top.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
To enter the standard deviation for column B, the general formula remains the same, but instead of AVERAGE, we use STDEVP to get the “n” version of standard deviation instead of the “n – 1” version. Note below that the standard deviation for column B is now calculated in cell B13.
The mean and standard deviation for the remaining columns can be calculated in the same way. Note that if you want to copy the same formula to a range of cells, for instance, the formula to calculate the mean, you can click the bottom right corner of a cell (when the cursor turns from a big white cross to a small black cross with no arrows) and drag it to the range you want to include. So if we want to duplicate the mean formula that is contained in cell B13 for the entire row 13, we would click the bottom right corner of B13 and drag it to E13, as illustrated below.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Now that we have all of our values, we want to graph them, right?
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 16

Making graphs in Excel - Basic Graphing in Excel The...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online