Prepare your data for modeling
## Store Date Weekly_Sales Holiday_Flag
## Min. : 1 Length:6435 Min. : 209986 Min. :0.00000
## 1st Qu.:12 Class :character 1st Qu.: 553350 1st Qu.:0.00000
## Median :23 Mode :character Median : 960746 Median :0.00000
## Mean :23 Mean :1046965 Mean :0.06993
## 3rd Qu.:34 3rd Qu.:1420159 3rd Qu.:0.00000
## Max. :45 Max. :3818686 Max. :1.00000
## Temperature Fuel_Price CPI Unemployment
## Min. : -2.06 Min. :2.472 Min. :126.1 Min. : 3.879
## 1st Qu.: 47.46 1st Qu.:2.933 1st Qu.:131.7 1st Qu.: 6.891
## Median : 62.67 Median :3.445 Median :182.6 Median : 7.874
## Mean : 60.66 Mean :3.359 Mean :171.6 Mean : 7.999
## 3rd Qu.: 74.94 3rd Qu.:3.735 3rd Qu.:212.7 3rd Qu.: 8.622
## Max. :100.14 Max. :4.468 Max. :227.2 Max. :14.313
## Store Date Weekly_Sales Holiday_Flag
## 1 : 143 Length:6435 Min. : 209986 0:5985
## 2 : 143 Class :character 1st Qu.: 553350 1: 450
## 3 : 143 Mode :character Median : 960746
## 4 : 143 Mean :1046965
## 5 : 143 3rd Qu.:1420159
## 6 : 143 Max. :3818686
## (Other):5577
## Temperature Fuel_Price CPI Unemployment
## Min. : -2.06 Min. :2.472 Min. :126.1 Min. : 3.879
## 1st Qu.: 47.46 1st Qu.:2.933 1st Qu.:131.7 1st Qu.: 6.891
## Median : 62.67 Median :3.445 Median :182.6 Median : 7.874
## Mean : 60.66 Mean :3.359 Mean :171.6 Mean : 7.999
## 3rd Qu.: 74.94 3rd Qu.:3.735 3rd Qu.:212.7 3rd Qu.: 8.622
## Max. :100.14 Max. :4.468 Max. :227.2 Max. :14.313
##
## random
## Min. :0.0002253
## 1st Qu.:0.2513698
## Median :0.5065860
## Mean :0.5026246
## 3rd Qu.:0.7531502
## Max. :0.9997390
##
## tibble [6,435 × 9] (S3: tbl_df/tbl/data.frame)
## $ Store : Factor w/ 45 levels "1","2","3","4",..: 1 1 1 1 1 1 1 1 1 1 ...
## $ Date : chr [1:6435] "05-02-2010" "12-02-2010" "19-02-2010" "26-02-2010" ...
## $ Weekly_Sales: num [1:6435] 1643691 1641957 1611968 1409728 1554807 ...
## $ Holiday_Flag: Factor w/ 2 levels "0","1": 1 2 1 1 1 1 1 1 1 1 ...
## $ Temperature : num [1:6435] 42.3 38.5 39.9 46.6 46.5 ...
## $ Fuel_Price : num [1:6435] 2.57 2.55 2.51 2.56 2.62 ...
## $ CPI : num [1:6435] 211 211 211 211 211 ...
## $ Unemployment: num [1:6435] 8.11 8.11 8.11 8.11 8.11 ...
## $ random : num [1:6435] 0.06 0.536 0.1 0.18 0.327 ...
Develop a linear model to predict sales
##
## Call:
## lm(formula = Weekly_Sales ~ . - Date, data = trainlm)
##
## Residuals:
## Min 1Q Median 3Q Max
## -507763 -69256 -12013 39123 1795259
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1525578.9 272710.1 5.594 2.35e-08 ***
## Store2 386173.7 22998.6 16.791 < 2e-16 ***
## Store3 -1157037.7 23454.0 -49.332 < 2e-16 ***
## Store4 657744.6 114493.0 5.745 9.81e-09 ***
## Store5 -1263989.1 24173.1 -52.289 < 2e-16 ***
## Store6 -25557.3 23358.2 -1.094 0.273952
## Store7 -937376.8 35026.1 -26.762 < 2e-16 ***
## Store8 -683931.8 24109.8 -28.367 < 2e-16 ***
## Store9 -1049710.3 23906.1 -43.910 < 2e-16 ***
## Store10 535348.4 110734.1 4.835 1.38e-06 ***
## Store11 -191193.7 23040.1 -8.298 < 2e-16 ***
## Store12 -200722.0 103630.2 -1.937 0.052820 .
## Store13 577737.3 112119.6 5.153 2.68e-07 ***
## Store14 540295.3 42440.1 12.731 < 2e-16 ***
## Store15 -759381.3 103713.9 -7.322 2.89e-13 ***
## Store16 -1029973.0 38387.3 -26.831 < 2e-16 ***
## Store17 -534085.1 113409.9 -4.709 2.56e-06 ***
## Store18 -293423.6 101476.7 -2.892 0.003852 **
## Store19 71735.4 103669.4 0.692 0.488997
## Store20 575717.8 25287.3 22.767 < 2e-16 ***
## Store21 -779840.5 22996.9 -33.911 < 2e-16 ***
## Store22 -370831.7 97971.3 -3.785 0.000156 ***
## Store23 -104215.6 110809.0 -0.940 0.347013
## Store24 -2979.0 102947.1 -0.029 0.976916
## Store25 -833234.1 25022.3 -33.300 < 2e-16 ***
## Store26 -391013.9 103255.8 -3.787 0.000155 ***
## Store27 409895.7 99082.7 4.137 3.59e-05 ***
## Store28 105593.0 103860.1 1.017 0.309359
## Store29 -801232.4 99803.1 -8.028 1.26e-15 ***
## Store30 -1103826.7 22945.3 -48.107 < 2e-16 ***
## Store31 -140226.3 22633.3 -6.196 6.33e-10 ***
## Store32 -324646.7 34611.1 -9.380 < 2e-16 ***
## Store33 -1077095.4 110492.8 -9.748 < 2e-16 ***
## Store34 -367274.1 105915.1 -3.468 0.000530 ***
## Store35 -449183.3 96648.1 -4.648 3.46e-06 ***
## Store36 -1167366.6 23368.8 -49.954 < 2e-16 ***
## Store37 -1011629.6 23409.7 -43.214 < 2e-16 ***
## Store38 -835749.6 103825.8 -8.050 1.06e-15 ***
## Store39 -75345.5 23605.3 -3.192 0.001423 **
## Store40 -525661.2 110969.9 -4.737 2.24e-06 ***
## Store41 -263552.6 37118.1 -7.100 1.44e-12 ***
## Store42 -790747.6 110757.8 -7.139 1.09e-12 ***
## Store43 -832669.1 26068.7 -31.941 < 2e-16 ***
## Store44 -1116304.6 112702.4 -9.905 < 2e-16 ***
## Store45 -694309.6 42809.3 -16.219 < 2e-16 ***
## Holiday_Flag1 67179.2 9383.4 7.159 9.44e-13 ***
## Temperature -821.6 157.1 -5.230 1.77e-07 ***
## Fuel_Price -38868.3 8522.4 -4.561 5.24e-06 ***
## CPI 1853.4 1236.6 1.499 0.133997
## Unemployment -26772.2 5132.0 -5.217 1.90e-07 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 159200 on 4450 degrees of freedom
## Multiple R-squared: 0.9209, Adjusted R-squared: 0.9201
## F-statistic: 1058 on 49 and 4450 DF, p-value: < 2.2e-16
## Backward Elimination Method
## ---------------------------
##
## Candidate Terms:
##
## 1. Store
## 2. Holiday_Flag
## 3. Temperature
## 4. Fuel_Price
## 5. CPI
## 6. Unemployment
##
##
## Step => 0
## Model => Weekly_Sales ~ Store + Holiday_Flag + Temperature + Fuel_Price + CPI + Unemployment
## R2 => 0.921
##
## Initiating stepwise selection...
##
##
## No more variables to be removed.
##
## Call:
## lm(formula = paste(response, "~", paste(c(include, cterms), collapse = " + ")),
## data = l)
##
## Residuals:
## Min 1Q Median 3Q Max
## -507763 -69256 -12013 39123 1795259
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1525578.9 272710.1 5.594 2.35e-08 ***
## Store2 386173.7 22998.6 16.791 < 2e-16 ***
## Store3 -1157037.7 23454.0 -49.332 < 2e-16 ***
## Store4 657744.6 114493.0 5.745 9.81e-09 ***
## Store5 -1263989.1 24173.1 -52.289 < 2e-16 ***
## Store6 -25557.3 23358.2 -1.094 0.273952
## Store7 -937376.8 35026.1 -26.762 < 2e-16 ***
## Store8 -683931.8 24109.8 -28.367 < 2e-16 ***
## Store9 -1049710.3 23906.1 -43.910 < 2e-16 ***
## Store10 535348.4 110734.1 4.835 1.38e-06 ***
## Store11 -191193.7 23040.1 -8.298 < 2e-16 ***
## Store12 -200722.0 103630.2 -1.937 0.052820 .
## Store13 577737.3 112119.6 5.153 2.68e-07 ***
## Store14 540295.3 42440.1 12.731 < 2e-16 ***
## Store15 -759381.3 103713.9 -7.322 2.89e-13 ***
## Store16 -1029973.0 38387.3 -26.831 < 2e-16 ***
## Store17 -534085.1 113409.9 -4.709 2.56e-06 ***
## Store18 -293423.6 101476.7 -2.892 0.003852 **
## Store19 71735.4 103669.4 0.692 0.488997
## Store20 575717.8 25287.3 22.767 < 2e-16 ***
## Store21 -779840.5 22996.9 -33.911 < 2e-16 ***
## Store22 -370831.7 97971.3 -3.785 0.000156 ***
## Store23 -104215.6 110809.0 -0.940 0.347013
## Store24 -2979.0 102947.1 -0.029 0.976916
## Store25 -833234.1 25022.3 -33.300 < 2e-16 ***
## Store26 -391013.9 103255.8 -3.787 0.000155 ***
## Store27 409895.7 99082.7 4.137 3.59e-05 ***
## Store28 105593.0 103860.1 1.017 0.309359
## Store29 -801232.4 99803.1 -8.028 1.26e-15 ***
## Store30 -1103826.7 22945.3 -48.107 < 2e-16 ***
## Store31 -140226.3 22633.3 -6.196 6.33e-10 ***
## Store32 -324646.7 34611.1 -9.380 < 2e-16 ***
## Store33 -1077095.4 110492.8 -9.748 < 2e-16 ***
## Store34 -367274.1 105915.1 -3.468 0.000530 ***
## Store35 -449183.3 96648.1 -4.648 3.46e-06 ***
## Store36 -1167366.6 23368.8 -49.954 < 2e-16 ***
## Store37 -1011629.6 23409.7 -43.214 < 2e-16 ***
## Store38 -835749.6 103825.8 -8.050 1.06e-15 ***
## Store39 -75345.5 23605.3 -3.192 0.001423 **
## Store40 -525661.2 110969.9 -4.737 2.24e-06 ***
## Store41 -263552.6 37118.1 -7.100 1.44e-12 ***
## Store42 -790747.6 110757.8 -7.139 1.09e-12 ***
## Store43 -832669.1 26068.7 -31.941 < 2e-16 ***
## Store44 -1116304.6 112702.4 -9.905 < 2e-16 ***
## Store45 -694309.6 42809.3 -16.219 < 2e-16 ***
## Holiday_Flag1 67179.2 9383.4 7.159 9.44e-13 ***
## Temperature -821.6 157.1 -5.230 1.77e-07 ***
## Fuel_Price -38868.3 8522.4 -4.561 5.24e-06 ***
## CPI 1853.4 1236.6 1.499 0.133997
## Unemployment -26772.2 5132.0 -5.217 1.90e-07 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 159200 on 4450 degrees of freedom
## Multiple R-squared: 0.9209, Adjusted R-squared: 0.9201
## F-statistic: 1058 on 49 and 4450 DF, p-value: < 2.2e-16
##
## Call:
## lm(formula = Weekly_Sales ~ (. - Date)^2, data = trainlm)
##
## Residuals:
## Min 1Q Median 3Q Max
## -552364 -55773 -9303 32569 1625072
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -2.174e+07 8.082e+06 -2.690 0.007170 **
## Store2 -3.336e+06 5.548e+06 -0.601 0.547625
## Store3 3.742e+06 4.061e+06 0.921 0.356859
## Store4 6.730e+06 7.594e+06 0.886 0.375546
## Store5 4.868e+06 4.331e+06 1.124 0.261112
## Store6 5.319e+06 4.361e+06 1.220 0.222603
## Store7 -2.688e+06 4.784e+06 -0.562 0.574301
## Store8 7.203e+06 3.928e+06 1.834 0.066775 .
## Store9 3.182e+06 4.332e+06 0.735 0.462592
## Store10 1.385e+07 7.069e+06 1.960 0.050080 .
## Store11 1.632e+06 3.836e+06 0.425 0.670513
## Store12 4.862e+06 5.214e+06 0.932 0.351152
## Store13 1.895e+07 8.573e+06 2.211 0.027107 *
## Store14 1.441e+07 3.073e+06 4.688 2.84e-06 ***
## Store15 1.015e+07 4.005e+06 2.535 0.011285 *
## Store16 3.980e+06 4.740e+06 0.840 0.401107
## Store17 1.207e+07 5.520e+06 2.186 0.028878 *
## Store18 1.345e+07 5.109e+06 2.633 0.008483 **
## Store19 1.125e+07 4.037e+06 2.787 0.005341 **
## Store20 6.603e+06 3.060e+06 2.158 0.031010 *
## Store21 3.624e+05 5.480e+06 0.066 0.947284
## Store22 1.042e+07 5.175e+06 2.013 0.044177 *
## Store23 1.381e+07 7.359e+06 1.877 0.060620 .
## Store24 8.809e+06 4.107e+06 2.145 0.032037 *
## Store25 4.867e+06 3.044e+06 1.599 0.109892
## Store26 1.217e+07 6.742e+06 1.805 0.071182 .
## Store27 1.305e+07 3.853e+06 3.388 0.000710 ***
## Store28 6.514e+06 4.889e+06 1.332 0.182770
## Store29 7.948e+06 4.777e+06 1.664 0.096203 .
## Store30 8.486e+06 5.337e+06 1.590 0.111890
## Store31 -1.012e+06 5.429e+06 -0.186 0.852143
## Store32 5.217e+05 4.850e+06 0.108 0.914346
## Store33 9.820e+06 7.089e+06 1.385 0.166027
## Store34 1.079e+07 4.223e+06 2.554 0.010681 *
## Store35 1.028e+07 3.632e+06 2.830 0.004671 **
## Store36 1.043e+07 5.407e+06 1.929 0.053831 .
## Store37 6.865e+06 5.406e+06 1.270 0.204234
## Store38 6.161e+06 5.628e+06 1.095 0.273696
## Store39 -1.455e+07 5.251e+06 -2.771 0.005615 **
## Store40 1.265e+07 7.738e+06 1.635 0.102090
## Store41 -1.344e+06 5.364e+06 -0.251 0.802169
## Store42 1.269e+07 7.048e+06 1.801 0.071808 .
## Store43 6.718e+06 3.391e+06 1.981 0.047667 *
## Store44 1.492e+07 9.304e+06 1.603 0.108933
## Store45 5.227e+06 3.165e+06 1.651 0.098719 .
## Holiday_Flag1 -9.043e+05 1.187e+06 -0.762 0.446327
## Temperature 4.681e+04 1.964e+04 2.383 0.017211 *
## Fuel_Price 2.665e+06 9.423e+05 2.829 0.004695 **
## CPI 1.039e+05 3.756e+04 2.766 0.005704 **
## Unemployment 8.420e+05 8.955e+05 0.940 0.347129
## Store2:Holiday_Flag1 2.900e+04 1.002e+05 0.290 0.772184
## Store3:Holiday_Flag1 -6.944e+04 9.460e+04 -0.734 0.462939
## Store4:Holiday_Flag1 4.654e+05 5.041e+05 0.923 0.355877
## Store5:Holiday_Flag1 -3.929e+04 9.531e+04 -0.412 0.680228
## Store6:Holiday_Flag1 5.553e+04 9.120e+04 0.609 0.542609
## Store7:Holiday_Flag1 1.638e+05 1.570e+05 1.043 0.296800
## Store8:Holiday_Flag1 2.203e+04 1.014e+05 0.217 0.828054
## Store9:Holiday_Flag1 -8.002e+04 1.031e+05 -0.776 0.437849
## Store10:Holiday_Flag1 3.770e+05 5.008e+05 0.753 0.451644
## Store11:Holiday_Flag1 -4.905e+04 9.345e+04 -0.525 0.599687
## Store12:Holiday_Flag1 4.582e+05 4.785e+05 0.958 0.338265
## Store13:Holiday_Flag1 3.824e+05 4.982e+05 0.768 0.442779
## Store14:Holiday_Flag1 8.743e+04 1.881e+05 0.465 0.642093
## Store15:Holiday_Flag1 4.483e+05 4.716e+05 0.951 0.341784
## Store16:Holiday_Flag1 1.241e+05 1.644e+05 0.755 0.450466
## Store17:Holiday_Flag1 4.627e+05 5.029e+05 0.920 0.357606
## Store18:Holiday_Flag1 3.480e+05 4.577e+05 0.760 0.447057
## Store19:Holiday_Flag1 4.662e+05 4.665e+05 0.999 0.317691
## Store20:Holiday_Flag1 7.037e+04 1.063e+05 0.662 0.508137
## Store21:Holiday_Flag1 2.138e+04 9.540e+04 0.224 0.822678
## Store22:Holiday_Flag1 3.888e+05 4.410e+05 0.882 0.378063
## Store23:Holiday_Flag1 3.773e+05 4.893e+05 0.771 0.440697
## Store24:Holiday_Flag1 4.635e+05 4.671e+05 0.992 0.321111
## Store25:Holiday_Flag1 9.642e+04 1.093e+05 0.883 0.377541
## Store26:Holiday_Flag1 4.080e+05 4.678e+05 0.872 0.383115
## Store27:Holiday_Flag1 4.467e+05 4.474e+05 0.998 0.318133
## Store28:Holiday_Flag1 4.127e+05 4.794e+05 0.861 0.389435
## Store29:Holiday_Flag1 3.613e+05 4.555e+05 0.793 0.427695
## Store30:Holiday_Flag1 -8.147e+04 9.177e+04 -0.888 0.374715
## Store31:Holiday_Flag1 6.075e+04 9.229e+04 0.658 0.510419
## Store32:Holiday_Flag1 -5.142e+04 1.505e+05 -0.342 0.732692
## Store33:Holiday_Flag1 3.240e+05 4.979e+05 0.651 0.515233
## Store34:Holiday_Flag1 3.917e+05 4.799e+05 0.816 0.414463
## Store35:Holiday_Flag1 5.112e+05 4.371e+05 1.170 0.242246
## Store36:Holiday_Flag1 -9.030e+04 1.012e+05 -0.893 0.372095
## Store37:Holiday_Flag1 -9.580e+04 9.804e+04 -0.977 0.328538
## Store38:Holiday_Flag1 3.075e+05 4.774e+05 0.644 0.519467
## Store39:Holiday_Flag1 -7.141e+04 9.141e+04 -0.781 0.434731
## Store40:Holiday_Flag1 4.204e+05 4.901e+05 0.858 0.391065
## Store41:Holiday_Flag1 1.795e+05 1.596e+05 1.125 0.260795
## Store42:Holiday_Flag1 3.319e+05 4.952e+05 0.670 0.502730
## Store43:Holiday_Flag1 -2.467e+04 1.069e+05 -0.231 0.817473
## Store44:Holiday_Flag1 3.601e+05 4.994e+05 0.721 0.470922
## Store45:Holiday_Flag1 1.507e+05 1.909e+05 0.790 0.429830
## Store2:Temperature -2.259e+03 1.625e+03 -1.390 0.164516
## Store3:Temperature 1.498e+03 1.810e+03 0.827 0.408088
## Store4:Temperature -2.311e+04 8.357e+03 -2.766 0.005705 **
## Store5:Temperature 1.731e+03 1.787e+03 0.969 0.332616
## Store6:Temperature 3.889e+03 1.726e+03 2.253 0.024308 *
## Store7:Temperature -1.248e+03 2.466e+03 -0.506 0.612829
## Store8:Temperature 1.022e+03 1.672e+03 0.611 0.541015
## Store9:Temperature 1.862e+03 1.681e+03 1.108 0.267962
## Store10:Temperature -2.810e+04 8.166e+03 -3.441 0.000585 ***
## Store11:Temperature -3.806e+02 1.779e+03 -0.214 0.830602
## Store12:Temperature -2.151e+04 7.788e+03 -2.762 0.005776 **
## Store13:Temperature -2.160e+04 8.201e+03 -2.634 0.008478 **
## Store14:Temperature -6.996e+03 3.098e+03 -2.258 0.024010 *
## Store15:Temperature -1.879e+04 7.629e+03 -2.463 0.013817 *
## Store16:Temperature -2.369e+03 2.658e+03 -0.891 0.372764
## Store17:Temperature -1.928e+04 8.273e+03 -2.331 0.019812 *
## Store18:Temperature -1.839e+04 7.503e+03 -2.450 0.014307 *
## Store19:Temperature -1.943e+04 7.594e+03 -2.559 0.010525 *
## Store20:Temperature -4.922e+03 1.721e+03 -2.860 0.004262 **
## Store21:Temperature 1.274e+03 1.641e+03 0.776 0.437640
## Store22:Temperature -1.660e+04 7.204e+03 -2.304 0.021272 *
## Store23:Temperature -1.800e+04 7.993e+03 -2.252 0.024354 *
## Store24:Temperature -1.830e+04 7.559e+03 -2.421 0.015511 *
## Store25:Temperature 3.244e+01 1.699e+03 0.019 0.984772
## Store26:Temperature -1.700e+04 7.582e+03 -2.242 0.025012 *
## Store27:Temperature -1.491e+04 7.263e+03 -2.053 0.040179 *
## Store28:Temperature -2.322e+04 7.816e+03 -2.971 0.002989 **
## Store29:Temperature -1.848e+04 7.409e+03 -2.495 0.012643 *
## Store30:Temperature 1.666e+03 1.609e+03 1.035 0.300645
## Store31:Temperature -4.317e+02 1.581e+03 -0.273 0.784846
## Store32:Temperature -3.283e+03 2.468e+03 -1.330 0.183542
## Store33:Temperature -1.971e+04 8.138e+03 -2.423 0.015448 *
## Store34:Temperature -1.980e+04 7.799e+03 -2.539 0.011144 *
## Store35:Temperature -1.604e+04 7.095e+03 -2.261 0.023814 *
## Store36:Temperature 2.505e+03 1.941e+03 1.291 0.196777
## Store37:Temperature 1.119e+03 1.907e+03 0.587 0.557349
## Store38:Temperature -1.866e+04 7.808e+03 -2.390 0.016900 *
## Store39:Temperature 3.075e+03 1.880e+03 1.636 0.101954
## Store40:Temperature -1.752e+04 7.982e+03 -2.195 0.028212 *
## Store41:Temperature -2.732e+03 2.573e+03 -1.062 0.288435
## Store42:Temperature -2.074e+04 8.164e+03 -2.541 0.011095 *
## Store43:Temperature 1.405e+03 1.877e+03 0.749 0.454196
## Store44:Temperature -1.965e+04 8.239e+03 -2.384 0.017155 *
## Store45:Temperature -6.075e+03 3.135e+03 -1.938 0.052726 .
## Store2:Fuel_Price -1.904e+05 9.041e+04 -2.106 0.035245 *
## Store3:Fuel_Price 4.916e+04 1.005e+05 0.489 0.624751
## Store4:Fuel_Price -1.177e+06 3.612e+05 -3.260 0.001125 **
## Store5:Fuel_Price 1.731e+04 9.620e+04 0.180 0.857175
## Store6:Fuel_Price -4.204e+04 9.126e+04 -0.461 0.645075
## Store7:Fuel_Price -1.855e+05 1.174e+05 -1.580 0.114079
## Store8:Fuel_Price 8.567e+04 9.500e+04 0.902 0.367223
## Store9:Fuel_Price 4.147e+04 9.361e+04 0.443 0.657740
## Store10:Fuel_Price -1.204e+06 3.430e+05 -3.511 0.000451 ***
## Store11:Fuel_Price -6.044e+04 9.704e+04 -0.623 0.533439
## Store12:Fuel_Price -1.007e+06 3.165e+05 -3.182 0.001474 **
## Store13:Fuel_Price -1.011e+06 3.618e+05 -2.795 0.005217 **
## Store14:Fuel_Price -2.666e+05 1.361e+05 -1.959 0.050214 .
## Store15:Fuel_Price -1.034e+06 3.229e+05 -3.204 0.001368 **
## Store16:Fuel_Price -2.270e+05 1.420e+05 -1.598 0.110008
## Store17:Fuel_Price -9.852e+05 3.668e+05 -2.686 0.007263 **
## Store18:Fuel_Price -1.041e+06 3.113e+05 -3.344 0.000833 ***
## Store19:Fuel_Price -1.085e+06 3.224e+05 -3.365 0.000773 ***
## Store20:Fuel_Price -1.603e+05 9.131e+04 -1.756 0.079202 .
## Store21:Fuel_Price -4.545e+03 9.015e+04 -0.050 0.959792
## Store22:Fuel_Price -9.735e+05 3.044e+05 -3.198 0.001394 **
## Store23:Fuel_Price -1.086e+06 3.593e+05 -3.022 0.002524 **
## Store24:Fuel_Price -1.082e+06 3.192e+05 -3.391 0.000703 ***
## Store25:Fuel_Price -1.245e+05 9.084e+04 -1.371 0.170527
## Store26:Fuel_Price -1.003e+06 3.228e+05 -3.106 0.001910 **
## Store27:Fuel_Price -1.045e+06 3.075e+05 -3.398 0.000684 ***
## Store28:Fuel_Price -1.007e+06 3.136e+05 -3.212 0.001327 **
## Store29:Fuel_Price -9.501e+05 3.020e+05 -3.146 0.001664 **
## Store30:Fuel_Price 4.487e+04 9.077e+04 0.494 0.621079
## Store31:Fuel_Price 2.704e+03 8.939e+04 0.030 0.975870
## Store32:Fuel_Price -1.784e+05 1.159e+05 -1.539 0.123934
## Store33:Fuel_Price -1.042e+06 3.402e+05 -3.062 0.002214 **
## Store34:Fuel_Price -1.000e+06 3.263e+05 -3.066 0.002182 **
## Store35:Fuel_Price -8.834e+05 3.002e+05 -2.943 0.003272 **
## Store36:Fuel_Price 6.001e+04 9.577e+04 0.627 0.530917
## Store37:Fuel_Price 5.772e+04 9.537e+04 0.605 0.545039
## Store38:Fuel_Price -9.425e+05 3.181e+05 -2.962 0.003069 **
## Store39:Fuel_Price -2.344e+05 9.702e+04 -2.416 0.015716 *
## Store40:Fuel_Price -1.021e+06 3.594e+05 -2.841 0.004512 **
## Store41:Fuel_Price -1.951e+05 1.298e+05 -1.503 0.132852
## Store42:Fuel_Price -9.707e+05 3.417e+05 -2.841 0.004523 **
## Store43:Fuel_Price 1.850e+04 1.109e+05 0.167 0.867460
## Store44:Fuel_Price -9.945e+05 3.644e+05 -2.729 0.006378 **
## Store45:Fuel_Price -2.841e+05 1.388e+05 -2.047 0.040706 *
## Store2:CPI 1.788e+04 2.186e+04 0.818 0.413429
## Store3:CPI -1.938e+04 1.598e+04 -1.212 0.225443
## Store4:CPI 3.447e+04 4.479e+04 0.770 0.441613
## Store5:CPI -2.413e+04 1.704e+04 -1.416 0.156774
## Store6:CPI -2.110e+04 1.748e+04 -1.207 0.227400
## Store7:CPI 1.275e+04 1.948e+04 0.654 0.513009
## Store8:CPI -3.181e+04 1.581e+04 -2.013 0.044218 *
## Store9:CPI -1.746e+04 1.745e+04 -1.001 0.317080
## Store10:CPI -1.680e+04 4.457e+04 -0.377 0.706189
## Store11:CPI -5.149e+03 1.507e+04 -0.342 0.732561
## Store12:CPI 3.092e+04 4.265e+04 0.725 0.468530
## Store13:CPI -6.165e+04 5.562e+04 -1.108 0.267736
## Store14:CPI -5.858e+04 1.243e+04 -4.713 2.51e-06 ***
## Store15:CPI -1.034e+04 1.758e+04 -0.588 0.556528
## Store16:CPI -1.401e+04 1.756e+04 -0.798 0.425092
## Store17:CPI -2.276e+04 2.614e+04 -0.870 0.384129
## Store18:CPI -2.860e+04 2.593e+04 -1.103 0.270057
## Store19:CPI -9.212e+03 1.766e+04 -0.522 0.602010
## Store20:CPI -1.629e+04 1.174e+04 -1.388 0.165280
## Store21:CPI -5.743e+03 2.169e+04 -0.265 0.791189
## Store22:CPI -1.252e+04 2.411e+04 -0.519 0.603441
## Store23:CPI -2.905e+04 3.625e+04 -0.802 0.422865
## Store24:CPI 5.661e+03 2.424e+04 0.234 0.815313
## Store25:CPI -1.724e+04 1.170e+04 -1.473 0.140723
## Store26:CPI -2.180e+04 3.123e+04 -0.698 0.485025
## Store27:CPI -1.940e+04 1.765e+04 -1.099 0.271783
## Store28:CPI 2.093e+04 4.042e+04 0.518 0.604586
## Store29:CPI -2.188e+03 2.594e+04 -0.084 0.932790
## Store30:CPI -3.757e+04 2.102e+04 -1.787 0.073978 .
## Store31:CPI 3.686e+03 2.152e+04 0.171 0.864003
## Store32:CPI 3.437e+03 1.968e+04 0.175 0.861371
## Store33:CPI -1.176e+04 4.529e+04 -0.260 0.795168
## Store34:CPI -1.327e+04 2.415e+04 -0.549 0.582742
## Store35:CPI -5.018e+04 1.614e+04 -3.109 0.001891 **
## Store36:CPI -4.821e+04 2.191e+04 -2.200 0.027838 *
## Store37:CPI -3.107e+04 2.188e+04 -1.420 0.155722
## Store38:CPI 1.481e+04 4.546e+04 0.326 0.744693
## Store39:CPI 6.495e+04 2.141e+04 3.034 0.002429 **
## Store40:CPI -2.801e+04 3.942e+04 -0.711 0.477382
## Store41:CPI 1.451e+04 2.067e+04 0.702 0.482572
## Store42:CPI -3.070e+04 4.416e+04 -0.695 0.486898
## Store43:CPI -2.727e+04 1.558e+04 -1.750 0.080223 .
## Store44:CPI -4.841e+04 6.101e+04 -0.794 0.427495
## Store45:CPI -1.770e+04 1.291e+04 -1.371 0.170393
## Store2:Unemployment 8.361e+04 1.416e+05 0.590 0.555017
## Store3:Unemployment -1.266e+05 1.227e+05 -1.032 0.302099
## Store4:Unemployment -4.251e+05 3.960e+05 -1.073 0.283122
## Store5:Unemployment -1.377e+05 1.420e+05 -0.970 0.332013
## Store6:Unemployment -1.154e+05 1.240e+05 -0.931 0.352064
## Store7:Unemployment 3.600e+04 1.721e+05 0.209 0.834297
## Store8:Unemployment -1.796e+05 1.305e+05 -1.377 0.168666
## Store9:Unemployment -8.111e+04 1.323e+05 -0.613 0.539817
## Store10:Unemployment -4.353e+05 4.048e+05 -1.075 0.282229
## Store11:Unemployment -6.507e+04 1.181e+05 -0.551 0.581573
## Store12:Unemployment -3.573e+05 4.003e+05 -0.893 0.372139
## Store13:Unemployment -5.044e+05 4.025e+05 -1.253 0.210268
## Store14:Unemployment -1.419e+05 2.191e+05 -0.647 0.517406
## Store15:Unemployment -4.027e+05 3.887e+05 -1.036 0.300288
## Store16:Unemployment -9.201e+04 2.057e+05 -0.447 0.654731
## Store17:Unemployment -4.225e+05 3.996e+05 -1.057 0.290369
## Store18:Unemployment -4.448e+05 3.811e+05 -1.167 0.243216
## Store19:Unemployment -4.291e+05 3.894e+05 -1.102 0.270592
## Store20:Unemployment -2.169e+05 1.260e+05 -1.721 0.085313 .
## Store21:Unemployment 3.958e+03 1.382e+05 0.029 0.977148
## Store22:Unemployment -3.978e+05 3.704e+05 -1.074 0.282920
## Store23:Unemployment -4.758e+05 4.052e+05 -1.174 0.240297
## Store24:Unemployment -3.926e+05 3.856e+05 -1.018 0.308564
## Store25:Unemployment -1.997e+05 1.229e+05 -1.625 0.104149
## Store26:Unemployment -4.404e+05 4.203e+05 -1.048 0.294773
## Store27:Unemployment -4.906e+05 3.758e+05 -1.306 0.191765
## Store28:Unemployment -3.522e+05 4.004e+05 -0.880 0.379078
## Store29:Unemployment -3.265e+05 3.785e+05 -0.863 0.388431
## Store30:Unemployment -2.277e+05 1.376e+05 -1.655 0.098100 .
## Store31:Unemployment 1.308e+04 1.366e+05 0.096 0.923755
## Store32:Unemployment -4.965e+04 1.751e+05 -0.284 0.776789
## Store33:Unemployment -3.680e+05 4.042e+05 -0.910 0.362666
## Store34:Unemployment -3.920e+05 3.967e+05 -0.988 0.323113
## Store35:Unemployment 1.669e+05 3.784e+05 0.441 0.659174
## Store36:Unemployment -2.053e+05 1.252e+05 -1.640 0.101121
## Store37:Unemployment -1.882e+05 1.257e+05 -1.498 0.134232
## Store38:Unemployment -3.785e+05 4.006e+05 -0.945 0.344753
## Store39:Unemployment 1.342e+05 1.214e+05 1.105 0.269268
## Store40:Unemployment -4.027e+05 4.116e+05 -0.978 0.327968
## Store41:Unemployment -3.554e+04 2.044e+05 -0.174 0.861994
## Store42:Unemployment -4.051e+05 4.047e+05 -1.001 0.316903
## Store43:Unemployment -2.307e+05 1.035e+05 -2.229 0.025849 *
## Store44:Unemployment -4.362e+05 4.046e+05 -1.078 0.281086
## Store45:Unemployment -1.032e+05 2.254e+05 -0.458 0.647006
## Holiday_Flag1:Temperature 1.773e+03 5.901e+02 3.004 0.002683 **
## Holiday_Flag1:Fuel_Price -4.102e+04 4.598e+04 -0.892 0.372416
## Holiday_Flag1:CPI 4.589e+03 5.552e+03 0.826 0.408574
## Holiday_Flag1:Unemployment 2.099e+03 2.237e+04 0.094 0.925252
## Temperature:Fuel_Price 2.171e+03 6.870e+02 3.160 0.001591 **
## Temperature:CPI -2.497e+02 9.124e+01 -2.737 0.006231 **
## Temperature:Unemployment -2.939e+02 3.677e+02 -0.799 0.424225
## Fuel_Price:CPI -1.264e+04 3.901e+03 -3.241 0.001199 **
## Fuel_Price:Unemployment -1.869e+04 2.318e+04 -0.806 0.420044
## CPI:Unemployment -2.875e+03 4.272e+03 -0.673 0.501027
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 151100 on 4220 degrees of freedom
## Multiple R-squared: 0.9324, Adjusted R-squared: 0.928
## F-statistic: 208.7 on 279 and 4220 DF, p-value: < 2.2e-16
## Backward Elimination Method
## ---------------------------
##
## Candidate Terms:
##
## 1. Store
## 2. Holiday_Flag
## 3. Temperature
## 4. Fuel_Price
## 5. CPI
## 6. Unemployment
## 7. Store:Holiday_Flag
## 8. Store:Temperature
## 9. Store:Fuel_Price
## 10. Store:CPI
## 11. Store:Unemployment
## 12. Holiday_Flag:Temperature
## 13. Holiday_Flag:Fuel_Price
## 14. Holiday_Flag:CPI
## 15. Holiday_Flag:Unemployment
## 16. Temperature:Fuel_Price
## 17. Temperature:CPI
## 18. Temperature:Unemployment
## 19. Fuel_Price:CPI
## 20. Fuel_Price:Unemployment
## 21. CPI:Unemployment
##
##
## Step => 0
## Model => Weekly_Sales ~ Store + Holiday_Flag + Temperature + Fuel_Price + CPI + Unemployment + Store:Holiday_Flag + Store:Temperature + Store:Fuel_Price + Store:CPI + Store:Unemployment + Holiday_Flag:Temperature + Holiday_Flag:Fuel_Price + Holiday_Flag:CPI + Holiday_Flag:Unemployment + Temperature:Fuel_Price + Temperature:CPI + Temperature:Unemployment + Fuel_Price:CPI + Fuel_Price:Unemployment + CPI:Unemployment
## R2 => 0.932
##
## Initiating stepwise selection...
##
## Step => 1
## Removed => Holiday_Flag:Unemployment
## Model => Weekly_Sales ~ Store + Holiday_Flag + Temperature + Fuel_Price + CPI + Unemployment + Store:Holiday_Flag + Store:Temperature + Store:Fuel_Price + Store:CPI + Store:Unemployment + Holiday_Flag:Temperature + Holiday_Flag:Fuel_Price + Holiday_Flag:CPI + Temperature:Fuel_Price + Temperature:CPI + Temperature:Unemployment + Fuel_Price:CPI + Fuel_Price:Unemployment + CPI:Unemployment
## R2 => 0.93242
##
## Step => 2
## Removed => Unemployment
## Model => Weekly_Sales ~ Store + Holiday_Flag + Temperature + Fuel_Price + CPI + Store:Holiday_Flag + Store:Temperature + Store:Fuel_Price + Store:CPI + Store:Unemployment + Holiday_Flag:Temperature + Holiday_Flag:Fuel_Price + Holiday_Flag:CPI + Temperature:Fuel_Price + Temperature:CPI + Temperature:Unemployment + Fuel_Price:CPI + Fuel_Price:Unemployment + CPI:Unemployment
## R2 => 0.93242
##
## Step => 3
## Removed => CPI:Unemployment
## Model => Weekly_Sales ~ Store + Holiday_Flag + Temperature + Fuel_Price + CPI + Store:Holiday_Flag + Store:Temperature + Store:Fuel_Price + Store:CPI + Store:Unemployment + Holiday_Flag:Temperature + Holiday_Flag:Fuel_Price + Holiday_Flag:CPI + Temperature:Fuel_Price + Temperature:CPI + Temperature:Unemployment + Fuel_Price:CPI + Fuel_Price:Unemployment
## R2 => 0.93241
##
## Step => 4
## Removed => Holiday_Flag:CPI
## Model => Weekly_Sales ~ Store + Holiday_Flag + Temperature + Fuel_Price + CPI + Store:Holiday_Flag + Store:Temperature + Store:Fuel_Price + Store:CPI + Store:Unemployment + Holiday_Flag:Temperature + Holiday_Flag:Fuel_Price + Temperature:Fuel_Price + Temperature:CPI + Temperature:Unemployment + Fuel_Price:CPI + Fuel_Price:Unemployment
## R2 => 0.9324
##
## Step => 5
## Removed => Holiday_Flag:Fuel_Price
## Model => Weekly_Sales ~ Store + Holiday_Flag + Temperature + Fuel_Price + CPI + Store:Holiday_Flag + Store:Temperature + Store:Fuel_Price + Store:CPI + Store:Unemployment + Holiday_Flag:Temperature + Temperature:Fuel_Price + Temperature:CPI + Temperature:Unemployment + Fuel_Price:CPI + Fuel_Price:Unemployment
## R2 => 0.9324
##
## Step => 6
## Removed => Temperature:Unemployment
## Model => Weekly_Sales ~ Store + Holiday_Flag + Temperature + Fuel_Price + CPI + Store:Holiday_Flag + Store:Temperature + Store:Fuel_Price + Store:CPI + Store:Unemployment + Holiday_Flag:Temperature + Temperature:Fuel_Price + Temperature:CPI + Fuel_Price:CPI + Fuel_Price:Unemployment
## R2 => 0.93239
##
## Step => 7
## Removed => Store:Holiday_Flag
## Model => Weekly_Sales ~ Store + Holiday_Flag + Temperature + Fuel_Price + CPI + Store:Temperature + Store:Fuel_Price + Store:CPI + Store:Unemployment + Holiday_Flag:Temperature + Temperature:Fuel_Price + Temperature:CPI + Fuel_Price:CPI + Fuel_Price:Unemployment
## R2 => 0.93169
##
##
## No more variables to be removed.
##
## Variables Removed:
##
## => Holiday_Flag:Unemployment
## => Unemployment
## => CPI:Unemployment
## => Holiday_Flag:CPI
## => Holiday_Flag:Fuel_Price
## => Temperature:Unemployment
## => Store:Holiday_Flag
##
## Call:
## lm(formula = paste(response, "~", paste(c(include, cterms), collapse = " + ")),
## data = l)
##
## Residuals:
## Min 1Q Median 3Q Max
## -601602 -57809 -8836 33189 1634114
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -1.685e+07 3.885e+06 -4.338 1.47e-05 ***
## Store2 -2.292e+06 5.415e+06 -0.423 0.672114
## Store3 3.973e+06 4.048e+06 0.981 0.326420
## Store4 2.992e+06 6.255e+06 0.478 0.632468
## Store5 4.346e+06 4.162e+06 1.044 0.296433
## Store6 4.180e+06 4.284e+06 0.976 0.329270
## Store7 -3.047e+06 4.728e+06 -0.644 0.519389
## Store8 5.970e+06 3.696e+06 1.615 0.106355
## Store9 3.240e+06 4.174e+06 0.776 0.437581
## Store10 1.180e+07 6.484e+06 1.820 0.068873 .
## Store11 1.847e+06 3.797e+06 0.486 0.626668
## Store12 3.808e+06 5.117e+06 0.744 0.456708
## Store13 1.676e+07 7.829e+06 2.141 0.032360 *
## Store14 1.423e+07 3.035e+06 4.687 2.85e-06 ***
## Store15 8.127e+06 2.886e+06 2.816 0.004881 **
## Store16 2.619e+06 4.318e+06 0.606 0.544219
## Store17 9.173e+06 4.108e+06 2.233 0.025595 *
## Store18 1.217e+07 4.570e+06 2.662 0.007787 **
## Store19 9.156e+06 2.937e+06 3.118 0.001836 **
## Store20 5.968e+06 2.943e+06 2.028 0.042617 *
## Store21 5.766e+05 5.305e+06 0.109 0.913453
## Store22 8.440e+06 4.468e+06 1.889 0.058960 .
## Store23 1.047e+07 5.566e+06 1.881 0.060019 .
## Store24 6.748e+06 3.206e+06 2.105 0.035371 *
## Store25 4.352e+06 2.927e+06 1.487 0.137125
## Store26 9.934e+06 5.987e+06 1.659 0.097155 .
## Store27 1.120e+07 2.845e+06 3.936 8.42e-05 ***
## Store28 6.143e+06 4.831e+06 1.272 0.203615
## Store29 6.792e+06 4.353e+06 1.560 0.118744
## Store30 1.010e+07 5.202e+06 1.941 0.052293 .
## Store31 -4.720e+05 5.326e+06 -0.089 0.929391
## Store32 1.254e+06 4.831e+06 0.260 0.795203
## Store33 7.454e+06 6.520e+06 1.143 0.252974
## Store34 9.567e+06 3.719e+06 2.572 0.010141 *
## Store35 8.614e+06 2.890e+06 2.980 0.002897 **
## Store36 1.219e+07 5.198e+06 2.345 0.019066 *
## Store37 8.741e+06 5.212e+06 1.677 0.093589 .
## Store38 7.395e+06 5.536e+06 1.336 0.181714
## Store39 -1.307e+07 5.088e+06 -2.568 0.010252 *
## Store40 9.110e+06 6.090e+06 1.496 0.134789
## Store41 -3.041e+06 5.132e+06 -0.593 0.553495
## Store42 1.114e+07 6.462e+06 1.724 0.084796 .
## Store43 7.988e+06 3.059e+06 2.612 0.009045 **
## Store44 1.232e+07 8.545e+06 1.442 0.149487
## Store45 5.004e+06 3.128e+06 1.600 0.109708
## Holiday_Flag1 1.175e+04 2.466e+04 0.477 0.633680
## Temperature 3.781e+04 1.617e+04 2.338 0.019450 *
## Fuel_Price 2.791e+06 9.313e+05 2.997 0.002747 **
## CPI 8.102e+04 1.617e+04 5.011 5.62e-07 ***
## Store2:Temperature -2.281e+03 1.614e+03 -1.413 0.157650
## Store3:Temperature 1.540e+03 1.803e+03 0.854 0.393199
## Store4:Temperature -2.010e+04 7.294e+03 -2.756 0.005873 **
## Store5:Temperature 2.260e+03 1.706e+03 1.324 0.185408
## Store6:Temperature 3.917e+03 1.677e+03 2.335 0.019574 *
## Store7:Temperature -9.802e+02 2.375e+03 -0.413 0.679841
## Store8:Temperature 1.230e+03 1.587e+03 0.775 0.438236
## Store9:Temperature 2.220e+03 1.617e+03 1.373 0.169899
## Store10:Temperature -2.571e+04 7.494e+03 -3.430 0.000608 ***
## Store11:Temperature -3.156e+02 1.770e+03 -0.178 0.858497
## Store12:Temperature -2.074e+04 7.460e+03 -2.781 0.005445 **
## Store13:Temperature -1.886e+04 7.354e+03 -2.565 0.010348 *
## Store14:Temperature -6.235e+03 2.950e+03 -2.113 0.034647 *
## Store15:Temperature -1.680e+04 6.977e+03 -2.408 0.016093 *
## Store16:Temperature -1.415e+03 2.342e+03 -0.604 0.545901
## Store17:Temperature -1.655e+04 7.363e+03 -2.248 0.024657 *
## Store18:Temperature -1.625e+04 6.955e+03 -2.336 0.019538 *
## Store19:Temperature -1.742e+04 6.947e+03 -2.507 0.012198 *
## Store20:Temperature -4.757e+03 1.671e+03 -2.847 0.004432 **
## Store21:Temperature 1.135e+03 1.608e+03 0.705 0.480585
## Store22:Temperature -1.462e+04 6.605e+03 -2.214 0.026878 *
## Store23:Temperature -1.476e+04 6.900e+03 -2.140 0.032424 *
## Store24:Temperature -1.647e+04 6.970e+03 -2.363 0.018193 *
## Store25:Temperature 1.914e+02 1.662e+03 0.115 0.908310
## Store26:Temperature -1.484e+04 6.917e+03 -2.146 0.031917 *
## Store27:Temperature -1.305e+04 6.648e+03 -1.962 0.049785 *
## Store28:Temperature -2.233e+04 7.486e+03 -2.983 0.002871 **
## Store29:Temperature -1.674e+04 6.956e+03 -2.407 0.016134 *
## Store30:Temperature 1.899e+03 1.592e+03 1.193 0.232991
## Store31:Temperature -5.070e+02 1.573e+03 -0.322 0.747246
## Store32:Temperature -2.674e+03 2.379e+03 -1.124 0.261171
## Store33:Temperature -1.714e+04 7.481e+03 -2.291 0.022004 *
## Store34:Temperature -1.792e+04 7.273e+03 -2.464 0.013769 *
## Store35:Temperature -1.421e+04 6.557e+03 -2.167 0.030304 *
## Store36:Temperature 2.659e+03 1.926e+03 1.381 0.167420
## Store37:Temperature 1.357e+03 1.885e+03 0.720 0.471747
## Store38:Temperature -1.757e+04 7.481e+03 -2.349 0.018868 *
## Store39:Temperature 3.230e+03 1.860e+03 1.736 0.082569 .
## Store40:Temperature -1.440e+04 6.886e+03 -2.092 0.036493 *
## Store41:Temperature -2.066e+03 2.332e+03 -0.886 0.375657
## Store42:Temperature -1.810e+04 7.492e+03 -2.416 0.015754 *
## Store43:Temperature 1.188e+03 1.737e+03 0.684 0.494011
## Store44:Temperature -1.666e+04 7.343e+03 -2.269 0.023307 *
## Store45:Temperature -5.501e+03 2.977e+03 -1.848 0.064642 .
## Store2:Fuel_Price -1.843e+05 9.013e+04 -2.044 0.040985 *
## Store3:Fuel_Price 5.529e+04 1.001e+05 0.552 0.580655
## Store4:Fuel_Price -1.233e+06 3.574e+05 -3.449 0.000568 ***
## Store5:Fuel_Price 5.569e+03 9.404e+04 0.059 0.952779
## Store6:Fuel_Price -6.904e+04 8.956e+04 -0.771 0.440839
## Store7:Fuel_Price -1.808e+05 1.162e+05 -1.556 0.119710
## Store8:Fuel_Price 6.290e+04 9.252e+04 0.680 0.496624
## Store9:Fuel_Price 3.696e+04 9.128e+04 0.405 0.685535
## Store10:Fuel_Price -1.210e+06 3.405e+05 -3.554 0.000384 ***
## Store11:Fuel_Price -5.583e+04 9.615e+04 -0.581 0.561510
## Store12:Fuel_Price -9.753e+05 3.037e+05 -3.212 0.001329 **
## Store13:Fuel_Price -1.025e+06 3.592e+05 -2.853 0.004349 **
## Store14:Fuel_Price -2.539e+05 1.345e+05 -1.887 0.059195 .
## Store15:Fuel_Price -1.053e+06 3.203e+05 -3.286 0.001025 **
## Store16:Fuel_Price -2.466e+05 1.397e+05 -1.765 0.077557 .
## Store17:Fuel_Price -1.024e+06 3.642e+05 -2.811 0.004968 **
## Store18:Fuel_Price -1.030e+06 3.083e+05 -3.341 0.000841 ***
## Store19:Fuel_Price -1.105e+06 3.203e+05 -3.449 0.000567 ***
## Store20:Fuel_Price -1.643e+05 9.096e+04 -1.806 0.070912 .
## Store21:Fuel_Price -5.884e+03 8.930e+04 -0.066 0.947466
## Store22:Fuel_Price -9.817e+05 3.022e+05 -3.249 0.001169 **
## Store23:Fuel_Price -1.131e+06 3.553e+05 -3.183 0.001471 **
## Store24:Fuel_Price -1.092e+06 3.166e+05 -3.448 0.000570 ***
## Store25:Fuel_Price -1.239e+05 9.052e+04 -1.369 0.171093
## Store26:Fuel_Price -1.008e+06 3.207e+05 -3.143 0.001684 **
## Store27:Fuel_Price -1.072e+06 3.052e+05 -3.514 0.000446 ***
## Store28:Fuel_Price -9.588e+05 3.005e+05 -3.190 0.001431 **
## Store29:Fuel_Price -9.299e+05 2.979e+05 -3.121 0.001811 **
## Store30:Fuel_Price 6.073e+04 9.000e+04 0.675 0.499859
## Store31:Fuel_Price 2.675e+03 8.907e+04 0.030 0.976044
## Store32:Fuel_Price -1.607e+05 1.152e+05 -1.395 0.162973
## Store33:Fuel_Price -1.042e+06 3.376e+05 -3.085 0.002045 **
## Store34:Fuel_Price -9.785e+05 3.213e+05 -3.046 0.002336 **
## Store35:Fuel_Price -8.985e+05 2.973e+05 -3.022 0.002527 **
## Store36:Fuel_Price 8.238e+04 9.400e+04 0.876 0.380870
## Store37:Fuel_Price 8.226e+04 9.375e+04 0.877 0.380293
## Store38:Fuel_Price -8.559e+05 3.054e+05 -2.803 0.005085 **
## Store39:Fuel_Price -2.108e+05 9.523e+04 -2.213 0.026944 *
## Store40:Fuel_Price -1.071e+06 3.554e+05 -3.012 0.002607 **
## Store41:Fuel_Price -2.074e+05 1.285e+05 -1.614 0.106631
## Store42:Fuel_Price -9.634e+05 3.391e+05 -2.841 0.004516 **
## Store43:Fuel_Price 6.212e+04 1.020e+05 0.609 0.542560
## Store44:Fuel_Price -1.014e+06 3.619e+05 -2.802 0.005097 **
## Store45:Fuel_Price -2.781e+05 1.369e+05 -2.031 0.042318 *
## Store2:CPI 1.374e+04 2.135e+04 0.644 0.519684
## Store3:CPI -1.991e+04 1.592e+04 -1.250 0.211225
## Store4:CPI 4.789e+04 4.301e+04 1.114 0.265534
## Store5:CPI -2.148e+04 1.605e+04 -1.338 0.180964
## Store6:CPI -1.574e+04 1.701e+04 -0.925 0.354874
## Store7:CPI 1.152e+04 1.876e+04 0.614 0.539169
## Store8:CPI -2.604e+04 1.437e+04 -1.812 0.070031 .
## Store9:CPI -1.683e+04 1.643e+04 -1.024 0.305704
## Store10:CPI -1.747e+04 4.444e+04 -0.393 0.694217
## Store11:CPI -5.617e+03 1.487e+04 -0.378 0.705631
## Store12:CPI 2.223e+04 3.519e+04 0.632 0.527575
## Store13:CPI -6.099e+04 5.518e+04 -1.105 0.269076
## Store14:CPI -6.184e+04 1.173e+04 -5.273 1.41e-07 ***
## Store15:CPI -8.895e+03 1.737e+04 -0.512 0.608634
## Store16:CPI -9.901e+03 1.644e+04 -0.602 0.547008
## Store17:CPI -1.641e+04 2.541e+04 -0.646 0.518398
## Store18:CPI -3.385e+04 2.503e+04 -1.352 0.176337
## Store19:CPI -8.046e+03 1.757e+04 -0.458 0.646976
## Store20:CPI -1.464e+04 1.151e+04 -1.272 0.203586
## Store21:CPI -6.561e+03 2.097e+04 -0.313 0.754426
## Store22:CPI -1.219e+04 2.400e+04 -0.508 0.611530
## Store23:CPI -1.882e+04 3.288e+04 -0.572 0.567219
## Store24:CPI 7.962e+03 2.394e+04 0.333 0.739418
## Store25:CPI -1.617e+04 1.149e+04 -1.406 0.159668
## Store26:CPI -2.059e+04 3.097e+04 -0.665 0.506225
## Store27:CPI -1.733e+04 1.751e+04 -0.989 0.322623
## Store28:CPI 6.739e+03 3.280e+04 0.205 0.837234
## Store29:CPI -8.701e+03 2.405e+04 -0.362 0.717512
## Store30:CPI -4.411e+04 2.047e+04 -2.154 0.031266 *
## Store31:CPI 1.623e+03 2.111e+04 0.077 0.938713
## Store32:CPI -2.560e+03 1.915e+04 -0.134 0.893640
## Store33:CPI -1.067e+04 4.505e+04 -0.237 0.812734
## Store34:CPI -2.051e+04 2.184e+04 -0.939 0.347836
## Store35:CPI -5.033e+04 1.534e+04 -3.281 0.001043 **
## Store36:CPI -5.572e+04 2.095e+04 -2.659 0.007857 **
## Store37:CPI -3.910e+04 2.098e+04 -1.863 0.062480 .
## Store38:CPI -1.210e+04 3.863e+04 -0.313 0.754121
## Store39:CPI 5.839e+04 2.062e+04 2.831 0.004660 **
## Store40:CPI -1.623e+04 3.646e+04 -0.445 0.656334
## Store41:CPI 1.969e+04 2.018e+04 0.976 0.329228
## Store42:CPI -3.555e+04 4.390e+04 -0.810 0.418066
## Store43:CPI -3.480e+04 1.246e+04 -2.794 0.005236 **
## Store44:CPI -4.476e+04 6.070e+04 -0.737 0.460940
## Store45:CPI -2.034e+04 1.223e+04 -1.663 0.096392 .
## Store1:Unemployment 2.336e+05 9.934e+04 2.352 0.018736 *
## Store2:Unemployment 2.955e+05 1.308e+05 2.259 0.023933 *
## Store3:Unemployment 8.735e+04 1.078e+05 0.810 0.417812
## Store4:Unemployment 7.630e+04 6.973e+04 1.094 0.273903
## Store5:Unemployment 8.586e+04 1.287e+05 0.667 0.504778
## Store6:Unemployment 1.277e+05 1.108e+05 1.153 0.249114
## Store7:Unemployment 3.446e+05 1.338e+05 2.575 0.010064 *
## Store8:Unemployment 5.846e+04 1.151e+05 0.508 0.611399
## Store9:Unemployment 1.183e+05 1.173e+05 1.009 0.313224
## Store10:Unemployment 6.416e+04 9.915e+04 0.647 0.517598
## Store11:Unemployment 1.499e+05 1.025e+05 1.462 0.143730
## Store12:Unemployment 1.427e+05 8.412e+04 1.697 0.089773 .
## Store13:Unemployment -7.714e+03 1.094e+05 -0.070 0.943814
## Store14:Unemployment 1.843e+05 1.618e+05 1.139 0.254711
## Store15:Unemployment 6.614e+04 1.304e+05 0.507 0.612161
## Store16:Unemployment 2.174e+05 1.679e+05 1.295 0.195460
## Store17:Unemployment 8.210e+04 9.431e+04 0.871 0.384055
## Store18:Unemployment 3.101e+04 1.235e+05 0.251 0.801760
## Store19:Unemployment 5.404e+04 1.332e+05 0.406 0.685026
## Store20:Unemployment 5.590e+04 1.031e+05 0.542 0.587730
## Store21:Unemployment 2.350e+05 1.260e+05 1.865 0.062212 .
## Store22:Unemployment 7.849e+04 1.239e+05 0.634 0.526357
## Store23:Unemployment 1.498e+04 1.537e+05 0.097 0.922334
## Store24:Unemployment 6.490e+04 1.466e+05 0.443 0.657948
## Store25:Unemployment 7.120e+04 9.829e+04 0.724 0.468870
## Store26:Unemployment 5.125e+04 1.983e+05 0.258 0.796116
## Store27:Unemployment -4.964e+04 1.459e+05 -0.340 0.733649
## Store28:Unemployment 1.444e+05 8.361e+04 1.727 0.084187 .
## Store29:Unemployment 1.531e+05 9.957e+04 1.538 0.124214
## Store30:Unemployment -3.001e+04 1.261e+05 -0.238 0.811920
## Store31:Unemployment 2.358e+05 1.261e+05 1.871 0.061444 .
## Store32:Unemployment 2.310e+05 1.359e+05 1.700 0.089188 .
## Store33:Unemployment 1.370e+05 9.654e+04 1.419 0.155859
## Store34:Unemployment 1.023e+05 7.217e+04 1.417 0.156564
## Store35:Unemployment 6.190e+05 1.363e+05 4.541 5.76e-06 ***
## Store36:Unemployment -7.268e+02 1.135e+05 -0.006 0.994889
## Store37:Unemployment 1.399e+04 1.147e+05 0.122 0.902964
## Store38:Unemployment 1.083e+05 8.487e+04 1.276 0.202040
## Store39:Unemployment 3.474e+05 1.111e+05 3.128 0.001772 **
## Store40:Unemployment 9.204e+04 1.735e+05 0.531 0.595716
## Store41:Unemployment 2.915e+05 1.679e+05 1.736 0.082648 .
## Store42:Unemployment 9.006e+04 1.003e+05 0.898 0.369372
## Store43:Unemployment 2.716e+04 7.124e+04 0.381 0.703009
## Store44:Unemployment 6.383e+04 1.115e+05 0.572 0.567157
## Store45:Unemployment 2.190e+05 1.686e+05 1.299 0.194108
## Holiday_Flag1:Temperature 9.779e+02 4.456e+02 2.194 0.028260 *
## Temperature:Fuel_Price 2.306e+03 6.679e+02 3.453 0.000560 ***
## Temperature:CPI -2.201e+02 8.230e+01 -2.674 0.007530 **
## Fuel_Price:CPI -1.284e+04 3.873e+03 -3.315 0.000923 ***
## Fuel_Price:Unemployment -3.150e+04 1.840e+04 -1.712 0.087010 .
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 151000 on 4269 degrees of freedom
## Multiple R-squared: 0.9317, Adjusted R-squared: 0.928
## F-statistic: 253.1 on 230 and 4269 DF, p-value: < 2.2e-16
##
## Call:
## lm(formula = paste(response, "~", paste(c(include, cterms), collapse = " + ")),
## data = l)
##
## Residuals:
## Min 1Q Median 3Q Max
## -601602 -57809 -8836 33189 1634114
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -1.685e+07 3.885e+06 -4.338 1.47e-05 ***
## Store2 -2.292e+06 5.415e+06 -0.423 0.672114
## Store3 3.973e+06 4.048e+06 0.981 0.326420
## Store4 2.992e+06 6.255e+06 0.478 0.632468
## Store5 4.346e+06 4.162e+06 1.044 0.296433
## Store6 4.180e+06 4.284e+06 0.976 0.329270
## Store7 -3.047e+06 4.728e+06 -0.644 0.519389
## Store8 5.970e+06 3.696e+06 1.615 0.106355
## Store9 3.240e+06 4.174e+06 0.776 0.437581
## Store10 1.180e+07 6.484e+06 1.820 0.068873 .
## Store11 1.847e+06 3.797e+06 0.486 0.626668
## Store12 3.808e+06 5.117e+06 0.744 0.456708
## Store13 1.676e+07 7.829e+06 2.141 0.032360 *
## Store14 1.423e+07 3.035e+06 4.687 2.85e-06 ***
## Store15 8.127e+06 2.886e+06 2.816 0.004881 **
## Store16 2.619e+06 4.318e+06 0.606 0.544219
## Store17 9.173e+06 4.108e+06 2.233 0.025595 *
## Store18 1.217e+07 4.570e+06 2.662 0.007787 **
## Store19 9.156e+06 2.937e+06 3.118 0.001836 **
## Store20 5.968e+06 2.943e+06 2.028 0.042617 *
## Store21 5.766e+05 5.305e+06 0.109 0.913453
## Store22 8.440e+06 4.468e+06 1.889 0.058960 .
## Store23 1.047e+07 5.566e+06 1.881 0.060019 .
## Store24 6.748e+06 3.206e+06 2.105 0.035371 *
## Store25 4.352e+06 2.927e+06 1.487 0.137125
## Store26 9.934e+06 5.987e+06 1.659 0.097155 .
## Store27 1.120e+07 2.845e+06 3.936 8.42e-05 ***
## Store28 6.143e+06 4.831e+06 1.272 0.203615
## Store29 6.792e+06 4.353e+06 1.560 0.118744
## Store30 1.010e+07 5.202e+06 1.941 0.052293 .
## Store31 -4.720e+05 5.326e+06 -0.089 0.929391
## Store32 1.254e+06 4.831e+06 0.260 0.795203
## Store33 7.454e+06 6.520e+06 1.143 0.252974
## Store34 9.567e+06 3.719e+06 2.572 0.010141 *
## Store35 8.614e+06 2.890e+06 2.980 0.002897 **
## Store36 1.219e+07 5.198e+06 2.345 0.019066 *
## Store37 8.741e+06 5.212e+06 1.677 0.093589 .
## Store38 7.395e+06 5.536e+06 1.336 0.181714
## Store39 -1.307e+07 5.088e+06 -2.568 0.010252 *
## Store40 9.110e+06 6.090e+06 1.496 0.134789
## Store41 -3.041e+06 5.132e+06 -0.593 0.553495
## Store42 1.114e+07 6.462e+06 1.724 0.084796 .
## Store43 7.988e+06 3.059e+06 2.612 0.009045 **
## Store44 1.232e+07 8.545e+06 1.442 0.149487
## Store45 5.004e+06 3.128e+06 1.600 0.109708
## Holiday_Flag1 1.175e+04 2.466e+04 0.477 0.633680
## Temperature 3.781e+04 1.617e+04 2.338 0.019450 *
## Fuel_Price 2.791e+06 9.313e+05 2.997 0.002747 **
## CPI 8.102e+04 1.617e+04 5.011 5.62e-07 ***
## Store2:Temperature -2.281e+03 1.614e+03 -1.413 0.157650
## Store3:Temperature 1.540e+03 1.803e+03 0.854 0.393199
## Store4:Temperature -2.010e+04 7.294e+03 -2.756 0.005873 **
## Store5:Temperature 2.260e+03 1.706e+03 1.324 0.185408
## Store6:Temperature 3.917e+03 1.677e+03 2.335 0.019574 *
## Store7:Temperature -9.802e+02 2.375e+03 -0.413 0.679841
## Store8:Temperature 1.230e+03 1.587e+03 0.775 0.438236
## Store9:Temperature 2.220e+03 1.617e+03 1.373 0.169899
## Store10:Temperature -2.571e+04 7.494e+03 -3.430 0.000608 ***
## Store11:Temperature -3.156e+02 1.770e+03 -0.178 0.858497
## Store12:Temperature -2.074e+04 7.460e+03 -2.781 0.005445 **
## Store13:Temperature -1.886e+04 7.354e+03 -2.565 0.010348 *
## Store14:Temperature -6.235e+03 2.950e+03 -2.113 0.034647 *
## Store15:Temperature -1.680e+04 6.977e+03 -2.408 0.016093 *
## Store16:Temperature -1.415e+03 2.342e+03 -0.604 0.545901
## Store17:Temperature -1.655e+04 7.363e+03 -2.248 0.024657 *
## Store18:Temperature -1.625e+04 6.955e+03 -2.336 0.019538 *
## Store19:Temperature -1.742e+04 6.947e+03 -2.507 0.012198 *
## Store20:Temperature -4.757e+03 1.671e+03 -2.847 0.004432 **
## Store21:Temperature 1.135e+03 1.608e+03 0.705 0.480585
## Store22:Temperature -1.462e+04 6.605e+03 -2.214 0.026878 *
## Store23:Temperature -1.476e+04 6.900e+03 -2.140 0.032424 *
## Store24:Temperature -1.647e+04 6.970e+03 -2.363 0.018193 *
## Store25:Temperature 1.914e+02 1.662e+03 0.115 0.908310
## Store26:Temperature -1.484e+04 6.917e+03 -2.146 0.031917 *
## Store27:Temperature -1.305e+04 6.648e+03 -1.962 0.049785 *
## Store28:Temperature -2.233e+04 7.486e+03 -2.983 0.002871 **
## Store29:Temperature -1.674e+04 6.956e+03 -2.407 0.016134 *
## Store30:Temperature 1.899e+03 1.592e+03 1.193 0.232991
## Store31:Temperature -5.070e+02 1.573e+03 -0.322 0.747246
## Store32:Temperature -2.674e+03 2.379e+03 -1.124 0.261171
## Store33:Temperature -1.714e+04 7.481e+03 -2.291 0.022004 *
## Store34:Temperature -1.792e+04 7.273e+03 -2.464 0.013769 *
## Store35:Temperature -1.421e+04 6.557e+03 -2.167 0.030304 *
## Store36:Temperature 2.659e+03 1.926e+03 1.381 0.167420
## Store37:Temperature 1.357e+03 1.885e+03 0.720 0.471747
## Store38:Temperature -1.757e+04 7.481e+03 -2.349 0.018868 *
## Store39:Temperature 3.230e+03 1.860e+03 1.736 0.082569 .
## Store40:Temperature -1.440e+04 6.886e+03 -2.092 0.036493 *
## Store41:Temperature -2.066e+03 2.332e+03 -0.886 0.375657
## Store42:Temperature -1.810e+04 7.492e+03 -2.416 0.015754 *
## Store43:Temperature 1.188e+03 1.737e+03 0.684 0.494011
## Store44:Temperature -1.666e+04 7.343e+03 -2.269 0.023307 *
## Store45:Temperature -5.501e+03 2.977e+03 -1.848 0.064642 .
## Store2:Fuel_Price -1.843e+05 9.013e+04 -2.044 0.040985 *
## Store3:Fuel_Price 5.529e+04 1.001e+05 0.552 0.580655
## Store4:Fuel_Price -1.233e+06 3.574e+05 -3.449 0.000568 ***
## Store5:Fuel_Price 5.569e+03 9.404e+04 0.059 0.952779
## Store6:Fuel_Price -6.904e+04 8.956e+04 -0.771 0.440839
## Store7:Fuel_Price -1.808e+05 1.162e+05 -1.556 0.119710
## Store8:Fuel_Price 6.290e+04 9.252e+04 0.680 0.496624
## Store9:Fuel_Price 3.696e+04 9.128e+04 0.405 0.685535
## Store10:Fuel_Price -1.210e+06 3.405e+05 -3.554 0.000384 ***
## Store11:Fuel_Price -5.583e+04 9.615e+04 -0.581 0.561510
## Store12:Fuel_Price -9.753e+05 3.037e+05 -3.212 0.001329 **
## Store13:Fuel_Price -1.025e+06 3.592e+05 -2.853 0.004349 **
## Store14:Fuel_Price -2.539e+05 1.345e+05 -1.887 0.059195 .
## Store15:Fuel_Price -1.053e+06 3.203e+05 -3.286 0.001025 **
## Store16:Fuel_Price -2.466e+05 1.397e+05 -1.765 0.077557 .
## Store17:Fuel_Price -1.024e+06 3.642e+05 -2.811 0.004968 **
## Store18:Fuel_Price -1.030e+06 3.083e+05 -3.341 0.000841 ***
## Store19:Fuel_Price -1.105e+06 3.203e+05 -3.449 0.000567 ***
## Store20:Fuel_Price -1.643e+05 9.096e+04 -1.806 0.070912 .
## Store21:Fuel_Price -5.884e+03 8.930e+04 -0.066 0.947466
## Store22:Fuel_Price -9.817e+05 3.022e+05 -3.249 0.001169 **
## Store23:Fuel_Price -1.131e+06 3.553e+05 -3.183 0.001471 **
## Store24:Fuel_Price -1.092e+06 3.166e+05 -3.448 0.000570 ***
## Store25:Fuel_Price -1.239e+05 9.052e+04 -1.369 0.171093
## Store26:Fuel_Price -1.008e+06 3.207e+05 -3.143 0.001684 **
## Store27:Fuel_Price -1.072e+06 3.052e+05 -3.514 0.000446 ***
## Store28:Fuel_Price -9.588e+05 3.005e+05 -3.190 0.001431 **
## Store29:Fuel_Price -9.299e+05 2.979e+05 -3.121 0.001811 **
## Store30:Fuel_Price 6.073e+04 9.000e+04 0.675 0.499859
## Store31:Fuel_Price 2.675e+03 8.907e+04 0.030 0.976044
## Store32:Fuel_Price -1.607e+05 1.152e+05 -1.395 0.162973
## Store33:Fuel_Price -1.042e+06 3.376e+05 -3.085 0.002045 **
## Store34:Fuel_Price -9.785e+05 3.213e+05 -3.046 0.002336 **
## Store35:Fuel_Price -8.985e+05 2.973e+05 -3.022 0.002527 **
## Store36:Fuel_Price 8.238e+04 9.400e+04 0.876 0.380870
## Store37:Fuel_Price 8.226e+04 9.375e+04 0.877 0.380293
## Store38:Fuel_Price -8.559e+05 3.054e+05 -2.803 0.005085 **
## Store39:Fuel_Price -2.108e+05 9.523e+04 -2.213 0.026944 *
## Store40:Fuel_Price -1.071e+06 3.554e+05 -3.012 0.002607 **
## Store41:Fuel_Price -2.074e+05 1.285e+05 -1.614 0.106631
## Store42:Fuel_Price -9.634e+05 3.391e+05 -2.841 0.004516 **
## Store43:Fuel_Price 6.212e+04 1.020e+05 0.609 0.542560
## Store44:Fuel_Price -1.014e+06 3.619e+05 -2.802 0.005097 **
## Store45:Fuel_Price -2.781e+05 1.369e+05 -2.031 0.042318 *
## Store2:CPI 1.374e+04 2.135e+04 0.644 0.519684
## Store3:CPI -1.991e+04 1.592e+04 -1.250 0.211225
## Store4:CPI 4.789e+04 4.301e+04 1.114 0.265534
## Store5:CPI -2.148e+04 1.605e+04 -1.338 0.180964
## Store6:CPI -1.574e+04 1.701e+04 -0.925 0.354874
## Store7:CPI 1.152e+04 1.876e+04 0.614 0.539169
## Store8:CPI -2.604e+04 1.437e+04 -1.812 0.070031 .
## Store9:CPI -1.683e+04 1.643e+04 -1.024 0.305704
## Store10:CPI -1.747e+04 4.444e+04 -0.393 0.694217
## Store11:CPI -5.617e+03 1.487e+04 -0.378 0.705631
## Store12:CPI 2.223e+04 3.519e+04 0.632 0.527575
## Store13:CPI -6.099e+04 5.518e+04 -1.105 0.269076
## Store14:CPI -6.184e+04 1.173e+04 -5.273 1.41e-07 ***
## Store15:CPI -8.895e+03 1.737e+04 -0.512 0.608634
## Store16:CPI -9.901e+03 1.644e+04 -0.602 0.547008
## Store17:CPI -1.641e+04 2.541e+04 -0.646 0.518398
## Store18:CPI -3.385e+04 2.503e+04 -1.352 0.176337
## Store19:CPI -8.046e+03 1.757e+04 -0.458 0.646976
## Store20:CPI -1.464e+04 1.151e+04 -1.272 0.203586
## Store21:CPI -6.561e+03 2.097e+04 -0.313 0.754426
## Store22:CPI -1.219e+04 2.400e+04 -0.508 0.611530
## Store23:CPI -1.882e+04 3.288e+04 -0.572 0.567219
## Store24:CPI 7.962e+03 2.394e+04 0.333 0.739418
## Store25:CPI -1.617e+04 1.149e+04 -1.406 0.159668
## Store26:CPI -2.059e+04 3.097e+04 -0.665 0.506225
## Store27:CPI -1.733e+04 1.751e+04 -0.989 0.322623
## Store28:CPI 6.739e+03 3.280e+04 0.205 0.837234
## Store29:CPI -8.701e+03 2.405e+04 -0.362 0.717512
## Store30:CPI -4.411e+04 2.047e+04 -2.154 0.031266 *
## Store31:CPI 1.623e+03 2.111e+04 0.077 0.938713
## Store32:CPI -2.560e+03 1.915e+04 -0.134 0.893640
## Store33:CPI -1.067e+04 4.505e+04 -0.237 0.812734
## Store34:CPI -2.051e+04 2.184e+04 -0.939 0.347836
## Store35:CPI -5.033e+04 1.534e+04 -3.281 0.001043 **
## Store36:CPI -5.572e+04 2.095e+04 -2.659 0.007857 **
## Store37:CPI -3.910e+04 2.098e+04 -1.863 0.062480 .
## Store38:CPI -1.210e+04 3.863e+04 -0.313 0.754121
## Store39:CPI 5.839e+04 2.062e+04 2.831 0.004660 **
## Store40:CPI -1.623e+04 3.646e+04 -0.445 0.656334
## Store41:CPI 1.969e+04 2.018e+04 0.976 0.329228
## Store42:CPI -3.555e+04 4.390e+04 -0.810 0.418066
## Store43:CPI -3.480e+04 1.246e+04 -2.794 0.005236 **
## Store44:CPI -4.476e+04 6.070e+04 -0.737 0.460940
## Store45:CPI -2.034e+04 1.223e+04 -1.663 0.096392 .
## Store1:Unemployment 2.336e+05 9.934e+04 2.352 0.018736 *
## Store2:Unemployment 2.955e+05 1.308e+05 2.259 0.023933 *
## Store3:Unemployment 8.735e+04 1.078e+05 0.810 0.417812
## Store4:Unemployment 7.630e+04 6.973e+04 1.094 0.273903
## Store5:Unemployment 8.586e+04 1.287e+05 0.667 0.504778
## Store6:Unemployment 1.277e+05 1.108e+05 1.153 0.249114
## Store7:Unemployment 3.446e+05 1.338e+05 2.575 0.010064 *
## Store8:Unemployment 5.846e+04 1.151e+05 0.508 0.611399
## Store9:Unemployment 1.183e+05 1.173e+05 1.009 0.313224
## Store10:Unemployment 6.416e+04 9.915e+04 0.647 0.517598
## Store11:Unemployment 1.499e+05 1.025e+05 1.462 0.143730
## Store12:Unemployment 1.427e+05 8.412e+04 1.697 0.089773 .
## Store13:Unemployment -7.714e+03 1.094e+05 -0.070 0.943814
## Store14:Unemployment 1.843e+05 1.618e+05 1.139 0.254711
## Store15:Unemployment 6.614e+04 1.304e+05 0.507 0.612161
## Store16:Unemployment 2.174e+05 1.679e+05 1.295 0.195460
## Store17:Unemployment 8.210e+04 9.431e+04 0.871 0.384055
## Store18:Unemployment 3.101e+04 1.235e+05 0.251 0.801760
## Store19:Unemployment 5.404e+04 1.332e+05 0.406 0.685026
## Store20:Unemployment 5.590e+04 1.031e+05 0.542 0.587730
## Store21:Unemployment 2.350e+05 1.260e+05 1.865 0.062212 .
## Store22:Unemployment 7.849e+04 1.239e+05 0.634 0.526357
## Store23:Unemployment 1.498e+04 1.537e+05 0.097 0.922334
## Store24:Unemployment 6.490e+04 1.466e+05 0.443 0.657948
## Store25:Unemployment 7.120e+04 9.829e+04 0.724 0.468870
## Store26:Unemployment 5.125e+04 1.983e+05 0.258 0.796116
## Store27:Unemployment -4.964e+04 1.459e+05 -0.340 0.733649
## Store28:Unemployment 1.444e+05 8.361e+04 1.727 0.084187 .
## Store29:Unemployment 1.531e+05 9.957e+04 1.538 0.124214
## Store30:Unemployment -3.001e+04 1.261e+05 -0.238 0.811920
## Store31:Unemployment 2.358e+05 1.261e+05 1.871 0.061444 .
## Store32:Unemployment 2.310e+05 1.359e+05 1.700 0.089188 .
## Store33:Unemployment 1.370e+05 9.654e+04 1.419 0.155859
## Store34:Unemployment 1.023e+05 7.217e+04 1.417 0.156564
## Store35:Unemployment 6.190e+05 1.363e+05 4.541 5.76e-06 ***
## Store36:Unemployment -7.268e+02 1.135e+05 -0.006 0.994889
## Store37:Unemployment 1.399e+04 1.147e+05 0.122 0.902964
## Store38:Unemployment 1.083e+05 8.487e+04 1.276 0.202040
## Store39:Unemployment 3.474e+05 1.111e+05 3.128 0.001772 **
## Store40:Unemployment 9.204e+04 1.735e+05 0.531 0.595716
## Store41:Unemployment 2.915e+05 1.679e+05 1.736 0.082648 .
## Store42:Unemployment 9.006e+04 1.003e+05 0.898 0.369372
## Store43:Unemployment 2.716e+04 7.124e+04 0.381 0.703009
## Store44:Unemployment 6.383e+04 1.115e+05 0.572 0.567157
## Store45:Unemployment 2.190e+05 1.686e+05 1.299 0.194108
## Holiday_Flag1:Temperature 9.779e+02 4.456e+02 2.194 0.028260 *
## Temperature:Fuel_Price 2.306e+03 6.679e+02 3.453 0.000560 ***
## Temperature:CPI -2.201e+02 8.230e+01 -2.674 0.007530 **
## Fuel_Price:CPI -1.284e+04 3.873e+03 -3.315 0.000923 ***
## Fuel_Price:Unemployment -3.150e+04 1.840e+04 -1.712 0.087010 .
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 151000 on 4269 degrees of freedom
## Multiple R-squared: 0.9317, Adjusted R-squared: 0.928
## F-statistic: 253.1 on 230 and 4269 DF, p-value: < 2.2e-16
Interpret 3 predictors
- Holiday_Flag1 148748.6 This means that when there is a holiday,
sales will increase
- Fuel_Price -156989.4 This means that when fuel prices go up, sales
will decrease
- CPI 44619.2 This means that when the CPI goes up, sales will
increase
The R^2 of the model (calculated on the validation data) is
0.9316861