Use the data file RepairShop.xlsx to answer this question. The owner of an autom

Question

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

a) refer coloum no-3

b)refer coloum no-4

c) put coloum 1,2,3 & 4 in excel sheet.

d) from coloum 5 number of people wait 9 minutes or less is 7 & it proportion to total peoples waiting are

7/183 =0.0382

sl.no watinng time range in minutes frequency relative frequency cumulative frequency 1 0-4 2 0.0109 2 2 5-9 5 0.0273 7 3 10-14 10 0.0546 17 4 15-19 12 0.0655 29 5 20-24 4 0.0218 33 6 25-29 4 0.0218 37 7 30-34 5 0.0273 42 8 35-39 17 0.0928 59 9 40-44 11 0.0601 70 10 45-49 8 0.0437 78 11 50-54 9 0.0491 87 12 55-59 8 0.0437 95 13 60-64 12 0.0655 107 14 65-69 21 0.115 128 15 70-74 6 0.0327 134 16 75-79 8 0.0437 142 17 80-84 7 0.0382 149 18 85-89 13 0.710 162 19 90-94 18 0.0983 180 20 95-99 3 0.0163 183 totai=183

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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