Question 1. Use the data file RepairShop.xlsx to answer this question. The owner

Question

Question 1. Use the data file RepairShop.xlsx to answer this question.
The owner of an automobile repair shop studied the waiting times for customers
who arrive at the shop for an oil change. The data with waiting times in minutes
were collected over a 1-month period.
Using classes of 0–4, 5–9, and so on:
a) Show the frequency distribution (WITHOUT using excel).
b) Show the relative frequency distribution (WITHOUT using excel).
c) Repeat part a and b in excel. Submit the final excel file as “Q1.xlsx”
d) Show the proportion of customers needing an oil change who wait 9 minutes
or less (without using excel)

WAITING TIME

2   5   10   12

4   4   5   17
11   8   9   8
12   21   6   8
7   13   18   3

Explanation / Answer

Ans:

a,b)

d)P(X<=9)=0.2+0.4=0.6

There are 60%  of customers needing an oil change who wait 9 minutes
or less .

b)for frequency distribution using Excel,use =FREQUENCY(data array,bin array)

for Data array and bin array,select as bleow:

class frequency Relative frequency 0-4 4 0.2 5-9 8 0.4 10-14 5 0.25 15-19 2 0.1 20-24 1 0.05 Total 20 1

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.