Question: How do I find Y_hat & et/et-1 when there are three X variables? [4 pts.] Data from Net Profit hr], Total assets and Operating revenue

How do I find Y_hat & et/et-1 when there are three X variables?

How do I find Y_hat & et/et-1 when there are three Xvariables? [4 pts.] Data from Net Profit hr], Total assets and Operating

[4 pts.] Data from Net Profit hr], Total assets and Operating revenue is given in the Reg_Aute CUR worksheet. First run the regression using the Data Analysis Tool and fill-in the shaded areas for Regression eemgenents. Total Operating Net profit Total assets liabilities revenue y hat Regression result of Net profit (Y) et et-1 (Y) (X2) (X1) (X3) 4178 272681 523127 15455 SUMMARY OUTPUT 2844 268637 527757 48953 2761 275273 542557 50856 Regression Statistics 285977 556734 59925 Multiple R 0.585360952 3426 281774 557239 57535 R Square 0.342647444 -118 276781 557120 41149 Adjusted R Square 0.281020642 889 282685 555096 39638 Standard Error 4414.395442 2327 284442 66251 39806 Observations 36 165 305175 590460 38262 1707 306113 597471 39938 ANOVA 2802 315089 615212 43347 df SS MS F Significance F -3833 319180 623643 41657 Regression 3 325043577.1 108347859 5.56003934 0.003462885 2773 830884 641561 48564 Residual 32 623580387.9 19486887.12 6165 833919 647314 46328 Total 35 948623965 1629 348507 563182 46166 7797 357517 563271 40648 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% -9453 368437 665657 30196 Intercept 21566.48087 15320.87954 -1.407652923 0.168874346 -52774.09127 9641.129521 -52774.09127 9641.129521 -6416 867771 562663 30689 Total liabilities (X1) -0.028969642 0.077090608 -0.375786913 0.709555083 -0.185998071 0.128058788 -0.185998071 0.128058788 18818 367139 647082 28421 Total assets (X2) 0.026208628 0.059707573 0.438949815 0.663647584 -0.095411717 0.147828973 -0.095411717 0.147828973 364422 631959 0.34443753 0.091662754 0.597212307 14080 28572 Operating revenue (X3) 0.124095753 2.775578722 0.009127446 0.091662754 0.597212307

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!