Question

Use the data in the table below to calculate Cp, Cpl, Cpu, and Cpk, assuming that the specifications are 3.60 ± 1.30. Do not round intermediate calculations. Round your answers to three decimal places.

	Sample
	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15
Observations	3.50	3.53	3.69	4.17	4.02	3.50	3.22	4.26	4.44	3.72	4.12	3.28	3.91	3.67	3.68
	3.65	3.41	3.32	3.48	3.34	4.32	3.60	3.28	3.69	3.63	3.25	3.16	3.41	3.67	4.00
	2.88	3.16	4.38	3.68	3.15	3.81	3.51	3.06	3.10	3.40	3.05	3.02	4.07	3.34	2.78
	Sample
	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30
Observations	4.18	3.14	2.77	3.70	2.85	3.50	3.86	3.80	4.19	3.88	3.82	4.20	3.91	3.40	4.15
	3.67	3.18	3.70	3.65	3.33	3.54	3.60	4.89	3.78	4.44	3.65	3.41	4.69	4.15	3.57
	3.21	3.17	2.98	3.88	3.28	4.28	3.61	3.74	3.88	3.72	3.88	3.45	3.62	4.03	3.06

Cp:  

Cpl:  

Cpu:  

Cpk:  

Construct the frequency distribution for the data. For calculating the cell width assume 8 cells, the lower limit of 2.30 inches and upper limit of 4.90 inches. If your answer is zero, enter "0". Round your answers for interval boundaries to three decimal places and round your answers for frequencies to the nearest whole number.

Cell	From	To (inclusive)	Frequency
	0
1
2
3
4
5
6
7
8

Choose the correct histogram for the data.

The correct histogram is -Select-histogram Ahistogram Bhistogram Chistogram DItem 31.

A.
B.
C.
D.

Answer 1

Capability ratio and indices are computed using Excel as follows:

EXCEL FORMULA:

Create Frequency table as follows:

Note that FREQUENCY is an Array formula. So, it is entered by pressing SHIFT+CTRL+ENTER

------------------------------

Create Histogram using the data range as shown below:

Correct Histogram is B

------------------------------------

DEAR STUDENT,

IF YOU HAVE ANY QUERY ASK ME IN THE COMMENT BOX,I AM HERE TO HELPS YOU.PLEASE GIVE ME POSITIVE RATINGS

*****************THANK YOU***************