The closing stock price for each of two stocks was recorded over a 12-month period. the closing price for the Dow Jones
Posted: Wed May 04, 2022 1:02 pm
The closing stock price for each of two stocks was recorded over
a 12-month period. the closing price for the Dow Jones
Industrial Average (DJIA) was also recorded over this same time
period. These values are shown in the following table.
a) Develop a regression model by running regression to
predict the price of stock 1 based on the Dow Jones
Industrial Average. Place the regression on a separate
Sheet named "Stock 1Reg". What price would Stock 1 be
if DJIA was 12,365? (DO NOT USE THE FORECAST FORMULA)
b) Which of the two stocks is most highly correlated to the Dow
Jones Industrial Average over this time period?
c) Do a Trend Analysis Scatterplot with the DJIA? Forecast
the DJIA for Month 14? (DO NOT USE THE FORECAST FORMULA
a 12-month period. the closing price for the Dow Jones
Industrial Average (DJIA) was also recorded over this same time
period. These values are shown in the following table.
a) Develop a regression model by running regression to
predict the price of stock 1 based on the Dow Jones
Industrial Average. Place the regression on a separate
Sheet named "Stock 1Reg". What price would Stock 1 be
if DJIA was 12,365? (DO NOT USE THE FORECAST FORMULA)
b) Which of the two stocks is most highly correlated to the Dow
Jones Industrial Average over this time period?
c) Do a Trend Analysis Scatterplot with the DJIA? Forecast
the DJIA for Month 14? (DO NOT USE THE FORECAST FORMULA