The sponsors of televisions shows targeted at the market of 5- to 8-year olds want to test the hypothesis that children watch television AT MOST 20 hours per week. The population of viewing hours per week is known to be normally distributed with a standard deviation of 6 hours. A market research firm conducted a random sample of 30 children in this age group. The resulting data follow: $$\begin{array} { l l l l l l }
19.5 & 29.7 & 17.5 & 10.4 & 19.4 & 18.4 \
14.6 & 10.1 & 12.5 & 18.2 & 19.1 & 30.9 \
22.2 & 19.8 & 11.8 & 19.0 & 27.7 & 25.3 \
27.4 & 26.5 & 16.1 & 21.7 & 20.6 & 32.9 \
27.0 & 15.6 & 17.1 & 19.2 & 20.1 & 17.7
\end{array}$$ At a .10 level of significance, use Excel to test the sponsors' hypothesis.

Question

The sponsors of televisions shows targeted at the market of 5- to 8-year olds want to test the hypothesis that children watch television AT MOST 20 hours per week. The population of viewing hours per week is known to be normally distributed with a standard deviation of 6 hours. A market research firm conducted a random sample of 30 children in this age group. The resulting data follow: $$\begin{array} { l l l l l l } 
19.5 & 29.7 & 17.5 & 10.4 & 19.4 & 18.4 \
14.6 & 10.1 & 12.5 & 18.2 & 19.1 & 30.9 \
22.2 & 19.8 & 11.8 & 19.0 & 27.7 & 25.3 \
27.4 & 26.5 & 16.1 & 21.7 & 20.6 & 32.9 \
27.0 & 15.6 & 17.1 & 19.2 & 20.1 & 17.7
\end{array}$$ At a .10 level of significance, use Excel to test the sponsors' hypothesis.

Quizplus · Accepted Answer

The Answer of The sponsors of televisions shows targeted at the market of 5- to 8-year olds want to test the hypothesis that children watch television AT MOST 20 hours per week. The population of viewing hours per week is known to be normally distributed with a standard deviation of 6 hours. A market research firm conducted a random sample of 30 children in this age group. The resulting data follow: $$\begin{array} { l l l l l l } 
19.5 & 29.7 & 17.5 & 10.4 & 19.4 & 18.4 \
14.6 & 10.1 & 12.5 & 18.2 & 19.1 & 30.9 \
22.2 & 19.8 & 11.8 & 19.0 & 27.7 & 25.3 \
27.4 & 26.5 & 16.1 & 21.7 & 20.6 & 32.9 \
27.0 & 15.6 & 17.1 & 19.2 & 20.1 & 17.7
\end{array}$$ At a .10 level of significance, use Excel to test the sponsors' hypothesis.

The Sponsors of Televisions Shows Targeted at the Market of 5-