Question
Guideline : Eastern States Bank and Trust monitors its drive-thru service times electronically to ensure that its speed of service is meeting the company's goals.
Guideline : Eastern States Bank and Trust monitors its drive-thru service times electronically to ensure that its speed of service is meeting the company's goals. A sample of 28 drive-thru times was recently taken and is shown below in the table named "Speed of Service".
Speed of Service (time in seconds) | |||
83 | 120 | 145 | 120 |
130 | 79 | 129 | 156 |
90 | 85 | 68 | 93 |
120 | 76 | 73 | 110 |
92 | 146 | 88 | 103 |
116 | 110 | 120 | 71 |
109 | 110 | 105 | 74 |
1. Using Excel, compute the mean, median, and mode for these sample data.
2. Using the values of the mean, median, and mode you calculated above, can you confirm whether the data are symmetrical or skewed? Explain how you came to your answer - you would need to create a "normal distribution curve graph" or "histogram with normal distribution overlay" for this question (feel free to manually draw this curve or use any other app to create the graph). Please provide your answer in the space highlighted.
3.Construct a box and whisker plot for the sample data using excel (this answer needs you to have a box and whisker plot drawn using EXCEL). Does the box and whisker plot support the conclusion you made in question 2 in part b (regarding the symmetry or skewedness of the given data set)? Explain your answer.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started