How do you use Excel to find the mean? Use the data below and the information below
Fantastic news! We've Found the answer you've been seeking!
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 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 |
Posted Date: