MGMT

Assignment5MGMT3306.xlsx

Histogram Assignment

Table below shows the inside diameter (in millimeters) of metal sleeves produced in a machine shop for 100 randomly selected parts. Twenty samples, each of size 5, were taken. Simply looking at the data below table provides little insight about the process. Please provide the histogram and your explanation (how the sample distributed?)
Sample	Observations X (Five per Sample)
1	50.05	50.03	50.02	50	49.94
2	49.96	49.99	50.03	50.01	49.98
3	50.01	50.01	50.01	50	49.92
4	49.95	49.97	50.02	50.1	50.02
5	50	50.01	50	50	50.09
6	50.02	50.05	49.97	50.02	50.09
7	50.01	49.99	49.96	49.99	50
8	50.02	50	50.04	50.02	50
9	50.06	49.93	49.99	49.99	49.95
10	49.96	49.93	50.08	49.92	50.03
11	50.01	49.96	49.98	50	50.02
12	50.04	49.94	50	50.03	49.92
13	49.97	49.9	49.98	50.01	49.95
14	49.98	50.01	49.95	49.97	49.94
15	49.97	49.98	50.03	50.08	49.96
16	49.98	50	49.97	49.96	49.97
17	50.03	50.04	50.03	50.01	50.01
18	49.98	49.98	49.99	50.05	50
19	50.07	50	50.02	49.99	49.93
20	49.99	50.06	49.95	49.99	50.02

An insurance company is interested in determining whether life insurance coverage is influenced linearly by disposable income. A randomly chosen sample of size 20 produced the data shown in the table below. Construct a scatterplot with a trend line. What conclusions can you draw?
Disposable Income ($ thousands)	Life Insurance Coverage ($ thousands)
45	60
40	58
65	100
50	50
70	120
75	140
70	100
40	50
50	70
45	60
65	80
60	90
45	50
40	50
55	70
55	60
60	80
75	120
45	50
65	70

In a printing company, data from the previous month show the following types of errors, with the unit cost (in dollars) of rectifying each error. Construct a Pareto Chart and discuss the results. If management has monthly allocation of 18,000, which areas should they tackle? (Hint: what is the total cost)
Error categories	Frequency	Unit Costs
Inadequate Binding	120	100
Paper tension	80	50
Paper Misalignment	100	30
Proofreading	3500	0.5
Typographical	4000	0.2

Consider a process by which coils are manufactured. Samples of size 5 are randomly selected from the process, and the resistance values (in ohms) of the coils are measured. The data values are given in the table below, please conduct the x-bar chart and r chart.
Sample	Observations
1	20	22	21	23	22
2	19	18	22	20	20
3	25	19	20	17	22
4	20	21	22	21	21
5	19	24	23	22	20
6	22	20	18	18	19
7	18	20	19	18	20
8	20	18	23	20	21
9	21	20	24	23	22
10	21	19	20	20	20
11	20	20	23	22	20
12	22	21	20	23	23
13	19	22	19	18	19
14	20	21	22	21	22
15	20	24	24	23	23
16	21	20	24	20	21
17	20	18	18	20	20
18	20	24	22	23	23
19	20	19	23	20	19
20	22	21	21	24	22
21	23	22	22	20	22
22	21	18	18	17	19
23	21	24	24	23	23
24	20	22	21	21	20
25	19	20	21	21	22