Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Applications For The Management, Life And Social Sciences

Authors: Ronald J. Harshbarger, James J. Reynolds

12th Edition

978-1337625340

More Books

Students also viewed these Mathematics questions