Please provide the regression model in Excel and teach me step-by-step how to get the correct regression model.

1 answer below »

Please provide the regression model in Excel and teach me step-by-step how to get the correct regression model.

1. Please use data pizza4.dat to estimate the coefficients of the following model. Please provide the Excel results. Data pizzafemalehscollegegradincomeage 109100019.525 010003945 0100015.620 10810002628 220110019.525 18911003935 64110015.640 262110015.622 64110036.430 35110028.621 94110057.240 7110101321 4031010288.645 41101041.636 10101058.536 110101071.540 239101037.723 63101050.732 010109152 106100171.530 0100111745 14100007.832 299000023.420 148000071.555 42401001318 242010029.930 119010045.545 338010049.440 135010058.550 5900100110.532 324010028.630 87010032.551 395001037.722 5130010171.640 56001045.530 400001010436 384001071.527 26200103924 336001035.121 281000110445

question-o0qf41nq.docx pizza4-xpfubqby.xlsx pizza4-feqkns4t.def

Answered Same DayMay 08, 2023

Answer To: Please provide the regression model in Excel and teach me step-by-step how to get the correct...

Atul answered on May 08 2023

38 Votes

Sheet4
    SUMMARY OUTPUT
    Regression Statistics
    Multiple R    0.5738038291
    R Square    0.3292508343
    Adjusted R Square    0.2929941227
    Standard Error    131.0700989746
    Observations    40
    ANOVA
        df    SS    MS    F    Significance F
    Regression    2    312015.178727045    156007.589363522    9.0811002783    0.0006185326
    Residual    37    635636.721272955    17179.370845215
    Total    39    947651.9
        Coefficients    Standard Error    t Stat    P-value    Lower 95%    Upper 95%    Lower 95.0%    Upper 95.0%
    Intercept    342.8848278531    72.3434196586    4.7396823301    0.0000314373    196.303136191    489.4665195152    196.303136191    489.4665195152
    income    1.8324789338    0.4643007414    3.9467499627    0.0003409429    0.891716271    2.7732415966    0.891716271    2.7732415966
    age    -7.5755558941    2.316987583    -3.2695712094    0.0023326067    -12.2702186717    -2.8808931164    -12.2702186717    -2.8808931164
    RESIDUAL OUTPUT
    Observation    Predicted...

SOLUTION.PDF

Please provide the regression model in Excel and teach me step-by-step how to get the correct regression model.

Answer To: Please provide the regression model in Excel and teach me step-by-step how to get the correct...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment