I need it by excel. So please show the calculation step also. 2) Maria is analyz
ID: 3208507 • Letter: I
Question
I need it by excel. So please show the calculation step also.
2) Maria is analyzing the workers’ compensation (WC) losses of the employees in the firm that occurred over a one-year period, based on the following data:
Number of WC Claims Filled/Worker
Number of Workers
Total Number of Claims
0
500
0
1
270
270
2
50
100
a. Use the information in the table to find the average frequency of losses per worker.
b. Use the information in the table to estimate a probability distribution for the frequency distribution of losses per worker in a year.
Number of WC Claims Filled/Worker
Number of Workers
Total Number of Claims
0
500
0
1
270
270
2
50
100
Explanation / Answer
a) The average frequency of losses per worker is
Mean = 370/820 = 0.45122
b)
The probability distribution for the frequency distribution of losses per worker is
X fi fixi 0 500 0 1 270 270 2 50 100 Total: 820 370