Solved

Below You Are Given a Partial Excel Output Based on a Sample

Question 22

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).  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 (x<sub>1</sub>), and the stock price of the company's major competitor (x<sub>2</sub> 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  \alpha  = 0.05, test to determine if the Dow Jones average is a significant variable. d.At  \alpha  = 0.05, test to determine if the stock price of the major competitor is a significant variable.
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 α\alpha = 0.05, test to determine if the Dow Jones average is a significant variable.
d.At α\alpha = 0.05, test to determine if the stock price of the major competitor is a significant variable.

Correct Answer:

verifed

Verified

a.= 20 + 0.03x1 - 0...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions