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

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

View Full Document Right Arrow Icon
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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
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.
Background image of page 2
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.
Background image of page 3

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

View Full DocumentRight Arrow Icon
Now that we have all of our values, we want to graph them, right?
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/24/2009 for the course ENGINEERIN 4283 taught by Professor Smith during the Spring '09 term at American InterContinental University Dunwoody.

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 Right Arrow Icon
Ask a homework question - tutors are online