An Electronic store is being questioned by the Head Manager. The Head boss is concerned about this location as it does not have a high enough average of customers per hour. They wouldn’t be concerned if the average is greater than 15 customers per hour. In Excel, use the given data to answer the questions below and use the α=0.05 level to show that the Head boss does not need to be concerned. Test the claim to an alpha=0.05 level, that the shop sees on average more than 15 customers per hour.

Time
12
14
15
13
14
17
18
13
17
22
16
14
24
14
18
15
11
14
17
Questions:

What is the Null and alternative hypothesis?
Point estimate is?
P-value?
Decision?
A written statement on whether the Head boss has any reason to be concerned or not.

Data analysis gives:

Time

Mean 15.68421
Standard Error 0.745562
Median 15
Mode 14
Standard Deviation 3.249831
Sample Variance 10.5614
Kurtosis 1.471114
Skewness 1.162671
Range 13
Minimum 11
Maximum 24
Sum 298
Count 19
Confidence Level(95.0%) 1.566369