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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!