View the step-by-step solution to:

SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.29734201 0.08841227 0.07153102 159.063637 56...

CEO of Big Giant Fish supermarket suspects that customers who shop more frequently tend to spend less on each shopping trip. To investigate this trend he would like you to conduct a simple linear regression using the number of shopping trips per month as the independent variable and the amount spent per trip as the dependent vavaiable.

SUMMARY OUTPUT Regression Statistics Multiple R 0.29734201 R Square 0.08841227 Adjusted R Square 0.07153102 Standard Error 159.063637 Observations 56 ANOVA df SS MS F Significance F Regression 1 132510.3084 132510.3 5.237305 0.026046467 Residual 54 1366266.99 25301.24 Total 55 1498777.298 Coefficient s Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Uppe r 95.0 % Intercept 257.97389 1 58.6336814 3 4.39975 6 5.14E-05 140.420437 7 375.527 3 140.42043 8 375.5 2734 47 Box Office 0.1847556 3 0.08073163 6 2.28851 6 0.02604 6 0.02289844 4 0.34661 3 0.0228984 4 0.346 6128 13 RESIDUAL OUTPUT Observation Predicted Budget Residuals 1 597.0004692 192.2995308 2 466.5999467 -89.59994672 3 453.9257106 -132.5257106 4 436.9466684 -98.64666838 5 435.0436854 -126.1436854 6 431.089915 -124.789915 7 428.9652252 82.73477477 8 428.0414471 -74.04144709 9 427.9490693 85.85093072 10 426.4710242 10.02897575 11 422.8128628 -122.0128628 12 421.5565245 -67.55652454 13 418.0461676 -145.6461676 14 416.9930605 -82.69306052 15 415.6073933 -75.9073933 16 414.7390419 -136.7390419 17 408.1986926 9.30130739 18 407.0162566 12.68374341 19 405.3904071 678.9095929 20 403.8938865 -154.4938865 21 402.8223038 -29.42230383
Background image of page 1
22 400.5867607 45.61323928 23 397.8339019 462.7660981 24 393.898607 -112.398607 25 383.6077185 86.59228152 26 380.1897394 -31.78973936 27 378.6562676 -73.25626764 28 377.7509651 -54.75096506 29 374.5916438 -113.1916438 30 371.4877493 -70.48774926 31 371.0073846 -0.70738463 32 366.4623962 -37.86239617 33 363.8388663 199.2611337 34 358.7396109 -117.7396109 35 356.6149212 230.1850788 36 356.5964456 45.00355438 37 354.8227916 -82.22279159 38 353.6034044 -47.00340444 39 352.5502974 -73.35029736 40 350.7951189 -39.09511889 41 349.4279272 -19.72792724 42 347.7096999 -55.9096999 43 346.5272639 -68.42726388 44 344.9937922 437.7062078 45 344.7536098 -59.65360985 46 342.7767246 -100.1767246 47 336.3657043 -74.96570432 48 336.1624731 -20.56247313 49 334.2779657 40.92203428 50 333.3541876 -96.35418758 51 328.9200525 190.7799475 52 323.8392727 -72.83927272 53 320.7908049 -29.89080486 54 318.7769685 -77.87696851 55 316.430572 99.96942797 56 311.8486324 79.85136756
Background image of page 2
Sign up to view the entire interaction

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question