Question

8. Calculate mean and median on the basis of the following statistical data regarding the daily wages
distribution of 100 workers in a factory.
Class interval:
30-39 40-49 50-59 60-69 70-79 80-89 90-99
Frequency:
2
3
11
20
32
25
7

​

Answer 1

Answer:

6The average can be calculated most easily by multiplying the age by the number of people that is each age. For instance, in column C you could place a formula such as =A1*B1 and then copy it down the column. Add up the values in columns B and C, and then divide the sum in column C by the sum in column B.