The specifications for the filling of soft drink bottles is a variance of .05 (ounces)². A sample of 20 bottles of soft drink showed the following results: $$\begin{array} { l l l l l } 12.03 & 12.01 & 11.89 & 12.15 & 12.23 \ 11.97 & 12.10 & 11.85 & 12.33 & 12.02 \ 11.96 & 12.00 & 11.82 & 12.02 & 11.99 \ 11.96 & 11.83 & 11.84 & 12.21 & 12.38 \end{array}$$ At a 5% level of significance, use Excel to determine whether or not the variance of the population is significantly different from .05.

Question

Quizplus · Accepted Answer

The Answer of The specifications for the filling of soft drink bottles is a variance of .05 (ounces)². A sample of 20 bottles of soft drink showed the following results: $$\begin{array} { l l l l l } 12.03 & 12.01 & 11.89 & 12.15 & 12.23 \ 11.97 & 12.10 & 11.85 & 12.33 & 12.02 \ 11.96 & 12.00 & 11.82 & 12.02 & 11.99 \ 11.96 & 11.83 & 11.84 & 12.21 & 12.38 \end{array}$$ At a 5% level of significance, use Excel to determine whether or not the variance of the population is significantly different from .05.

The Specifications for the Filling of Soft Drink Bottles Is