Test the statistical significance of the independent variables and the regression equation, indicating how it will impact your decision to open the pizza shop.

Transcribed Image Text:

The Pizza Company Market Demand (Q) Price (P) 7.62 7.29 6.66 8.01 7.53 6.51 6.20 7.28 5.95 6.42 5.94 6.47 6.99 7,72 6.46 7.31 7.36 6.19 7.95 6.34 5.54 7.89 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 596,611 596,453 599,201 572,258 558,142 627,973 593,024 565,004 596,254 652,880 596,784 657,468 519,866 612,941 621,707 597,215 617,427 572,320 602,400 575,004 667,581 569,880 644,684 605,468 599,213 610.735 603,830 617,803 529,009 573,211 6.76 6.39 6.42 6.82 7.10 7.77 8.07 6.91 Competitor Price (Pr) Advertising (Ad) Income (1) 200,259 54,880 204,559 51,755 206,647 52,955 207,025 54,391 207,422 48,491 216,224 51,219 217,954 48,685 220,139 47,219 220,215 49,775 220,728 54,932 226,603 48,092 228,620 54,929 230,241 46,057 232,777 237,300 238,765 241,957 251,317 254,393 6.54 5.01 5.96 5.30 6.16 7.56 7.15 6.97 5.52 6.27 5.66 7.68 5.10 5.38 6.20 7.43 5.28 6.12 6.38 5.67 7.08 5.10 7.22 5.21 6.00 6.97 5.30 6.96 5.76 5.96 255,699 262,270 275,588 277,667 277,816 279,031 279.934 287,921 289,358 294,787 296,246 55,239 53,976 49,576 55,454 48,480 53,249 49,696 52,600 50,472 53,409 52,660 50,464 49.525 49,489 49,375 48,254 46,017 The Pizza Company Market Demand (Q) Price (P) 7.62 7.29 6.66 8.01 7.53 6.51 6.20 7.28 5.95 6.42 5.94 6.47 6.99 7,72 6.46 7.31 7.36 6.19 7.95 6.34 5.54 7.89 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 596,611 596,453 599,201 572,258 558,142 627,973 593,024 565,004 596,254 652,880 596,784 657,468 519,866 612,941 621,707 597,215 617,427 572,320 602,400 575,004 667,581 569,880 644,684 605,468 599,213 610.735 603,830 617,803 529,009 573,211 6.76 6.39 6.42 6.82 7.10 7.77 8.07 6.91 Competitor Price (Pr) Advertising (Ad) Income (1) 200,259 54,880 204,559 51,755 206,647 52,955 207,025 54,391 207,422 48,491 216,224 51,219 217,954 48,685 220,139 47,219 220,215 49,775 220,728 54,932 226,603 48,092 228,620 54,929 230,241 46,057 232,777 237,300 238,765 241,957 251,317 254,393 6.54 5.01 5.96 5.30 6.16 7.56 7.15 6.97 5.52 6.27 5.66 7.68 5.10 5.38 6.20 7.43 5.28 6.12 6.38 5.67 7.08 5.10 7.22 5.21 6.00 6.97 5.30 6.96 5.76 5.96 255,699 262,270 275,588 277,667 277,816 279,031 279.934 287,921 289,358 294,787 296,246 55,239 53,976 49,576 55,454 48,480 53,249 49,696 52,600 50,472 53,409 52,660 50,464 49.525 49,489 49,375 48,254 46,017

Answer rating: 100% (QA)

Regression Statistics Multiple R 0912678 R Square 0832981 Adjusted R Square 0806258 Standard Error 1487595 Observations 30 ANOVA df SS MS F Significan... View the full answer