Please a hand written solution is needed not mini tab or excel, thanks. 58. The Dow Jones Industrial Average (DJIA) and the Standard & Poor's 500 (S&P 500)indexes are used as measures of overall movement in the stock market. The DJIA is basedon the price movements of 30 large companies; the S&P 500 is an index composed of 500stocks. Some say the S&P 500 is a better measure of stock market performance because itis broader based. The closing price for the DJIA and the S&P 500 for 15 weeks, beginningwith January 6, 2012, follow (Barron's website, April 17, 2012).DateDJIAS&PJanuary 6January 13January 20January 27February 3February 10February 17February 24March 212,36012,42212,72012,66012,86212,80112781289131513161345DATA File134312,95012,9831362DJIAS&P500136612,97812,9221370March 9March 16137113,23313,08113,21213,06012,8501404March 23March 30April 5April 131397140813981370a. Develop a scatter diagram with DJIA as the independent variable.b. Develop the estimated regression equation.c. Test for a significant relationship. Use a = .05.d. Did the estimated regression equation provide a good fit? Explain.e. Suppose that the closing price for the DJIA is 13,500. Predict the closing price for theS&P 500.f. Should we be concerned that the DJIA value of 13,500 usced to predict the S&P 500value in part (e) is beyond the range of the data used to develop the estimated regres-sion equation?

Name: Please a hand written solution is needed not mini tab or excel, thanks
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: Please a hand written solution is needed not mini tab or excel, thanks. 58. The Dow Jones Industrial Average (DJIA) and the Standard & Poor's 500 (S&P 500)indexes are used as measures of overall movement in the stock market. The DJIA is basedon the p