A stock market analyst claims that seven of the stocks that make up the Dow Jones Industrial Average lost value from one hour to the next on one business day. Ten stock prices (in dollars per share) are recorded at one time during the day and then an hour later. To test the analysts claim, we run a significance testing using Excel. Based on the information provided in the Excel output answer following questions:

= 0.05 Round off three decimal places

please show your Excel Output

1.What type of statistical test was used to answer the stock market analysts research question? (Note: Is this a z-test or a t-test? One sample, dependent sample or independent sample?)

2. Identify the claim and state the null and alternative hypothesis.

3. What is the critical value at the 5% level of significance? Be sure and include whether this critical value is a z or t value and, if appropriate, include the degrees of freedom associated with this statistical test.

4. What is the standardized test statistic?

5. What decision should be made about the analysts claim? In other words, should you reject or retain the null hypothesis?

\begin{tabular}{|c|c|c|} \hline Stock & Price (first hour) & Price (second hour) \\ \hline 1 & 283.72 & 282.85 \\ \hline 2 & 41.46 & 41.62 \\ \hline 3 & 64.27 & 64.21 \\ \hline 4 & 69.12 & 68.21 \\ \hline 5 & 173.54 & 174.19 \\ \hline 6 & 35.57 & 35.45 \\ \hline 7 & 90.85 & 90.19 \\ \hline 8 & 72.15 & 73.18 \\ \hline 9 & 57.93 & 56.65 \\ \hline 10 & 103.3 & 103.1 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Stock & Price (first hour) & Price (second hour) \\ \hline 1 & 283.72 & 282.85 \\ \hline 2 & 41.46 & 41.62 \\ \hline 3 & 64.27 & 64.21 \\ \hline 4 & 69.12 & 68.21 \\ \hline 5 & 173.54 & 174.19 \\ \hline 6 & 35.57 & 35.45 \\ \hline 7 & 90.85 & 90.19 \\ \hline 8 & 72.15 & 73.18 \\ \hline 9 & 57.93 & 56.65 \\ \hline 10 & 103.3 & 103.1 \\ \hline \end{tabular}