|
|
| | 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 |
| | 32.2 |
| Mean |
| Sample Stand Deviation |
| Skewness |
| | 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. |