City College of San Francisco
City College of San Francisco Spring 2006
Name: _____________________________
How to Use Excel to Calculate
the Mean and the Standard Deviation
An Excel worksheet looks like an infinite chart with letters to label the columns and numbers to label the rows. It looks like this:
|A |B |C |D |E |F |G |… | |1 | Cat |Dog | | | | | | | |2 | | | | | | | | | |3 | | | | | | | | | |4 | | | | | | | | | |5 | | | | | | | | | |6 | | | | | | Bird | | | |7 | | | | | | | | | |8 | | | | | | | | | |
So, we can call the cell with the word “Cat” in it A1. And the cell with the word “Dog” in it can be called B1.
What cell is the word “Bird” in?
One of the coolest things about Excel is that we can perform statistics easily using it. It has functions that will calculate things like the Sum, the Average and the Standard Deviation for us (there are many more, but those are the ones that are most useful to us in class). All we have to do is enter the data into a worksheet and use the appropriate commands.
For example, say we have the following set of data: [pic] which are the ages of the 9 full-time math teachers at Laney College. If we would like to find the Mean and the Standard Deviation of the data, we first put the data into a spreadsheet, like so:
|A |B |C |D |E |F |G |… | |1 | |24 | | | | | | | |2 | |29 | | | | | | | |3 | |41 | | | | | | | |4 | |40 | | | | | | | |5 | |31 | | | | | | | |6 | |35 | | | | | | | |7 | |58 | | | | | | | |8 | |56 | | | | | | | |9 | |45 | | | | | | | |10 | | | | | | | | | |11 | | | | | | | | | |
Then, we can pick a cell to put the Mean in. Let’s pick cell B10. We need to put the following in B10:
|A |B |C |D |E |F |G |… | |1 | |24 | | | | | | | |2 | |29 | | | | | | | |3 | |41 | | | | | | | |4 | |40 | | | | | | | |5 | |31 | | | | | | | |6 | |35 | | | | | | | |7 | |58 | | | | | | | |8 | |56 | | | | | | | |9 | |45 | | | | | | | |10 | |=average(B1:B9) | | | | | | | |11 | | | | | | | | | |
When you put this in the cell and press “enter”, then you get this:
|A |B |C |D |E |F |G |… | |1 | |24 | | | | | | | |2 | |29 | | | | | | | |3 | |41 | | | | | | | |4 | |40 | | | | | | | |5 | |31 | | | | | | | |6 | |35 | | | | | | | |7 | |58 | | | | | | | |8 | |56 | | | | | | | |9 | |45 | | | | | | | |10 | |39.88889 | | | | | | | |11 | | | | | | | | | |
Notice that the mean of the data in the cells B1, B2, B3, …B9 is now in B10.
Another way to do this is to type the following in B10: =average(
Then highlight all the cells for which you would like to find the average of.
Then put in a )
And press Enter.
Now, you try to get Excel to compute the Standard Deviation using the function “stdev” and put it in the cell B11.
(Hint: Just do what you did before, but instead of using the function name “average” use “stdev”)
If you get the following, then you did it right!:
|A |B |C |D |E |F |G |… | |1 | |24 | | | | | | | |2 | |29 | | | | | | | |3 | |41 | | | | | | | |4 | |40 | | | | | | | |5 | |31 | | | | | | | |6 | |35 | | | | | | | |7 | |58 | | | | | | | |8 | |56 | | | | | | | |9 | |45 | | | | | | | |10 | |39.88889 | | | | | | | |11 | |11.66667 | | | | | | | |
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- you should be familiar with the following tasks using
- lab 1 the sampling distribution using excel
- advanced excel statistical functions formulae
- city college of san francisco
- excel functions to examine the properties of probability
- boston college
- california state university northridge
- mrs nicolella s niche
- industry standards suggest that 10 of new vehicles
Related searches
- blackrock san francisco office
- city college of baltimore city
- san francisco immigration
- san francisco detained immigration court
- consulado mexicano san francisco citas
- consulado brasileiro san francisco ca
- colombian consulate san francisco ca
- consulado de colombia en san francisco ca
- mexican consulate san francisco hours
- consulado colombiano san francisco california
- san francisco time zone now
- san francisco local news