SUMMARY OUTPUT
Regression Statistics
Multiple R 0.494327374
R Square 0.244359552
Adjusted R Square 0.186233364
Standard Error 8.393497635
Observations 15
ANOVA
df SS MS F Significance F
Regression 1 296.171606829 296.1716 4.203949 0.0610577365
Residual 13 915.860433171 70.4508
Total 14 1212.03204
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 4.79306708 3.60974472858 1.327813 0.207084 -3.005312289 12.59144645
Number of Units (1,000s) 0.776083862 0.37851222815 2.050353 0.061058 -0.041642092 1.593809816
Since the P-value is more than 0.05, the independent var
If the number of uniTS INCREASE by 1, sales increases by
Lower 95.0% Upper 95.0%
-3.005312289 12.59144645
-0.041642092 1.5938098156
n 0.05, the independent variable is not significant
ASE by 1, sales increases by 0.78 unit
U.S. Sales ($ Number of Units U.S. Sales ($
Chain Y hat
billions) (1,000s) billions)
McDonals's 40.41 13.80 40.41 15.50302
Starbucks 21.55 15.00 21.55 16.43433
Chick-fil-A 11.00 2.50 11.00 6.733277
Taco Bel 11.00 7.10 11.00 10.30326 Correlation of X and Y
Burger King 10.30 7.30 10.30 10.45848 R square
Subway 10.00 23.80 10.00 23.26386
Wendy's 9.87 5.90 9.87 9.371962
Dunkin' 9.22 9.60 9.22 12.24347 Coefficients
Dominos 7.10 6.20 7.10 9.604787 Intercept 4.793067
Panera Bread 5.93 2.20 5.93 6.500452 Number of 0.776084
Chipotle 5.52 2.60 5.52 6.810885 sales=4.79+0.78Number of units
Pizza Hut 5.38 7.40 5.38 10.53609
KFC 4.82 4.10 4.82 7.975011
Sonic Drive-In 4.69 3.50 4.69 7.509361
Arby's 3.89 3.40 3.89 7.431752
y ( what to estimate) x
This chart isn't available
Residual Scatterplot
30.00
Editing this shape or savi
permanently break the ch
25.00
20.00
15.00
10.00
5.00
0.00
0 2 4 6 8 10 12 14 16
-5.00
-10.00
-15.00
-20.00
Error Y- Y hat ( one on the right goes to y axis)
24.91
5.12
4.27 we can explani 24% of the c hart
0.494327 0.70
0.24436 -0.16
-13.26 U.S. Sales ($ billio
0.50 45.00
Coefficients -3.02 40.00
-2.50 35.00
-0.57
30.00
9+0.78Number of units -1.29
-5.16 25.00
-3.16 20.00 f(x) = 0.77608386185354 x + 4.793067080
R² = 0.244359552433041
-2.82 15.00
-3.54
10.00
5.00
0.00
0.00 5.00 10.00 15.
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will
permanently break the chart.
U.S. Sales ($ billions)
77608386185354 x + 4.79306708026367
44359552433041
00 10.00 15.00 20.00 25.00
