A furniture manufacturer is producing cushions for

A furniture manufacturer is producing cushions for

A furniture manufacturer is producing cushions for

Use Excel to answer
the following questions

1.
A furniture manufacturer is producing cushions
for their premier line of leather sofas. In order to fit in the sofas, the
cushions need to be approximately 24 inches wide. The following 10 cushion
samples were taken over a weeklong period.

Don't use plagiarized sources. Get Your Custom Essay on
A furniture manufacturer is producing cushions for
Just from $10/Page
Order Essay

Sample Number

Inches

1

23.75

24.22

23.85

24.17

2

24.08

24.27

23.51

23.94

3

24.56

24.30

24.10

24.15

4

23.89

23.51

23.57

24.10

5

24.01

23.82

24.00

24.52

6

24.15

23.97

24.08

24.05

7

24.12

23.90

24.15

24.61

8

23.80

23.77

23.95

24.15

9

23.51

24.75

24.51

23.75

10

24.00

25.01

23.05

23.67

a.
Use the two methods introduced to construct a
3-sigma x-bar chart based on the above data.
b.
Use the above data to construct a 3-sigma R
chart.
c.
Suppose the LSL and USL are 23.5 inches and 25
inches. Compute Cpk and determine whether the process meets specification.

2.
Completed forms from a particular department of
an insurance company were sampled on a daily basis as a check against the
quality of performance of that department. To establish a tentative norm for
the department, one sample of 100 units was collected each day for 15 days:

Sample

Sample Size

Number of Forms with Errors

1

100

4

2

100

3

3

100

5

4

100

0

5

100

2

6

100

8

7

100

1

8

100

3

9

100

4

10

100

2

11

100

7

12

100

2

13

100

1

14

100

3

15

100

1

Develop
a p-chart using a 95% confidence level (z-score = 1.96)

 

CLICK TO ORDER A CUSTOM PAPER

We are the best paper writer / paper help in the world

 

 

 

Order your essay today and save 30% with the discount code ESSAYHELP