The data below shows samples of annual salaries (in $1000s) for accountants in two different firms. $$\begin{array}{l}
\text { Company A}&\text { Company B }\
74.8 & 83.3 \
78.2 & 65.7 \
69.9 & 82.1 \
84 & 78.5 \
65.7 & 69.7 \
66.8 & 77.7 \
72.1 & 66.7 \
77.4 & 78.4 \
79.3 & 79.2 \
69.1 & 80.1 \
& 74.9 \
& 69.8
\end{array}$$ Use Excel to determine whether the variance in salaries in Company A differs from that of Company B. Use a .10 level of significance.

Question

Quizplus · Accepted Answer

The Answer of The data below shows samples of annual salaries (in $1000s) for accountants in two different firms. $$\begin{array}{l}
\text { Company A}&\text { Company B }\
74.8 & 83.3 \
78.2 & 65.7 \
69.9 & 82.1 \
84 & 78.5 \
65.7 & 69.7 \
66.8 & 77.7 \
72.1 & 66.7 \
77.4 & 78.4 \
79.3 & 79.2 \
69.1 & 80.1 \
& 74.9 \
& 69.8
\end{array}$$ Use Excel to determine whether the variance in salaries in Company A differs from that of Company B. Use a .10 level of significance.

The Data Below Shows Samples of Annual Salaries (In $1000s)