Question: How do you use Excel to find the mean? Use the data below and the information below to find the mean of the data. All
How do you use Excel to find the mean? Use the data below and the information below to find the mean of the data.
All the numbers in the data represents ages except for -1, 998, and 999. -1 represents missing data, 998 represents the people who refused to give their age, and 999 represents people who put don't know.
Data:
-1
-1
-1
998
999
999
| 24 |
| 65 |
| 20 |
| 40 |
| 41 |
| 19 |
| 52 |
| 35 |
| 18 |
| 28 |
| 22 |
| 40 |
| 28 |
| 21 |
| 27 |
| 35 |
| 36 |
| 23 |
| 54 |
| 44 |
| 28 |
| 29 |
| 65 |
| 19 |
| 36 |
| 22 |
| 39 |
| 70 |
| 34 |
| 30 |
| 52 |
| 56 |
| 49 |
| 35 |
| 27 |
| 48 |
| 28 |
| 31 |
| 18 |
| 45 |
| 24 |
| 19 |
| 21 |
| 21 |
| 37 |
| 41 |
| 24 |
| 32 |
| 43 |
| 27 |
| 49 |
| 30 |
| 22 |
| 62 |
| 21 |
| 53 |
| 27 |
| 29 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
