1. 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. Seven 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.01 (Round off each element from the output to three decimal places when reporting). Excel Output: 10 points a) Identify the claim and state the null and alternative hypothesis. (3p) b) 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?) (2p) c) What is the critical value at the 1% 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. (3p) d) What is the standardized test statistic? (2p) e) What decision should be made about the analysts claim? In other words, should you reject or retain the null hypothesis? (5p) f) At 1% level of significance, is there enough evidence to support the analysts claim? Interpret the decision in the context of the original claim. (5p)

1. 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. Seven 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.01 (Round off each element from the output to three decimal places when reporting). Excel Output: 10 points a) Identify the claim and state the null and alternative hypothesis. (3p) b) 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?) (2p) c) What is the critical value at the 1% 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. (3p) d) What is the standardized test statistic? (2p) e) What decision should be made about the analysts claim? In other words, should you reject or retain the null hypothesis? (5p) f) At 1% level of significance, is there enough evidence to support the analysts claim? Interpret the decision in the context of the original claim. (

PLEASE USE EXCEL AND SHOW THE PROCESS THANKYOU5p)

Stock Price (first hour) Price (second hour) 1 183.72 182.85 2 31.46 31.62 3 64.26 64.2 68.11 68.2 174.53 174.18 6 35.57 35.65 92.85 93.19 OWN