Essay
Below you are given a partial Excel output based on a sample of 30 days of the price of a company's stock (y in dollars), the Dow Jones industrial average (x1), and the stock price of the company's major competitor (x2 in dollars).
a.Use the output shown above and write an equation that can be used to predict the price of the stock.
b.If the Dow Jones Industrial Average is 2650 and the price of the competitor is $45, what would you expect the price of the stock to be?
c.At = 0.05, test to determine if the Dow Jones average is a significant variable.
d.At = 0.05, test to determine if the stock price of the major competitor is a significant variable.
Correct Answer:

Verified
a.= 20 + 0.03x1 - 0...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q10: Exhibit 15-2<br>A regression model between sales (Y
Q14: Exhibit 15-6<br>Below you are given a partial
Q18: Exhibit 15-6<br>Below you are given a partial
Q19: Exhibit 15-5<br>Below you are given a partial
Q23: In a regression model involving 46 observations,
Q25: The following is part of the
Q27: In order to determine whether or
Q57: Exhibit 15-6<br>Below you are given a partial
Q83: Exhibit 15-7<br>A regression model involving 4 independent
Q94: In multiple regression analysis,<br>A)there can be any