store24
Subarna N
February 12, 2018
Analysis of the Case Store24 (A): Managing Employee Retention
TASK 4c
## Parsed with column specification:
## cols(
## store = col_integer(),
## Sales = col_integer(),
## Profit = col_integer(),
## MTenure = col_double(),
## CTenure = col_double(),
## Pop = col_integer(),
## Comp = col_double(),
## Visibility = col_integer(),
## PedCount = col_integer(),
## Res = col_integer(),
## Hours24 = col_integer(),
## CrewSkill = col_double(),
## MgrSkill = col_double(),
## ServQual = col_double()
## )## store Sales Profit MTenure
## Min. : 1.0 Min. : 699306 Min. :122180 Min. : 0.00
## 1st Qu.:19.5 1st Qu.: 984579 1st Qu.:211004 1st Qu.: 6.67
## Median :38.0 Median :1127332 Median :265014 Median : 24.12
## Mean :38.0 Mean :1205413 Mean :276314 Mean : 45.30
## 3rd Qu.:56.5 3rd Qu.:1362388 3rd Qu.:331314 3rd Qu.: 50.92
## Max. :75.0 Max. :2113089 Max. :518998 Max. :277.99
## CTenure Pop Comp Visibility
## Min. : 0.8871 Min. : 1046 Min. : 1.651 Min. :2.00
## 1st Qu.: 4.3943 1st Qu.: 5616 1st Qu.: 3.151 1st Qu.:3.00
## Median : 7.2115 Median : 8896 Median : 3.629 Median :3.00
## Mean : 13.9315 Mean : 9826 Mean : 3.788 Mean :3.08
## 3rd Qu.: 17.2156 3rd Qu.:14104 3rd Qu.: 4.230 3rd Qu.:4.00
## Max. :114.1519 Max. :26519 Max. :11.128 Max. :5.00
## PedCount Res Hours24 CrewSkill
## Min. :1.00 Min. :0.00 Min. :0.00 Min. :2.060
## 1st Qu.:2.00 1st Qu.:1.00 1st Qu.:1.00 1st Qu.:3.225
## Median :3.00 Median :1.00 Median :1.00 Median :3.500
## Mean :2.96 Mean :0.96 Mean :0.84 Mean :3.457
## 3rd Qu.:4.00 3rd Qu.:1.00 3rd Qu.:1.00 3rd Qu.:3.655
## Max. :5.00 Max. :1.00 Max. :1.00 Max. :4.640
## MgrSkill ServQual
## Min. :2.957 Min. : 57.90
## 1st Qu.:3.344 1st Qu.: 78.95
## Median :3.589 Median : 89.47
## Mean :3.638 Mean : 87.15
## 3rd Qu.:3.925 3rd Qu.: 99.90
## Max. :4.622 Max. :100.00TASK 4d
## [1] 276313.6## [1] 89404.08## [1] 45.29644## [1] 57.67155## [1] 13.9315## [1] 17.69752TASK 4f - Sorting and Subsetting data
## # A tibble: 10 x 6
## store Sales Profit MTenure CTenure Pop
## <int> <int> <int> <dbl> <dbl> <int>
## 1 57 699306 122180 24.3 2.96 3642
## 2 66 879581 146058 115 3.88 1046
## 3 41 744211 147327 14.9 11.9 9701
## 4 55 925744 147672 6.67 18.4 10532
## 5 32 828918 149033 36.1 6.64 9697
## 6 13 857843 152513 0.657 1.58 14186
## 7 54 811190 159792 6.67 3.88 3747
## 8 52 1073008 169201 24.1 3.42 14859
## 9 61 716589 177046 21.8 13.3 3014
## 10 37 1202917 187765 23.2 1.35 8870## # A tibble: 10 x 6
## store Sales Profit MTenure CTenure Pop
## <int> <int> <int> <dbl> <dbl> <int>
## 1 74 1782957 518998 171 29.5 10913
## 2 7 1809256 476355 62.5 7.33 17754
## 3 9 2113089 474725 109 6.06 26519
## 4 6 1703140 469050 150 11.4 16926
## 5 44 1807740 439781 182 114 20624
## 6 2 1619874 424007 86.2 6.64 8630
## 7 45 1602362 410149 47.6 9.17 17808
## 8 18 1704826 394039 240 33.8 3807
## 9 11 1583446 389886 44.8 2.04 21550
## 10 47 1665657 387853 12.8 6.64 23623TASK 4g - Scatter Plots
TASK 4i - Correlation Matrix
## store Sales Profit MTenure CTenure Pop Comp Visibility
## store 1.00 -0.23 -0.20 -0.06 0.02 -0.29 0.03 -0.03
## Sales -0.23 1.00 0.92 0.45 0.25 0.40 -0.24 0.13
## Profit -0.20 0.92 1.00 0.44 0.26 0.43 -0.33 0.14
## MTenure -0.06 0.45 0.44 1.00 0.24 -0.06 0.18 0.16
## CTenure 0.02 0.25 0.26 0.24 1.00 0.00 -0.07 0.07
## Pop -0.29 0.40 0.43 -0.06 0.00 1.00 -0.27 -0.05
## Comp 0.03 -0.24 -0.33 0.18 -0.07 -0.27 1.00 0.03
## Visibility -0.03 0.13 0.14 0.16 0.07 -0.05 0.03 1.00
## PedCount -0.22 0.42 0.45 0.06 -0.08 0.61 -0.15 -0.14
## Res -0.03 -0.17 -0.16 -0.06 -0.34 -0.24 0.22 0.02
## Hours24 0.03 0.06 -0.03 -0.17 0.07 -0.22 0.13 0.05
## CrewSkill 0.05 0.16 0.16 0.10 0.26 0.28 -0.04 -0.20
## MgrSkill -0.07 0.31 0.32 0.23 0.12 0.08 0.22 0.07
## ServQual -0.32 0.39 0.36 0.18 0.08 0.12 0.02 0.21
## PedCount Res Hours24 CrewSkill MgrSkill ServQual
## store -0.22 -0.03 0.03 0.05 -0.07 -0.32
## Sales 0.42 -0.17 0.06 0.16 0.31 0.39
## Profit 0.45 -0.16 -0.03 0.16 0.32 0.36
## MTenure 0.06 -0.06 -0.17 0.10 0.23 0.18
## CTenure -0.08 -0.34 0.07 0.26 0.12 0.08
## Pop 0.61 -0.24 -0.22 0.28 0.08 0.12
## Comp -0.15 0.22 0.13 -0.04 0.22 0.02
## Visibility -0.14 0.02 0.05 -0.20 0.07 0.21
## PedCount 1.00 -0.28 -0.28 0.21 0.09 -0.01
## Res -0.28 1.00 -0.09 -0.15 -0.03 0.09
## Hours24 -0.28 -0.09 1.00 0.11 -0.04 0.06
## CrewSkill 0.21 -0.15 0.11 1.00 -0.02 -0.03
## MgrSkill 0.09 -0.03 -0.04 -0.02 1.00 0.36
## ServQual -0.01 0.09 0.06 -0.03 0.36 1.00TASK 4j - Correlations
## [1] 0.44## [1] 0.26TASK 4l - Pearson’s Correlation Tests
##
## Pearson's product-moment correlation
##
## data: Store$Profit and Store$MTenure
## t = 4.1731, df = 73, p-value = 8.193e-05
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
## 0.2353497 0.6055175
## sample estimates:
## cor
## 0.4388692p-value = 8e-05 Which is lesser than 0.05 which means there is strong correlation between profit and M tenure
##
## Pearson's product-moment correlation
##
## data: Store$Profit and Store$CTenure
## t = 2.2786, df = 73, p-value = 0.02562
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
## 0.03262507 0.45786339
## sample estimates:
## cor
## 0.2576789p-value = 0.03,IS LESSER THAN 0.05 Which means there is a strong correlation between profit and ctenure
TASK 3m - Regression Analysis
##
## Call:
## lm(formula = Profit ~ MTenure + CTenure + Comp + Pop + PedCount +
## Res + Hours24 + Visibility, data = Store)
##
## Residuals:
## Min 1Q Median 3Q Max
## -105789 -35946 -7069 33780 112390
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 7610.041 66821.994 0.114 0.909674
## MTenure 760.993 127.086 5.988 9.72e-08 ***
## CTenure 944.978 421.687 2.241 0.028400 *
## Comp -25286.887 5491.937 -4.604 1.94e-05 ***
## Pop 3.667 1.466 2.501 0.014890 *
## PedCount 34087.359 9073.196 3.757 0.000366 ***
## Res 91584.675 39231.283 2.334 0.022623 *
## Hours24 63233.307 19641.114 3.219 0.001994 **
## Visibility 12625.447 9087.620 1.389 0.169411
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 56970 on 66 degrees of freedom
## Multiple R-squared: 0.6379, Adjusted R-squared: 0.594
## F-statistic: 14.53 on 8 and 66 DF, p-value: 5.382e-12explanatory variable(s) whose beta-coefficients are not statistically significant (p > 0.05).
1.Visibility explanatory variable(s) whose beta-coefficients are statistically significant (p < 0.05). 1.MTenure, 2.CTenure, 3.Comp, 4.Pop, 5.PedCount, 6.Res, 7.Hours24
expected change in the Profit at a store, if the Manager’s tenure i.e. number of months of experience with Store24, increases by one month =760.99 expected change in the Profit at a store, if the Crew’s tenure i.e. number of months of experience with Store24, increases by one month=944.98
TASK 4p Executive Summary
Visiblity,the independent variable is highly significant to the dependent variable profit. The regression analysis shows that the p-value: 5.38e-12(significant),of Ftest is less than 0.05 which means the developed regression model is good fit. The multiple R square value is:0.638,which means that 63.8% of variations in the dependent variable can be explained by the independent variable.The value increases when we add independent variable to it.Adjusted R square value is 0.594.It means 59.4% variation in the dependent variable can be explained by the independent variable it become precise when we add independent variable to it.