I need this statistics project completed. and have to show all the work! Please see attachment

1 answer below »
I need this statistics project completed. and have to show all the work! Please see attachment
Answered Same DayApr 09, 2021

Answer To: I need this statistics project completed. and have to show all the work! Please see attachment

Suraj answered on Apr 09 2021
134 Votes
Sheet4
        Annual sales ($ millions) Y    # of retail outlets, X1    # of auto registered (mil), X2    Personal income ($ bil), X3    Averge age of auto (years), X4    # of supervisors, X5
    Annual sales ($ millions) Y    1
    #
of retail outlets, X1    0.90    1
    # of auto registered (mil), X2    0.60    0.78    1
    Personal income ($ bil), X3    0.96    0.82    0.41    1
    Averge age of auto (years), X4    -0.32    -0.49    -0.45    -0.35    1
    # of supervisors, X5    0.29    0.18    0.40    0.15    0.29    1
Sheet5
    SUMMARY OUTPUT
    Regression Statistics
    Multiple R    0.9972
    R Square    0.9943
    Adjusted R Square    0.9872
    Standard Error    1.5070
    Observations    10
    ANOVA
        df    SS    MS    F    Significance F
    Regression    5    1593.809684167    318.7619368334    140.3573934218    0.0001397285
    Residual    4    9.084293433    2.2710733582
    Total    9    1602.8939776
        Coefficients    Standard Error    t Stat    P-value    Lower 95%    Upper 95%    Lower 95.0%    Upper 95.0%
    Intercept    -19.6715    5.4218    -3.6282    0.0222    -34.724896404    -4.6181255957    -34.724896404    -4.6181255957
    # of retail outlets, X1    -0.0006    0.0026    -0.2383    0.8234    -0.0079539502    0.0066967292    -0.0079539502    0.0066967292
    # of auto registered (mil), X2    1.7399    0.5530    3.1463    0.0346    0.2045089588    3.275293242    0.2045089588    3.275293242
    Personal income ($ bil), X3    0.4099    0.0439    9.3484    0.0007    0.288185364    0.5316853383    0.288185364    0.5316853383
    Averge age of auto (years), X4    2.0357    0.8779    2.3189    0.0812    -0.401709297    4.4731344221    -0.401709297    4.4731344221
    # of supervisors, X5    -0.0344    0.1880    -0.1832    0.8635    -0.5564167914    0.4875244496    -0.5564167914    0.4875244496
Sheet1
    Annual sales ($ millions) Y    # of retail outlets, X1    # of auto registered (mil), X2    Personal income ($ bil), X3    Averge age of auto (years), X4    # of supervisors, X5
    37.702    1739    9.27    85.4    3.5    9
    24.196    1221    5.86    60.7    5    5
    32.055    1846    8.81    68.1    4.4    7
    3.611    120    3.81    20.2    4    5
    17.625    1096    10.31    33.8    3.5    7
    45.919    2290    11.62    95.1    4.1    13
    29.6    1687    8.96    69.3    4.1    15
    8.114    241    6.28    16.3    5.9    11
    20.116    649    7.77    34.9    5.5    16
    12.994    1427    10.92    15.1    4.1    10
    If you have difficulty, please follow the steps demonstrated in Q25 posted on Moodle, as well as the review of...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here