Assignment 4.xlsx - C Regression Statistics Multiple R...

This preview shows page 1 - 9 out of 26 pages.

C Regression Statistics Multiple R 0.921908536 R Square 0.849915348 Adjusted R Sq0.824901239 Standard Erro16.00644165 Observations 15 ANOVA df SS MS F Significance F Regression 2 17410.45924 8705.229622 33.97743887 1.14292E-05 Residual 12 3074.47409 256.2061742 Total 14 20484.93333 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 1307.751804 131.7366807 9.927013476 3.87608E-07 1020.722234 1594.781374 X Variable 1 0.800692604 0.292935137 2.73334436 0.01815373 0.16244177 1.438943439 X Variable 2 10.07951138 4.756436108 2.119131036 0.055620912 -0.28387264 20.44289539
Image of page 1

Subscribe to view the full document.

Lower 95.0% Upper 95.0% 1020.722234 1594.781374 0.16244177 1.438943439 -0.28387264 20.44289539
Image of page 2
Source DF SS MS F Regressio 2 78.926 39.463 4.59 Error 68 584.603 8.597 Total 70 663.529 n=71 k=2 Câu 12 Sales Store Parking Incomes 1 1767 510 5 45 2 1834 557 8 46 3 1747 489 4 46 4 1701 473 4 47 5 1773 529 6 47 6 1805 559 7 52 7 1773 525 5 47 8 1767 518 4 44 9 1767 514 4 44 10 1787 502 6 43 11 1833 560 8 52 12 1734 498 4 45 13 1785 517 4 47 14 1843 543 8 49 15 1773 507 5 46 SUMMARY OUTPUT Regression Statistics Multiple R 0.93649158901 R Square 0.87701649628 Adjusted R Square 0.84347554072 Standard Error 15.1336736958 Observations 15
Image of page 3

Subscribe to view the full document.

ANOVA df Regression 3 Residual 11 Total 14 Coefficient Intercept 1374.246 X Variable 1 0.94172 X Variable 2 11.29017 X Variable 3 -3.138346
Image of page 4
C
Image of page 5

Subscribe to view the full document.

SS MS F Significance F 17965.6244585 5988.541486 26.14763001 2.6354028996632E-05 2519.30887484 229.0280795 20484.9333333 Standard E t Stat P-value Lower 95% Upper 95Lower 95 131.6725 10.4369 4.8E-07 1084.4369284 1664.06 1084.44 0.291399 3.23172 0.00799 0.3003558448 1.58308 0.30036 4.563819 2.47384 0.03091 1.2452744504 21.3351 1.24527 2.015738 -1.5569 0.14777 -7.574954673 1.29826 -7.575
Image of page 6
Upper 95.0% 1664.06 1.58308 21.3351 1.29826
Image of page 7

Subscribe to view the full document.

SUMMARY OUTPUT Regression Statistics Multiple R 0.9308846021 R Square 0.8665461425 Adjusted R Sq 0.8443038329 Standard Erro 15.688072032 Observations 15 ANOVA df SS MS F Significance F Regression 2 19177.01275 9588.506376 38.95935982 5.6492E-06 Residual 12 2953.387249 246.1156041 Total 14 22130.4 Coefficients Standard Error t Stat P-value
Image of page 8
Image of page 9

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes