FREQUENCY DISTRIBUTION TABLE EXERCISE

A manufacturer of industrial wheels is losing many profitable orders because of the long time it takes the firm's marketing, engineering, and accounting departments to develop price quotes for potential customers. To remedy this problem the firm's management would like to set guidelines for the length of time each department should spend developing price quotes. To help develop these guidelines, fifty requests for price quotes were randomly selected from the set of all price quotes made last year; the processing time was determined for each price quote for each department. These times are displayed in the table below. Notice that the price quotes are also classified by whether they were "lost" (i.e., whether or not the customer placed an order after receiving the price quote).

Price Quote Processing Times (in days)

REQUEST NUMBER	MKTG	ENG'G	ACCTG	LOST?	REQUEST NUMBER	MKTG	ENG'G	ACCTG	LOST?
1	7.0	6.2	0.1	No	26	0.6	2.2	0.5	No
2	0.4	5.2	0.1	No	27	6.0	1.8	0.2	No
3	2.4	4.6	0.6	No	28	5.8	0.6	0.5	No
4	6.2	13.0	0.8	Yes	29	7.8	7.2	2.2	Yes
5	4.7	0.9	0.5	No	30	3.2	6.9	0.1	No
6	1.3	0.4	0.1	No	31	11.0	1.7	3.3	No
7	7.3	6.1	0.1	No	32	6.2	1.3	2.0	No
8	5.6	3.6	3.8	No	33	6.9	6.0	10.5	Yes
9	5.5	9.6	0.5	No	34	5.4	0.4	8.4	No
10	5.3	4.8	0.8	No	35	6.0	7.9	0.4	No
11	6.0	2.6	0.1	No	36	4.0	1.8	18.2	Yes
12	2.6	11.3	1.0	No	37	4.5	1.3	0.3	No
13	2.0	0.6	0.8	No	38	2.2	4.8	0.4	No
14	0.4	12.2	1.0	No	39	3.5	7.2	7.0	Yes
15	8.7	2.2	3.7	No	40	0.1	0.9	14.4	No
16	4.7	9.6	0.1	No	41	2.9	7.7	5.8	No
17	6.9	12.3	0.2	Yes	42	5.4	3.8	0.3	No
18	0.2	4.2	0.3	No	43	6.7	1.3	0.1	No
19	5.5	3.5	0.4	No	44	2.0	6.3	9.9	Yes
20	2.9	5.3	22.0	No	45	0.1	12.0	3.2	No
21	5.9	7.3	1.7	No	46	6.4	1.3	6.2	No
22	6.2	4.4	0.1	No	47	4.0	2.4	13.5	Yes
23	4.1	2.1	30.0	Yes	48	10.0	5.3	0.1	No
24	5.8	0.6	0.1	No	49	8.0	14.4	1.9	Yes
25	5.0	3.1	2.3	No	50	7.0	10.0	2.0	No

1. Construct the frequency distribution table for the following data sets:
2. The processing time of the marketing department
3. The processing time of the engineering department
4. The processing time of the accounting department
5. The total processing time for the individual price quotes
6. Draw the frequency histogram for 1(a), frequency polygon for 1(b) and an ogive for 1(d).
7. Using your results from question no. 1, develop "maximum processing time" guidelines for each department that, if followed, will help the firm reduce the number of lost orders.
8. For the frequency distribution table of 1(d), compute for the following: mean, median, mode, standard deviation, variance, range, mean absolute deviation, coefficient of variation and skewness coefficient of the grouped data.
9. Construct the Box and Whisker plot for the total processing time. Interpret your results.