Question: Just like the solution of Question 9 below, give the business interpretation of the coefficients and analyze all data just like Question 9.

Regression Analysis: Y versus c2, c4, c9

Y = Stock Price of Apple Inc.

C2 = Number of New Retail Stores Opened

C4 = Consumer Price Confidence

C9 = Microsoft Stock Price

The regression equation is

Y = - 190 + 0.522c2 - 0.720c4 + 9.78c9

Predictor Coef SE Coef T P VIF

Constant -190.05 43.91 -4.33 0.000

c2 0.5221 0.1608 3.25 0.005 5.157

c4 -0.7197 0.3558 -2.02 0.059 6.034

c9 9.784 1.484 6.59 0.000 1.888

S = 18.2461 R-Sq = 91.7% R-Sq(adj) = 90.2%

PRESS = 7945.30 R-Sq(pred) = 88.36%

Analysis of Variance

Source DF SS MS F P

Regression 3 62574 20858 62.65 0.000

Residual Error 17 5660 333

Total 20 68234

No replicates.

Cannot do pure error test.

Durbin-Watson statistic = 1.90419

No evidence of lack of fit (P >= 0.1).

Price: $2.99

Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document