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₁), and the stock price of the company's major competitor (x₂ 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.

Question

Quizplus · Accepted Answer

The Answer of 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₁), and the stock price of the company's major competitor (x₂ 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.

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