A sample of 10 earnings per share estimates is shown below. $$\begin{array} { l l l l l }
2.92 & 4.60 & 4.20 & 3.10 & 3.66 \
7.22 & 2.54 & 1.45 & 2.88 & 3.64
\end{array}$$ Use Excel to estimate the variance with a 95% level of confidence.

Question

A sample of 10 earnings per share estimates is shown below. $$\begin{array} { l l l l l } 
2.92 & 4.60 & 4.20 & 3.10 & 3.66 \
7.22 & 2.54 & 1.45 & 2.88 & 3.64
\end{array}$$ Use Excel to estimate the variance with a 95% level of confidence.

Quizplus · Accepted Answer

The Answer of A sample of 10 earnings per share estimates is shown below. $$\begin{array} { l l l l l } 
2.92 & 4.60 & 4.20 & 3.10 & 3.66 \
7.22 & 2.54 & 1.45 & 2.88 & 3.64
\end{array}$$ Use Excel to estimate the variance with a 95% level of confidence.

A Sample of 10 Earnings Per Share Estimates Is Shown 2.924.604.203.103.667.222.541.452.883.64\begin{array} { l l l l l } 2.92 & 4.60 & 4.20 & 3.10 & 3.66 \\7.22 & 2.54 & 1.45 & 2.88 & 3.64\end{array}2.927.22​4.602.54​4.201.45​3.102.88​3.663.64​

A Sample of 10 Earnings Per Share Estimates Is Shown $\begin{array} { l l l l l } 2.92 & 4.60 & 4.20 & 3.10 & 3.66 \\7.22 & 2.54 & 1.45 & 2.88 & 3.64\end{array}$