FInal Project Assessment
coh7482
MeanMedianandMode.xlsxSheet1
| MALE DATA | ||
| Participant | Post | Age |
| 1 | Negative | 18 |
| 2 | Positive | 18 |
| 3 | Negative | 18 |
| 4 | Negative | 18 |
| 5 | Negative | 17 |
| 6 | Positive | 17 |
| 7 | Positive | 17 |
| 8 | Positive | 17 |
| 9 | Positive | 17 |
| 10 | Negative | 17 |
| 11 | Negative | 17 |
| 12 | Positive | 16 |
| 13 | Positive | 15 |
| 14 | Positive | 15 |
| 15 | Positive | 16 |
| MEAN | 16.8666666667 | |
| MEDIAN | 17 | |
| MODE | 17 | |
| FEMALE DATA | ||
| Participant | Post | Age |
| 1 | Negative | 13 |
| 2 | Negative | 14 |
| 3 | Negative | 14 |
| 4 | Negative | 15 |
| 5 | Negative | 15 |
| 6 | Negative | 15 |
| 7 | Negative | 15 |
| 8 | Positive | 15 |
| 9 | Negative | 15 |
| 10 | Negative | 15 |
| 11 | Negative | 15 |
| 12 | Positive | 15 |
| 13 | Negative | 15 |
| 14 | Negative | 16 |
| 15 | Positive | 16 |
| MEAN | 14.8666666667 | |
| MEDIAN | 15 | |
| MODE | 15 |
In calculatig Mean , Median and Mode, fistly, data set is sorted in decseding order in excel. Consequenstly, there is use of AVERAGE, MEAN AND MODE funcstions respective to calculate male variables in the dataset. MEAN=AVERAGE(C6:C20), GIVING 16.8667 MEDIAN=MEDIAN(C6:C20), GIVING 17 MODE=MODE(C6:C20)GIVING 17
In calculatig Mean , Median and Mode, fistly, data set is sorted in decseding order in excel. Consequenstly, there is use of AVERAGE, MEAN AND MODE funcstions respective to calculate female variables in the dataset. MEAN =AVERAGE(C33:C47), GIVING 14.86677 MEDIAN=MEDIAN(C33:C47), GIVING 15 MODE==MODE(C33:C47))GIVING 15
