Vintage Excel worksheet.xlsx - Month Period 1 Year 1 Jan 2 feb 3 mar 4 apr 5 may 6 jun 7 jul 8 aug 9 sep 10 oct 11 nov 12 dec 13 Year 2 Jan 14 feb 15

Vintage Excel worksheet.xlsx - Month Period 1 Year 1 Jan 2...

This preview shows page 1 - 5 out of 17 pages.

Month Period Sales 1 Year 1 Jan 242 #N/A 2 feb 235 242 3 mar 232 236.4 4 apr 178 232.88 5 may 184 188.976 6 jun 140 184.9952 7 jul 145 148.99904 8 aug 152 145.799808 9 sep 110 150.7599616 10 oct 130 118.15199232 11 nov 152 127.630398464 12 dec 206 147.1260796928 13 Year 2 Jan 263 194.2252159386 14 feb 238 249.2450431877 15 mar 247 240.2490086375 16 apr 193 245.6498017275 17 may 193 203.5299603455 18 jun 149 195.1059920691 19 jul 157 158.2211984138 20 aug 161 157.2442396828 21 sep 122 160.2488479366 22 oct 130 129.6497695873 23 nov 167 129.9299539175 24 dec 230 159.5859907835 25 Year 3 Jan 282 215.9171981567 26 feb 255 268.7834396313 27 mar 265 257.7566879263 28 apr 205 263.5513375853 29 may 210 216.7102675171 30 jun 160 211.3420535034 31 jul 166 170.2684107007 32 aug 174 166.8536821401 33 sep 126 172.570736428 34 oct 148 135.3141472856 35 nov 173 145.4628294571 36 dec 235 167.4925658914 37 38 0 39 0 40 0 41 0 42
Image of page 1
43 44 45 46 47 48 286.75 267.08 272.42 216.42 220.08 174.08 180.42 186.75 143.75 160.42 188.42 248.08
Image of page 2
Yea r 1 Jan mar may jul sep nov Yea r 2 Jan mar may jul sep nov Yea r 3 Jan mar may jul sep nov 0 50 100 150 200 250 300 The Vintage Restaurant Sales Sales In ($000)
Image of page 3
SUMMARY OUTPUT Regression Statistics Multiple R 0.97376867 R Square 0.94822542 Adjusted R S 0.92449541 Standard Erro12.9593381 Observations 36 ANOVA df SS MS F Significance F Regression 11 73819.6389 6710.87626 39.958906 1.0167E-12 Residual 24 4030.66667 167.944444 Total 35 77850.3056 CoefficientsStandard Erro t Stat P-value Lower 95% Upper 95% Intercept 223.666667 7.48207735 29.8936587 1.6716E-20 208.224418 239.108915 Jan 38.6666667 10.5812553 3.65426083 0.00125585 16.8280291 60.5053042 Feb 19 10.5812553 1.79562817 0.08515639 -2.83863752 40.8386375 Mar 24.3333333 10.5812553 2.29966414 0.03047158 2.49469581 46.1719709 Apr -31.6666667 10.5812553 -2.99271361 0.00631407 -53.5053042 -9.82802915 May -28 10.5812553 -2.64618888 0.01414244 -49.8386375 -6.16136248 Jun -74 10.5812553 -6.99349918 3.1282E-07 -95.8386375 -52.1613625 Jul -67.6666667 10.5812553 -6.39495646 1.3008E-06 -89.5053042 -45.8280291 Aug -61.3333333 10.5812553 -5.79641373 5.6326E-06 -83.1719709 -39.4946958 Sep -104.333333 10.5812553 -9.8602038 6.4665E-10 -126.171971 -82.4946958 Oct -87.6666667 10.5812553 -8.28509137 1.6887E-08 -109.505304 -65.8280291 Nov -59.6666667 10.5812553 -5.63890249 8.332E-06 -81.5053042 -37.8280291 RESIDUAL OUTPUT ObservationPredicted Sale Residuals absolute 1 262.333333 -20.3333333 20.3333333 2 242.666667 -7.66666667 7.66666667
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 17 pages?

  • Fall '15
  • Dr.T.Drezner
  • 1981, 1969

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture