|
|
| | Mean and Standard Deviation for 5 Learning Teams in a RES 351 Class. |
| | | | | | | | Class Average |
| | Team1 | Team2 | Team3 | Team4 | Team5 |
| | 24 | 35 | 31 | 35 | 44 |
| | 31 | 34 | 24 | 44 | 27 |
| | 30 | 24 | 27 | 31 | 25 |
| | 47 | 22 | 24 | 42 | 27 |
| | 29 | | 24 | 21 | 21 |
| | | | | 25 |
| Mean | 32.2 | 28.75 | 26.5 | 38 | 30.75 | | 31.24 |
| Sample Stand Deviation | 8.7005746937 | 6.7019897543 | 3.0822070015 | 9.2357999112 | 8.8430763878 | | 2.2907029197 |
| Skewness | 1.6734648219 | -0.0573030609 | 1.4514548206 | -0.7014348408 | 1.7899477294 | | -0.4942367863 |
| | Note that you go to "Insert" then "Function" then "Average" |
| | | to get the formula for the mean. |
| | For the team standard deviations, do the same thing and then use the STDEV function (standard deviation for a sample) |
| | For the class total standard deviation, use the STDEVP function, which is for a population. |
| | Now, try doing the Skewness calculation on your own in the yellow highlighted area. |