60.1K

Verified Solution

Link Copied!

Data for APPLE INC

Date : 2017 Q1 - 2021 Q4

i) write the appropriate hypotheses related to the model

ii) Identify, which independent variable is not appropriate in the model if any.

iii) Find the best multiple regression model for predicting the stock prices using the p-value criteria.

iv) Determine if any interaction exists between total debt and net profit, and find the best model.

5 A B D 1 Y-Stock Price X1-Total Debt X2-Net Profit X3-Total Assets 2 35.91 84531 11029 334532 3 3 36 89864 8717 345173 4 38.53 97207 10714 375319 42.3 103922 20065 406794 6 41.94 101362 13822 367502 7 46.27 97128 11519 349197 8 56.43 93735 14125 365725 9 39.43 92989 19965 373719 10 47.48 90201 11561 341998 11 49.48 84936 10044 322239 12 55.95 91807 13686 338516 13 73.41 93078 22236 340618 14 63.57 89086 11249 320400 15 91.2 94048 11253 317344 16 115.81 98667 12673 323888 17 132.69 99281 28755 354054 18 122.15 108642 23630 337158 19 136.96 105752 21744 329840 20 141.5 109106 20551 351002 SUMMARY OUTPUT Regression Statistics Multiple R Square Adjusted R Square Standard Error Observations 0.939393 0.882460797 0.857273825 14.50908365 18 ANOVA g Sion conceF 9.224015-07 Regression Residual Total 3 14 17 SS 22126.90565 2947.189117 25074.0965 MS 7375.635225 35.00533878 210.5135064 tercept 84531 11029 334532 Coefficients 111.0546475 0.00107953 0.002895199 -0.001100514 Standard Error 69.60274679 0.000655312 0.000769415 0.000159115 Stot P-valve 1.595549782 0.13290877 4.72744375 0.00032395 3.762855466 0.002099348 -6.916459931 7.134396.06 Lower 95% -18.22819723 0.00169049 0.001264967 -0.001441783 Upper 95% 260.3370922 0.004503456 0.004545431 -0.000759246 Lower 95.0% -18.228.19729 0.001690409 0.001244967 -0.001441783 Upper 95.00 2001370922 0.004503456 0.004545431 -0.000759245 5 A B D 1 Y-Stock Price X1-Total Debt X2-Net Profit X3-Total Assets 2 35.91 84531 11029 334532 3 3 36 89864 8717 345173 4 38.53 97207 10714 375319 42.3 103922 20065 406794 6 41.94 101362 13822 367502 7 46.27 97128 11519 349197 8 56.43 93735 14125 365725 9 39.43 92989 19965 373719 10 47.48 90201 11561 341998 11 49.48 84936 10044 322239 12 55.95 91807 13686 338516 13 73.41 93078 22236 340618 14 63.57 89086 11249 320400 15 91.2 94048 11253 317344 16 115.81 98667 12673 323888 17 132.69 99281 28755 354054 18 122.15 108642 23630 337158 19 136.96 105752 21744 329840 20 141.5 109106 20551 351002 SUMMARY OUTPUT Regression Statistics Multiple R Square Adjusted R Square Standard Error Observations 0.939393 0.882460797 0.857273825 14.50908365 18 ANOVA g Sion conceF 9.224015-07 Regression Residual Total 3 14 17 SS 22126.90565 2947.189117 25074.0965 MS 7375.635225 35.00533878 210.5135064 tercept 84531 11029 334532 Coefficients 111.0546475 0.00107953 0.002895199 -0.001100514 Standard Error 69.60274679 0.000655312 0.000769415 0.000159115 Stot P-valve 1.595549782 0.13290877 4.72744375 0.00032395 3.762855466 0.002099348 -6.916459931 7.134396.06 Lower 95% -18.22819723 0.00169049 0.001264967 -0.001441783 Upper 95% 260.3370922 0.004503456 0.004545431 -0.000759246 Lower 95.0% -18.228.19729 0.001690409 0.001244967 -0.001441783 Upper 95.00 2001370922 0.004503456 0.004545431 -0.000759245

Answer & Explanation Solved by verified expert

See Answer