In: Statistics and Probability
What estimates, with reasonable assurance, can PLE give customers for response times to customer service calls?
Solution:-
Given
What estimates, with reasonable assurance, can PLE give customers for response times to customer service calls?
The Excel file Performance Lawn Equipment can be found at the website.
www.pearsonhighered.com/evans
Locate Books by James Evans, Business Analytics 1/e.
Click the Online Data Files link.
Open Performance Lawn Equipment .xlsx
Use the AVERAGE and STDEV.S functions in Excel to compute the mean and standard deviation of the response times in the Response Time worksheet as shown below.
The result is shown below
Use the Population Mean Sigma known worksheet in Confidence Intervals.xlxs to find the 95% confidence interval of response times as shown below.
Confidence Interval for Population Mean, Standard Deviation known
Alpha | 0.05 | |
Standard deviation | 1.64 | |
Sample size | 400 | |
Sample average | 3.47 | |
Confidence Interval | 95% | |
Error | 0.160717047 | |
Lower | 3.309282953 | |
Upper | 3.63717047 |
We are 95% confident that the true population mean response times to customer service calls in between 3.31 and 3.63
Thanks for supporting...
Please give positive rating...