QTM ASSIGNMENT-2
QTM ASSIGNMENT-2
CENTRAL PARKING SERVICES CASE
CENTRAL PARKING SERVICES CASE
ANALYSIS
ANALYSIS
SUBMITTED BY
SUBMITTED BY
NAME -Akash Malik
NAME -Akash Malik
ROLL NUMBER-170102018
ROLL NUMBER-170102018
Q1. Explore the data for weekday and weekend. What inference can you make based on descriptive Q1. Explore the data for weekday and weekend. What inference can you make based on descriptive statistics?
statistics? I.
I. Direct comparison of weekday and weekend dataDirect comparison of weekday and weekend data
Statistic Statistic Std. Std. Error Error Weekday
Weekday Mean Mean 135.9832 135.9832 1.186981.18698 95% Confidence
95% Confidence Interval for Mean Interval for Mean
Lower Lower Bound Bound 133.6562133.6562 Upper Upper Bound Bound 138.3102138.3102 5%
5% Trimmed Trimmed Mean Mean 129.7681129.7681
Median 122.0000 Median 122.0000 Variance 7037.528 Variance 7037.528 Std. Std. Deviation Deviation 83.8899883.88998 Minimum 2.00 Minimum 2.00 Maximum 722.00 Maximum 722.00 Range 720.00 Range 720.00 Interquartile
Interquartile Range Range 103.00103.00 Skewness
Skewness 1.539 1.539 .035.035 Kurtosis
Kurtosis 4.908 4.908 .069.069 Weekend
Weekend Mean Mean 153.7624 153.7624 1.241291.24129 95% Confidence
95% Confidence Interval for Mean Interval for Mean
Lower Lower Bound Bound 151.3289151.3289 Upper Upper Bound Bound 156.1958156.1958 5%
5% Trimmed Trimmed Mean Mean 147.6510147.6510
Median 141.0000 Median 141.0000 Variance 7696.301 Variance 7696.301 Std. Std. Deviation Deviation 87.7285687.72856 Minimum 1.00 Minimum 1.00 Maximum 713.00 Maximum 713.00 Range 712.00 Range 712.00 Interquartile
Interquartile Range Range 109.00109.00 Skewness
Skewness 1.350 1.350 .035.035 Kurtosis
Kurtosis 3.802 3.802 .069.069 As evident from the descriptive stati
As evident from the descriptive statistics in the table, CPS parking lots experience stics in the table, CPS parking lots experience higher lengths of stayhigher lengths of stay during the weekends as compared to the weekdays.
II.
II. Pass holder data.Pass holder data.
Statistic Statistic Std. Std. Error Error Passholder Mean Passholder Mean 298.7600 298.7600 32.814332.8143 4 4 95% Confidence 95% Confidence Interval for Mean Interval for Mean
Lower Lower Bound Bound 232.8171232.8171 Upper Upper Bound Bound 364.7029364.7029 5% Trimmed Mean 5% Trimmed Mean 293.3111293.3111 Median Median 258.5000258.5000 Variance 53839.04 Variance 53839.04 3 3 Std. Std. Deviation Deviation 232.0324232.0324 2 2 Minimum Minimum 1.001.00 Maximum Maximum 712.00712.00 Range Range 711.00711.00 Interquartile Range Interquartile Range 439.25439.25 Skewness Skewness .181 .181 .337.337 Kurtosis Kurtosis -1.577 -1.577 .662.662 The above table represents the data for the time difference of the pass holders during weekends The above table represents the data for the time difference of the pass holders during weekends It is clearl
It is clearly evident that the time difference of the y evident that the time difference of the pass holder is much higher than the customers that buy thepass holder is much higher than the customers that buy the tickets.
tickets.
Mean time difference for pass holders: 298.76 Mean time difference for pass holders: 298.76 Mean time difference for ticket buyers: 153.76 Mean time difference for ticket buyers: 153.76
III.
III. Non Passholder data. Non Passholder data.
Statistic Statistic Std. Std. Error Error `NoPa `NoPa ss ss Mean 140.702 Mean 140.702 7 7 .97613.97613 95% Confidence 95% Confidence Interval for Mean Interval for Mean
Lower Lower Bound Bound 138.789 138.789 0 0 Upper Upper Bound Bound 142.616 142.616 3 3 5%
5% Trimmed Trimmed Mean Mean 139.446139.446 3 3 Median 136.000 Median 136.000 0 0 Variance 4428.71 Variance 4428.71 2 2 Std. Std. Deviation Deviation 66.548566.5485 7 7 Minimum Minimum 1.001.00 Maximum Maximum 300.00300.00 Range Range 299.00299.00 Interquartile Range Interquartile Range 101.00101.00 Skewness Skewness .248 .248 .036.036 Kurtosis Kurtosis -.697 -.697 .072.072 The above table shows the data of people entering the
The above table shows the data of people entering the parking lots without a pass on the weekend. The meanparking lots without a pass on the weekend. The mean of this data is very close to the mean of the weekday data. Hence, we can infer that the pass holders are
of this data is very close to the mean of the weekday data. Hence, we can infer that the pass holders are largely responsible for pushing the mean time difference of the weekend data higher.
largely responsible for pushing the mean time difference of the weekend data higher.
Mean time difference for non-pass holders: 140.7 minutes Mean time difference for non-pass holders: 140.7 minutes Mean time difference for ticket
Q2. Test whether the
Q2. Test whether the random variable "Time Difference", for weekday and weekend follows normalrandom variable "Time Difference", for weekday and weekend follows normal distribution.
distribution. Answer: Answer:
The figures show that the weekday and weekend distribution data is not normally distributed and both The figures show that the weekday and weekend distribution data is not normally distributed and both ofof them are right skewed.
Q3. CPS charges for weekends are more than weekdays. One of the reasons for higher parking fee Q3. CPS charges for weekends are more than weekdays. One of the reasons for higher parking fee during weekends is that the customers tend to stay for longer duration resulting in non-availability of during weekends is that the customers tend to stay for longer duration resulting in non-availability of parking lots. Is there an evidence to support that the customers stay for longer period during
parking lots. Is there an evidence to support that the customers stay for longer period during weekends compared to weekdays?
weekends compared to weekdays? Answer Answer:: One-Sample Test One-Sample Test Test Value = 145 Test Value = 145 t df t df Sig. Sig. (2-tailed) tailed) Mean Mean Difference Difference 95% Confidence Interval of 95% Confidence Interval of the Difference the Difference Lower Upper Lower Upper TD_Weekday TD_Weekday -7.602 -7.602 4999 4999 .000 .000 -9.018 -9.018 -11.34 -11.34 -6.69-6.69 Sample mean for weekday: 135.9
Sample mean for weekday: 135.9 Sample mean for weekend: 153.7 Sample mean for weekend: 153.7
The above SPSS output shows the output of the one sample t test of for the weekday data against the test The above SPSS output shows the output of the one sample t test of for the weekday data against the test value of 145.
value of 145.
We can see that the significance level is 0. We can see that the significance level is 0.
Since sample mean is less than the value of 145, this along with the significance of 0 are evident enough that Since sample mean is less than the value of 145, this along with the significance of 0 are evident enough that the weekday parking time difference is lesser than 145, hence lesser than the weekend mean of 153.
the weekday parking time difference is lesser than 145, hence lesser than the weekend mean of 153.
Q4. If we divide the day into three time periods viz. 10 am - 2 pm as
Q4. If we divide the day into three time periods viz. 10 am - 2 pm as Morning, 2 pm - 6 pm asMorning, 2 pm - 6 pm as Afternoon and 6 pm - 10 pm as Evening, then determine if the average length of stay really varies Afternoon and 6 pm - 10 pm as Evening, then determine if the average length of stay really varies between these three time periods.
between these three time periods. Answer: Answer: i. i. WeekdaysWeekdays Group Group Time
Time group group Time Time differencedifference mean mean Group 1 Group 1 10:00:00 to 10:00:00 to 14:00:00 14:00:00 147 147 minutesminutes Group 2 Group 2 14:00:00 to 14:00:00 to 18:00:00 18:00:00 135 135 minutesminutes Group
Group 3 3 18:00:00 18:00:00 onwards onwards 128 128 minutesminutes
As can be seen from the data
As can be seen from the data above, the vehicles coming in the morning tend to park their vehicles forabove, the vehicles coming in the morning tend to park their vehicles for longer periods. And this average duration reduces through the day.
ii.
ii. WeekendWeekend
Group Group
Time
Time group group Time Time differencedifference mean mean Group 1 Group 1 10:00:00 to 10:00:00 to 14:00:00 14:00:00 147 147 minutesminutes Group 2 Group 2 14:00:00 to 14:00:00 to 18:00:00 18:00:00 141 141 minutesminutes Group
Group 3 3 18:00:00 18:00:00 onwards onwards 135 135 minutesminutes
The mean time for the vehicles staying in the parking spot between the 10AM to 2PM time period is the The mean time for the vehicles staying in the parking spot between the 10AM to 2PM time period is the same for weekdays and weekends.
