In the question, look for the keywords such as mean/average, proportion/percentage, variance/standard deviation! In this case, we have "standard deviation of the capsule weights in the production line" and two populations, thus we are going to perform Two Variances F Hypothesis Test.
Find the sample standard deviations for each production line:
- 
\(STDEV.S(A2:E4)\approx 1.074\)
- 
\(STDEV.S(A8:E11)\approx 1.909\)
 
Since 
\(1.909\gt 1.074\text{,}\) weβll let 
\(s_1\approx 1.909\) and 
\(s_2\approx 1.074\text{,}\) and this will be a right-tailed test.
Hypotheses:
\begin{equation*}
H_0: \;\;\sigma_1^2 \leq \sigma_2^2, 
\end{equation*}
where \(\sigma_1\) is the standard deviation of the capsule weights in production line 2 and \(\sigma_2\) is the standard deviation of the capsule weights in production line 1 and the units are mg.
\begin{equation*}
H_1: \;\;\sigma_1^2 \gt \sigma_2^2
\end{equation*}
 
Test statistic:
\begin{equation*}
F=\frac{s_1^2}{s_2^2}\approx \frac{1.074^2}{1.909^2}\approx 3.1574
\end{equation*}
 
Now find the p-value:
\begin{equation*}
F.DIST.RT(3.1574,16-1,11-1)\approx 0.0359
\end{equation*}
 
Since the p-value is less than 
\(\alpha\text{,}\) we reject the null hypothesis and conclude that 
\(\sigma_1^2 \gt \sigma_2^2\text{,}\) so Production line 2 has a larger standard deviation of capsult weights than Production line 1.
(Alternatively, we can use the βF-Test Two-Sample for Variancesβ in the Data Analysis tool in Excel.)