In: Math
A quality standard says that no more than 2 percent of the eggs sold in a store may be cracked (not broken, just cracked). In 3 cartons (12 eggs each carton), 2 eggs are cracked. |
(a) |
Calculate a p-value for the observed sample result. Hint: Use Excel to calculate the binomial probability P(X ≥ 2 | n = 36, ππ = .02) = 1 – P(X ≤ 1 | n = 36, ππ = .02). (Round your answer to 4 decimal places.) |
P(X ≥ 2) |
(b) |
We fail to reject the null hypothesis at α = 0.10. |
||||
|
(c) |
This sample shows that the standard is exceeded. |
||||
|
The Binomial Cumulative Probability has been calculated by going through the following steps:
Formulas>More Functions>Statistical>BINOM.DIST
Then, in the dialog box the opens up, we put:
Number_s=2
Trials=36
Probability_s=0.02
Cumulative=TRUE
This will give you the required probability. One can go through the help section to know what these terms mean.
Please rate my solution if you find it useful.
Thank you.