Linear OLS Model
##
## Call:
## lm(formula = Sales ~ OutletType + OutletClass + Category + Month +
## Pieces, data = dabur.dt)
##
## Residuals:
## Min 1Q Median 3Q Max
## -5691.4 -873.2 36.8 390.5 14412.7
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 141.0378 47.8275 2.949 0.00319 **
## OutletTypeCONF -46.5498 31.1205 -1.496 0.13471
## OutletTypeED -48.8764 31.2144 -1.566 0.11739
## OutletTypeGM -55.4020 30.0833 -1.842 0.06554 .
## OutletTypeGROC 12.2387 30.2383 0.405 0.68567
## OutletTypePP 32.0761 34.5851 0.927 0.35369
## OutletClassB -153.0591 35.1003 -4.361 1.30e-05 ***
## OutletClassC -290.8057 34.7180 -8.376 < 2e-16 ***
## OutletClassD -357.8484 35.1029 -10.194 < 2e-16 ***
## CategoryCulinary -180.5243 22.7942 -7.920 2.42e-15 ***
## CategoryReal Drinks -1428.5312 32.1811 -44.390 < 2e-16 ***
## CategoryReal Juices & Nectars 354.9958 16.8741 21.038 < 2e-16 ***
## MonthJanuary -38.7241 22.9904 -1.684 0.09212 .
## MonthFebruary 22.6377 22.3380 1.013 0.31086
## MonthMarch 176.5913 21.9476 8.046 8.69e-16 ***
## MonthApril 148.2691 22.0356 6.729 1.73e-11 ***
## Pieces 39.5609 0.1674 236.388 < 2e-16 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1597 on 68088 degrees of freedom
## Multiple R-squared: 0.5109, Adjusted R-squared: 0.5108
## F-statistic: 4445 on 16 and 68088 DF, p-value: < 2.2e-16
Linear OLS Model With Interaction
##
## Call:
## lm(formula = Sales ~ OutletType + OutletClass + Category + Month +
## Pieces + Pieces * OutletType + Pieces * OutletClass + Pieces *
## Category + Pieces * Month, data = dabur.dt)
##
## Residuals:
## Min 1Q Median 3Q Max
## -7926.4 -673.5 -6.1 362.6 14975.5
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 68.2640 63.9608 1.067 0.285850
## OutletTypeCONF 132.7330 41.2759 3.216 0.001302
## OutletTypeED 35.7022 41.5203 0.860 0.389862
## OutletTypeGM 14.7250 39.7773 0.370 0.711245
## OutletTypeGROC 109.7169 39.8807 2.751 0.005941
## OutletTypePP 269.9907 46.2402 5.839 5.28e-09
## OutletClassB 87.9943 48.1995 1.826 0.067911
## OutletClassC 43.1547 47.5331 0.908 0.363941
## OutletClassD -45.7995 47.9271 -0.956 0.339274
## CategoryCulinary 3.6793 28.6360 0.128 0.897764
## CategoryReal Drinks -105.0996 71.4810 -1.470 0.141481
## CategoryReal Juices & Nectars 51.4738 20.0840 2.563 0.010382
## MonthJanuary 109.2458 30.7083 3.558 0.000375
## MonthFebruary -56.6905 29.8673 -1.898 0.057690
## MonthMarch -128.4588 29.1150 -4.412 1.03e-05
## MonthApril -136.7723 29.2439 -4.677 2.92e-06
## Pieces 38.2653 1.3336 28.694 < 2e-16
## OutletTypeCONF:Pieces -6.1922 0.9932 -6.234 4.56e-10
## OutletTypeED:Pieces -3.6164 0.9950 -3.635 0.000279
## OutletTypeGM:Pieces -3.3031 0.9754 -3.386 0.000709
## OutletTypeGROC:Pieces -4.1944 0.9748 -4.303 1.69e-05
## OutletTypePP:Pieces -7.7187 1.0520 -7.337 2.21e-13
## OutletClassB:Pieces -6.1137 0.7568 -8.078 6.67e-16
## OutletClassC:Pieces -9.0645 0.7598 -11.930 < 2e-16
## OutletClassD:Pieces -8.3367 0.7741 -10.770 < 2e-16
## CategoryCulinary:Pieces -8.6711 0.8657 -10.016 < 2e-16
## CategoryReal Drinks:Pieces -22.0989 1.4300 -15.453 < 2e-16
## CategoryReal Juices & Nectars:Pieces 11.8492 0.5507 21.517 < 2e-16
## MonthJanuary:Pieces -4.3976 0.6312 -6.968 3.25e-12
## MonthFebruary:Pieces 2.0406 0.5849 3.489 0.000486
## MonthMarch:Pieces 8.1230 0.5628 14.433 < 2e-16
## MonthApril:Pieces 7.9935 0.5697 14.032 < 2e-16
##
## (Intercept)
## OutletTypeCONF **
## OutletTypeED
## OutletTypeGM
## OutletTypeGROC **
## OutletTypePP ***
## OutletClassB .
## OutletClassC
## OutletClassD
## CategoryCulinary
## CategoryReal Drinks
## CategoryReal Juices & Nectars *
## MonthJanuary ***
## MonthFebruary .
## MonthMarch ***
## MonthApril ***
## Pieces ***
## OutletTypeCONF:Pieces ***
## OutletTypeED:Pieces ***
## OutletTypeGM:Pieces ***
## OutletTypeGROC:Pieces ***
## OutletTypePP:Pieces ***
## OutletClassB:Pieces ***
## OutletClassC:Pieces ***
## OutletClassD:Pieces ***
## CategoryCulinary:Pieces ***
## CategoryReal Drinks:Pieces ***
## CategoryReal Juices & Nectars:Pieces ***
## MonthJanuary:Pieces ***
## MonthFebruary:Pieces ***
## MonthMarch:Pieces ***
## MonthApril:Pieces ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1565 on 68073 degrees of freedom
## Multiple R-squared: 0.5307, Adjusted R-squared: 0.5304
## F-statistic: 2483 on 31 and 68073 DF, p-value: < 2.2e-16
# interaction between AdvanceBookingDays and Airline
library(interactions)
interact_plot(OLSModelInt, pred = "Pieces", modx = "Category",
# main.title = "",
x.label = "Pieces", y.label = "Sales",
colors = c("black", "black", "black", "black"),
interval = FALSE)
# interaction between AdvanceBookingDays and Airline
library(interactions)
interact_plot(OLSModelInt, pred = "Pieces", modx = "Month",
# main.title = "",
x.label = "Pieces", y.label = "Sales",
colors = c("black", "black", "black", "black", "black"),
interval = FALSE)
# interaction between AdvanceBookingDays and Airline
library(interactions)
interact_plot(OLSModelInt, pred = "Pieces", modx = "OutletType",
# main.title = "",
x.label = "Pieces", y.label = "Sales",
colors = c("black", "black", "black", "black", "black", "black"),
interval = FALSE)
# interaction between AdvanceBookingDays and Airline
library(interactions)
interact_plot(OLSModelInt, pred = "Pieces", modx = "OutletClass",
# main.title = "",
x.label = "Pieces", y.label = "Sales",
colors = c("black", "black", "black", "black"),
interval = FALSE)
