Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 1. The owner of an automobile repair shop studied the waiting times for customers who arrive at the shop for an oil change. The
Problem 1. The owner of an automobile repair shop studied the waiting times for customers who arrive at the shop for an oil change. The following data (with waiting times in minutes) were collected over a 1month period. 2,5, 10,12,4,4,5,17, 11,8,9,8,12,21,6,8,7, 13,18, 3 Find the worksheet named \"RepairShop\" in the Excel workbook named "Wkl-Excel". Using classes (or bins) of 04, 59, and so on, construct the following distributions and then answer the questions that follow: a.The frequency distribution. b.The relative frequency distribution. c.The cumulative frequency distribution. d.The cumulative relative frequency distribution. Bins are arranged in ascending order. What is the ggper-bound {inclusive) of the third highest bin in your frequency distribution? (select one of: 10, 12, 14, 15, 16, 17, 18) 1D 12 14 15 16 1? 000000 18 Starting from the smallest or lowest bin, what is the fr_equenc'g of the third highest bin in your frequency distribution? (write your answer as an integer} Question 3 0.2 pts Starting from the smallest or lowest bin, what is the relative frequency: of the third highest bin in your relative frequency distribution? Select one of: O 0.2 O 0.25 O 0.3 O 0.35 O 0.4 O 0.5 0 None of these Question 4 0.2 pts True or False. The Relative Frequency and Cumulative Relative Frequency both must sum {add-uputo) 1.0. 0 True 0 False Question 5 0.2 pts Starting from the smallest or lowest bin, what is the cumulative frequency of the third highest bin? (write your answer as an integer) Apply the formula for computing approximate bin size from the text and lecture. Assuming that we want ve bins and that we round-up, what is the computed bin size? [select one of: 3, 4. 5, 6} 03 O4 05 0:, Question 7 0.2 pts What percentage of customers needing an oil change wait 10 minutes or more? (pick the closest answer without going over) 0 30% O 35% 0 40% o 50% 0 62% o ?0% O 100%
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