A Poisson distribution has = 5.8. (a)[2] Use the Excel function POISSON.DIST() and 4 decimal...

Transcribed Image Text:

A Poisson distribution has À = 5.8. (a)[2] Use the Excel function POISSON.DIST() and 4 decimal places to fill in the following table: 3 4 5 6 7 8 9 10 11 12+ 0 1 2 X P(x) (b)[2] Use an Excel column chart to visualize the probability distribution. How is it skewed? (c)[1] Find P(x ≤ 5). [steps & result] (d)[1] Find P(x > 8). [steps & result] (e)[2] Find P(5 < x≤9). [steps & result] (f)[2] Expected frequency (EF) = nx probability. Given a hypothetical sample of n = 250, complete the following expected frequency table using 4 decimal places: 0 1 2 3 4 5 6 7 8 9 10 11 12+ X EF(x) A Poisson distribution has À = 5.8. (a)[2] Use the Excel function POISSON.DIST() and 4 decimal places to fill in the following table: 3 4 5 6 7 8 9 10 11 12+ 0 1 2 X P(x) (b)[2] Use an Excel column chart to visualize the probability distribution. How is it skewed? (c)[1] Find P(x ≤ 5). [steps & result] (d)[1] Find P(x > 8). [steps & result] (e)[2] Find P(5 < x≤9). [steps & result] (f)[2] Expected frequency (EF) = nx probability. Given a hypothetical sample of n = 250, complete the following expected frequency table using 4 decimal places: 0 1 2 3 4 5 6 7 8 9 10 11 12+ X EF(x)

Answer rating: 100% (QA)

a Using the POISSONDIST function in Excel with 58 and x values from 0 to 12 we ge... View the full answer