In: Statistics and Probability
An Air Force base mess hall has received a shipment of 10,000-gallon size cans of cherries. The supplier claims that the average amount of liquid is 0.25-gallon size can. A government inspector took a random sample of 100 cans and found that the average liquid content to be 0.28 gallons per can with a standard deviation of 0.10. Does this indicate that the supplier’s claim is different from 0.25? (use a 5% significance level). Note: N > 30
*Please show the process of solving the answer, specifically in Excel*
We can use Excel function to find the p value as :
P-value = TDIST(T-statistic,n-1,2) = TDIST(3,100-1,2) = 0.0034
Hence, there is enough evidence to conclude that the average amount of liquid is different than 0.25 at 5% level of significance.