Problem 3 Poisson Distribution - Monthly Workplace Injuries

A quality analyst is studying the number of workplace injuries which he believes follow a Poisson process with a mean injury rate of 4.1 per month ().

Within an MS-Excel workbook, create a worksheet named "Problem 3"

Enter parameter value in a cell.

Enter the following k values in a column: 0,1,212.

Next to the K values, add a column with Header name Probability. Use the poisson.dist function to calculate the probabilities that number of monthly injuries equals each k value prob(# of monthly injuries = k). Format probabilities to be a number with 4 decimal places

Next to the Probability column, create a column with header named Cumulative Probability. Use the poisson.dist function to calculate the cumulative probabilities that number of monthly injuries are equal to or less than each k value prob(# monthly injuries <= k). Format probabilities to be a number with 4 decimal places.

Create one column chart: number of monthly injuries by probability. Add chart and axis titles. Make sure probabilities on the Y axis range from 0 to 1 and do not show trailing 0 values on Y axis probabilities

In a textbox, indicate which k value has the highest probability and which k value has the lowest probability.

In three separate cells, calculate the following 3 probabilities using the poisson.dist function

Prob. (# of monthly injuries <= 0)

Prob. (# of monthly injuries > 0 & injuries <= 3)

Prob. (# of monthly injuries > 3).

Do not refer to the probability values computed in steps d and e. Instead, use the posisson.dist function to compute cumulative probabilities as we did in class. Isolate the values 0 and 3 in separate cells (e.g. dont put 0 and 3 values in your formulas). I used a layout like this: