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
The closing stock price for each of two stocks was recorded over a 12-month period. the closing price for the Dow Jones
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
The closing stock price for each of two stocks was recorded over a 12-month period. the closing price for the Dow Jones
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!