#region sale, month sale, cumulative region sales, cumulative month sales, and competitive price percentage.
To get access to the patterns of data, 5 aspects could be analyzed based on region sales, month sales, cumulative region sales, cumulative month sales, and competitive price percentage.
To get access to the patterns of winter data, 5 aspects could be analyzed based on region sales, month sales, cumulative region sales, cumulative month sales, and competitive price percentage.
(Dispersion parameter for gaussian family taken to be 1294457)
Null deviance: 2.7017e+11 on 59099 degrees of freedom
Residual deviance: 7.6487e+10 on 59088 degrees of freedom
AIC: 999482
Number of Fisher Scoring iterations: 2
Model strength
AIC value for this model is about 999482. If we compare this result with data without winter months, the AIC is lower which better illustrates the higher strength of results.
Variable Importance
Income:
If the customer with low income, the sale would be increased by 90.73.
If the customer with high income, the sale would be increased by 254.3.
ProgressoPrice:
As one unit increase of Progresso price, the sale would be decreased by 1906.
CompetitorPrice:
As one unit increase of Campbell price, the sale would be increasedby 2178.
As one unit increase of PL price, the sale would be increasedby 1092.
CategorySales:
As one unit increase of category sale, the sale would be increasedby 0.3114.
WinterMonth:
October: As one unit increase, the sale would be increasedby 106.7.
November: As one unit increase, the sale would be decreasedby 156.9.
December: As one unit increase, the sale would be decreasedby 157.2.
January: As one unit increase, the sale would be increasedby 263.3.
February: As one unit increase, the sale would be increasedby 87.62.
Relationship between predictor and dependent variables
Since all the factors are significant due to the analysis:
Relationship: Predictor vs. Sale
0
Search
Predictor
Influence
Value
Predictor
Influence
Value
1
Low Income
increased
90.73
2
High Income
increased
254.3
3
Progresso price
decreased
1906
4
Campbell price
increased
2178
5
PL price
increased
1092
6
category sale
increased
0.3114
7
October
increased
106.7
8
November
decreased
156.9
9
December
decreased
157.2
10
January
increased
263.3
11
February
increased
87.62
There are no rows in this table
Progresso sale would increase with the increase of income level, competitors’ price(Campbell and PL), category sale, October, January, and February sale.
Progresso sale would decrease with the increase of Progresso price, November, and December sale.
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (