Please help, I need to know how to do this problem using only excel. Thank you I
ID: 3075022 • Letter: P
Question
Please help, I need to know how to do this problem using only excel. Thank you
In the production of chocolate chip cookies, one can consider each cookie to be the specified interval unit required for a Poisson distribution, and one can consider the variable x to be the number of chocolate chips in a cookie. The data set below includes the numbers of chocolate chips in 34 different chocolate chip cookies. The Poisson distribution requires a value for , so use 30.6, which is the mean number of chocolate chips in the 34 cookies. Assume that the Poisson distribution applies. Complete parts a and b below EEB Click the icon to view the data table a. Find the probability that a cookie will have 26 chocolate chips, then find the expected number of cookies with 26 chocolate chips among 34 different cookies, then compare the result to the actual number of cookies with 26 chocolate chips The probability that a cookie will have 26 chips is, P(26)0.054 (Type an integer or decimal rounded to three decimal places as needed.) The expected number of cookies with 26 chips is 1.8 (Type an integer or decimal rounded to one decimal place as needed.) Consider the expected value to be close to the actual value if the absolute value of their difference is less than 1. How does this result compare to the actual number of cookies with 26 chocolate chips? O A. O B. ° C. The estimated number of cookies with 26 chips is less than the actual number. The estimated number of cookies with 26 chips is greater than the actual number. The estimated number of cookies with 26 chips is close to the actual number.Explanation / Answer
a)
Excel formula
b)
actual number of cookie with 26 chips = 1
since 1< 1.8
option A) is correct
P(X = 26) 0.054166 expected number 1.841645