Run Regression
Table 1
| Table 1. Adam’s Pizza Regional Market demand 2013-1-2013-4 | |||||||
| Unit Sales | Price | AdverEXP | Comp Price | Income | Pop | T | |
| Dallas | |||||||
| 2013-I | 212667.4 | 7.59 | 17409.7 | 8.14 | 53263.1 | 5561441.6 | 1 |
| 2013-2 | 187045.1 | 8.569 | 22900.9 | 5.698 | 53941.8 | 5600497.1 | 2 |
| 2013-3 | 272479.9 | 6.831 | 15468.2 | 6.215 | 54629.3 | 5639826.5 | 3 |
| 2013-4 | 201584.9 | 8.019 | 18670.3 | 7.26 | 55325.6 | 5679432 | 4 |
| 2014-1 | 310329.8 | 7.557 | 20696.5 | 7.491 | 56031.8 | 5719315.8 | 5 |
| 2014-2 | 223735.6 | 7.106 | 15593.6 | 5.742 | 56745.7 | 5759480.1 | 6 |
| 2014-3 | 184191.7 | 7.887 | 18733 | 6.149 | 57469.5 | 5799926 | 7 |
| 2014-4 | 397844.7 | 6.292 | 15901.6 | 6.831 | 58202.1 | 5840656.8 | 8 |
| Houston | |||||||
| 2013-I | 441985.5 | 7.227 | 29901.3 | 5.874 | 55501.6 | 10460392.8 | 1 |
| 2013-2 | 453543.2 | 7.282 | 30329.2 | 7.216 | 56210 | 10478695.7 | 2 |
| 2013-3 | 354169.2 | 8.602 | 37803.7 | 6.853 | 56926.1 | 10497030.5 | 3 |
| 2013-4 | 489759.6 | 7.227 | 29584.5 | 7.117 | 57652.1 | 10515397.2 | 4 |
| 2014-1 | 527684.3 | 7.601 | 33592.9 | 6.325 | 58386.9 | 10533795.8 | 5 |
| 2014-2 | 505316.9 | 7.128 | 29346.9 | 5.72 | 59131.6 | 10552226.3 | 6 |
| 2014-3 | 488444 | 7.084 | 29267.7 | 6.226 | 59885.1 | 10570689.8 | 7 |
| 2014-4 | 413650.6 | 8.569 | 36036 | 5.753 | 60649.6 | 10589185.2 | 8 |
| San Antonio | |||||||
| 2013-I | 280723.3 | 7.777 | 21868 | 8.206 | 48673.9 | 6548062.4 | 1 |
| 2013-2 | 297969.1 | 7.26 | 21066.1 | 7.359 | 49294.3 | 6585561.4 | 2 |
| 2013-3 | 363298.1 | 6.677 | 17317.3 | 7.095 | 49923.5 | 6623276 | 3 |
| 2013-4 | 344833.5 | 7.194 | 19263.2 | 5.984 | 50559.3 | 6661206.2 | 4 |
| 2014-1 | 342650 | 6.93 | 18682.4 | 6.226 | 51203.9 | 6699354.2 | 5 |
| 2014-2 | 407858 | 6.391 | 17267.8 | 7.282 | 51857.3 | 6737720 | 6 |
| 2014-3 | 167571.8 | 8.8 | 24262.7 | 8.173 | 52518.4 | 6776305.8 | 7 |
| 2014-4 | 352884.4 | 7.359 | 19206 | 7.513 | 53188.3 | 6815112.7 | 8 |
| OKC | |||||||
| 2013-I | 812636 | 6.831 | 47217.5 | 6.523 | 59321.9 | 14333266.2 | 1 |
| 2013-2 | 777716.5 | 7.854 | 55328.9 | 7.92 | 60078.7 | 14362849.6 | 2 |
| 2013-3 | 768956.1 | 5.973 | 41100.4 | 5.929 | 60844.3 | 14392493.5 | 3 |
| 2013-4 | 691721.8 | 8.03 | 55662.2 | 5.423 | 61619.8 | 14422199 | 4 |
| 2014-1 | 695127.4 | 8.36 | 58918.2 | 6.886 | 62405.2 | 14451966.1 | 5 |
| 2014-2 | 716278.2 | 7.964 | 53802.1 | 6.622 | 63201.6 | 14481793.7 | 6 |
| 2014-3 | 841636.4 | 7.766 | 54364.2 | 8.173 | 64006.8 | 14511684 | 7 |
| 2014-4 | 815500.4 | 6.809 | 48467.1 | 7.502 | 64823 | 14541635.9 | 8 |
| Tulsa | |||||||
| 2013-I | 320950.3 | 6.358 | 15285.6 | 6.798 | 64854.9 | 3493760.6 | 1 |
| 2013-2 | 168319.8 | 7.524 | 30171.9 | 5.566 | 65682.1 | 3503033.6 | 2 |
| 2013-3 | 631934.6 | 7.062 | 34794.1 | 7.887 | 66519.2 | 3512331.9 | 3 |
| 2013-4 | 82935.6 | 8.316 | 43093.6 | 5.39 | 67367.3 | 3521654.4 | 4 |
| 2014-1 | 649209 | 6.171 | 36891.8 | 6.083 | 68226.4 | 3531002.2 | 5 |
| 2014-2 | 316923.2 | 8.338 | 59007.3 | 6.061 | 69096.5 | 3540374.2 | 6 |
| 2014-3 | 304280.9 | 8.338 | 66312.4 | 6.424 | 69977.6 | 3549771.5 | 7 |
| 2014-4 | 574690.6 | 6.215 | 58954.5 | 7.128 | 70869.7 | 3559193 | 8 |
| Norman | |||||||
| 2013-I | 434845.4 | 6.886 | 24888.6 | 7.722 | 53588.7 | 5826807.8 | 1 |
| 2013-2 | 479713.3 | 6.325 | 24966.7 | 7.513 | 54271.8 | 5849834.1 | 2 |
| 2013-3 | 369971.8 | 7.546 | 28022.5 | 5.335 | 54963.7 | 5872952.8 | 3 |
| 2013-4 | 496453.1 | 7.073 | 28307.4 | 7.425 | 55664.4 | 5896161.7 | 4 |
| 2014-1 | 387399.1 | 7.139 | 26154.7 | 7.348 | 56373.9 | 5919463 | 5 |
| 2014-2 | 349054.2 | 8.338 | 30298.4 | 5.72 | 57093.3 | 5942855.6 | 6 |
| 2014-3 | 464700.5 | 6.787 | 26237.2 | 5.72 | 57821.5 | 5966341.7 | 7 |
| 2014-4 | 320059.3 | 8.745 | 33535.7 | 6.259 | 58558.5 | 5989920.2 | 8 |
Table 2
| Table 2. Regression Estimate | ||||||
| Unit Sales | Price | AdverEXP | Comp Price | Income | Pop | T |
| 212667.4 | 7.59 | 17409.7 | 8.14 | 53263.1 | 5561441.6 | 1 |
| 187045.1 | 8.569 | 22900.9 | 5.698 | 53941.8 | 5600497.1 | 2 |
| 272479.9 | 6.831 | 15468.2 | 6.215 | 54629.3 | 5639826.5 | 3 |
| 201584.9 | 8.019 | 18670.3 | 7.26 | 55325.6 | 5679432 | 4 |
| 310329.8 | 7.557 | 20696.5 | 7.491 | 56031.8 | 5719315.8 | 5 |
| 223735.6 | 7.106 | 15593.6 | 5.742 | 56745.7 | 5759480.1 | 6 |
| 184191.7 | 7.887 | 18733 | 6.149 | 57469.5 | 5799926 | 7 |
| 397844.7 | 6.292 | 15901.6 | 6.831 | 58202.1 | 5840656.8 | 8 |
| 441985.5 | 7.227 | 29901.3 | 5.874 | 55501.6 | 10460392.8 | 1 |
| 453543.2 | 7.282 | 30329.2 | 7.216 | 56210 | 10478695.7 | 2 |
| 354169.2 | 8.602 | 37803.7 | 6.853 | 56926.1 | 10497030.5 | 3 |
| 489759.6 | 7.227 | 29584.5 | 7.117 | 57652.1 | 10515397.2 | 4 |
| 527684.3 | 7.601 | 33592.9 | 6.325 | 58386.9 | 10533795.8 | 5 |
| 505316.9 | 7.128 | 29346.9 | 5.72 | 59131.6 | 10552226.3 | 6 |
| 488444 | 7.084 | 29267.7 | 6.226 | 59885.1 | 10570689.8 | 7 |
| 413650.6 | 8.569 | 36036 | 5.753 | 60649.6 | 10589185.2 | 8 |
| 280723.3 | 7.777 | 21868 | 8.206 | 48673.9 | 6548062.4 | 1 |
| 297969.1 | 7.26 | 21066.1 | 7.359 | 49294.3 | 6585561.4 | 2 |
| 363298.1 | 6.677 | 17317.3 | 7.095 | 49923.5 | 6623276 | 3 |
| 344833.5 | 7.194 | 19263.2 | 5.984 | 50559.3 | 6661206.2 | 4 |
| 342650 | 6.93 | 18682.4 | 6.226 | 51203.9 | 6699354.2 | 5 |
| 407858 | 6.391 | 17267.8 | 7.282 | 51857.3 | 6737720 | 6 |
| 167571.8 | 8.8 | 24262.7 | 8.173 | 52518.4 | 6776305.8 | 7 |
| 352884.4 | 7.359 | 19206 | 7.513 | 53188.3 | 6815112.7 | 8 |
| 812636 | 6.831 | 47217.5 | 6.523 | 59321.9 | 14333266.2 | 1 |
| 777716.5 | 7.854 | 55328.9 | 7.92 | 60078.7 | 14362849.6 | 2 |
| 768956.1 | 5.973 | 41100.4 | 5.929 | 60844.3 | 14392493.5 | 3 |
| 691721.8 | 8.03 | 55662.2 | 5.423 | 61619.8 | 14422199 | 4 |
| 695127.4 | 8.36 | 58918.2 | 6.886 | 62405.2 | 14451966.1 | 5 |
| 716278.2 | 7.964 | 53802.1 | 6.622 | 63201.6 | 14481793.7 | 6 |
| 841636.4 | 7.766 | 54364.2 | 8.173 | 64006.8 | 14511684 | 7 |
| 815500.4 | 6.809 | 48467.1 | 7.502 | 64823 | 14541635.9 | 8 |
| 320950.3 | 6.358 | 15285.6 | 6.798 | 64854.9 | 3493760.6 | 1 |
| 168319.8 | 7.524 | 30171.9 | 5.566 | 65682.1 | 3503033.6 | 2 |
| 631934.6 | 7.062 | 34794.1 | 7.887 | 66519.2 | 3512331.9 | 3 |
| 82935.6 | 8.316 | 43093.6 | 5.39 | 67367.3 | 3521654.4 | 4 |
| 649209 | 6.171 | 36891.8 | 6.083 | 68226.4 | 3531002.2 | 5 |
| 316923.2 | 8.338 | 59007.3 | 6.061 | 69096.5 | 3540374.2 | 6 |
| 304280.9 | 8.338 | 66312.4 | 6.424 | 69977.6 | 3549771.5 | 7 |
| 574690.6 | 6.215 | 58954.5 | 7.128 | 70869.7 | 3559193 | 8 |
| 434845.4 | 6.886 | 24888.6 | 7.722 | 53588.7 | 5826807.8 | 1 |
| 479713.3 | 6.325 | 24966.7 | 7.513 | 54271.8 | 5849834.1 | 2 |
| 369971.8 | 7.546 | 28022.5 | 5.335 | 54963.7 | 5872952.8 | 3 |
| 496453.1 | 7.073 | 28307.4 | 7.425 | 55664.4 | 5896161.7 | 4 |
| 387399.1 | 7.139 | 26154.7 | 7.348 | 56373.9 | 5919463 | 5 |
| 349054.2 | 8.338 | 30298.4 | 5.72 | 57093.3 | 5942855.6 | 6 |
| 464700.5 | 6.787 | 26237.2 | 5.72 | 57821.5 | 5966341.7 | 7 |
| 320059.3 | 8.745 | 33535.7 | 6.259 | 58558.5 | 5989920.2 | 8 |
| Average | ||||||
| 431109.04375 | 7.4105625 | 32124.0104166667 | 6.7042708333 | 58425.0333333333 | 7796206.9625 |
Table 3
| Table 3. Table 1 organized to run a regression | ||||||||
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9332964503 | |||||||
| R Square | 0.8710422641 | |||||||
| Adjusted R Square | 0.8521704004 | |||||||
| Standard Error | 74342.1531001383 | |||||||
| Observations | 48 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 6 | 1530544479556.02 | 255090746592.67 | 46.1556036067 | 1.08098651598832E-16 | |||
| Residual | 41 | 226596984830.14 | 5526755727.5644 | |||||
| Total | 47 | 1757141464386.16 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 582751.041002148 | 298463.960092735 | 1.9525005325 | 0.0577293818 | -20009.1546053097 | 1185511.23660961 | -20009.1546053097 | 1185511.23660961 |
| X Variable 1 | -122606.817220759 | 16422.3755968148 | -7.4658393055 | 0.0000000037 | -155772.477570504 | -89441.1568710153 | -155772.477570504 | -89441.1568710153 |
| X Variable 2 | 5.8376480213 | 1.6504937143 | 3.5369101808 | 0.0010212827 | 2.5044083439 | 9.1708876987 | 2.5044083439 | 9.1708876987 |
| X Variable 3 | 29866.5894056245 | 13449.216013589 | 2.22069371 | 0.0319566003 | 2705.3466458652 | 57027.8321653838 | 2705.3466458652 | 57027.8321653838 |
| X Variable 4 | 2.0427292284 | 3.7623050022 | 0.5429462064 | 0.5901065124 | -5.5553998669 | 9.6408583237 | -5.5553998669 | 9.6408583237 |
| X Variable 5 | 0.0302580336 | 0.0039447998 | 7.6703597051 | 0.0000000019 | 0.0222913487 | 0.0382247185 | 0.0222913487 | 0.0382247185 |
| X Variable 6 | 3097.0442262557 | 4993.1668128629 | 0.620256511 | 0.5385214252 | -6986.8607245691 | 13180.9491770805 | -6986.8607245691 | 13180.9491770805 |
| Regression Equation | ||||||||
| Unit Sales = 582751 - 122607 Price + 5.84 AdverEXP + 29867 Comp Price + 2.04 Income | ||||||||
| + 0.03026 Pop + 3097 T |