M6 Calculations.xlsx - Dollars spent on Prepared food 495.86 642.77 364.81 619.3 238.71 378.94 302.58 231.74 428.67 286.99 268.81 329.81 627.25 421.52

M6 Calculations.xlsx - Dollars spent on Prepared food...

This preview shows page 1 - 3 out of 3 pages.

Dollars spent on Prepared food Family size Gross monthly income 495.86 4 3126 642.77 5 3933 364.81 3 1925 619.3 5 3736 238.71 1 1453 378.94 2 2538 302.58 1 1798 231.74 2 1189 428.67 3 2247 286.99 3 1460 268.81 1 1567 329.81 2 1622 627.25 5 3828 421.52 3 2782 656.38 5 3978 400.64 3 2493 603.41 6 3753 560.69 4 3778 623 5 3609 416.12 2 2262 323.9 1 1966 418.78 3 2736 506.46 4 3274 552.53 2 3480 586.46 4 3741 637.18 8 3684 244.49 2 1476 507.19 5 2835 512.56 5 2873 312.89 1 1618 329.05 2 1565 243.49 2 1582 560.37 8 3380 599.9 5 3922 657.09 5 3845 394.82 2 2233 556.42 4 3098 596.05 8 3707 365.8 4 2071 489.08 3 3166
Image of page 1
SUMMARY OUTPUT Regression Statistics Multiple R 0.980501258 R Square 0.9613827169 Adjusted R Square 0.9592952961 Standard Error 27.830771717 Observations 40 ANOVA df SS MS F Significance F Regression 2 713455.37799 356727.68899 460.56011226 7.1690524E-27 Residual 37 28658.418611 774.55185436 Total 39 742113.7966 Coefficients Standard Error t Stat P-value Lower 95% Intercept 61.421654885 14.32509969 4.2876947607 0.00012396 32.396245862 Family size 9.6930919486 3.607684799 2.6867901407 0.0107424098 2.3832281999 Gross monthly income 0.1321655888 0.0075353542 17.5393996 1.6178003E-19 0.1168975109
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Fall '16
  • 3rd millennium, R Square, 23rd century

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes