FInal Project Assessment
coh7482
Variance.xlsxFrequency Table
| MALE DATA | ||
| Participant | Post | Age |
| 1 | Negative | 17 |
| 2 | Positive | 16 |
| 3 | Negative | 17 |
| 4 | Negative | 18 |
| 5 | Negative | 18 |
| 6 | Positive | 17 |
| 7 | Positive | 17 |
| 8 | Positive | 18 |
| 9 | Positive | 17 |
| 10 | Negative | 15 |
| 11 | Negative | 15 |
| 12 | Positive | 17 |
| 13 | Positive | 17 |
| 14 | Positive | 18 |
| 15 | Positive | 16 |
| variance | 0.980952381 | |
| FEMALE DATA | ||
| Participant | Post | Age |
| 1 | Negative | 15 |
| 2 | Negative | 14 |
| 3 | Negative | 15 |
| 4 | Negative | 15 |
| 5 | Negative | 15 |
| 6 | Negative | 15 |
| 7 | Negative | 13 |
| 8 | Positive | 16 |
| 9 | Negative | 15 |
| 10 | Negative | 15 |
| 11 | Negative | 15 |
| 12 | Positive | 14 |
| 13 | Negative | 16 |
| 14 | Negative | 15 |
| 15 | Positive | 15 |
| variance | 0.5523809524 |
Varianace decsribes how far each number in the set is from the mean and a tatistical measurement of the spread between numbers in a data set. In calculating variaraince, the funcstion VAR in Ms Excel is applicable. For instance, calcuating varianvce in male ages is computed as =VAR(C3:C17), giving 0.980952, while female datset accommoadtes =VAR(C25:C39), giving 0.552381, indicating how far each number in the set is from the mean in females dataset.
