dataStr<-read.csv(paste("Store24.csv"))
summary(dataStr)
## 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.00
mean(dataStr$Sales)
## [1] 1205413
top <- dataStr[order(- dataStr$Sales),]
top[1:5,1:3 ]
## store Sales Profit
## 9 9 2113089 474725
## 30 30 1874873 333607
## 7 7 1809256 476355
## 44 44 1807740 439781
## 74 74 1782957 518998
bottom <- dataStr[order(+ dataStr$Sales),]
bottom[1:5,1:3 ]
## store Sales Profit
## 57 57 699306 122180
## 61 61 716589 177046
## 41 41 744211 147327
## 54 54 811190 159792
## 32 32 828918 149033
Now we draw a plot between the sales and visibility of the store,
library(car)
## Warning: package 'car' was built under R version 3.4.3
scatterplot(x = dataStr$Visibility, y = dataStr$Sales, main = "Relation between the sales and visibility of the store", xlab="Visibility", ylab="Sales",)
This means, sales increase with visibility of the store.