(d) If the specifications are at 16.2 ± 0.5, what conclusions would you draw about process capability? (e) What fraction of containers produced by this process is likely to be below the lower specifi- cation limit of 15.7 oz?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.1: Measures Of Center
Problem 9PPS
icon
Related questions
Question

solve the following problem in excel, show in images (and formulas)

Exercise d) and e) only

 

TABLE 6E.7
Data for Exercise 6.12
Sample
Number x1
X4
15.8 16.3 16.2
16.1
16.6
2
16.3 15.9
15.9
16.2
16.4
3
16.1 16.2
16.5
16.4
16.3
4
16.3 16.2
15.9
16.4
16.2
5
16.1 16.1
16.4
16.5
16.0
6
16.1 15.8
16.7
16.6
16.4
7
16.1 16.3
16.5
16.1
16.5
8
16.2 16.1
16.2
16.1
16.3
9.
16.3 16.2
16.4
16.3
16.5
10
16.6 16.3
16.4
16.1
16.5
11
16.2 16.4
15.9
16.3
16.4
12
15.9 16.6
16.7
16.2
16.5
13
16.4 16.1
16.6
16.4
16.1
14
16.5 16.3
16.2
16.3
16.4
15
16.4 16.1 16.3
16.2
16.2
16
16.0 16.2
16.3
16.3
16.2
17
16.4 16.2
16.4
16.3
16.2
18
16.0 16.2
16.4
16.5
16.1
19
16.4 16.0
16.3
16.4
16.4
20
16.4 16.4
16.5
16.0
15.8
Transcribed Image Text:TABLE 6E.7 Data for Exercise 6.12 Sample Number x1 X4 15.8 16.3 16.2 16.1 16.6 2 16.3 15.9 15.9 16.2 16.4 3 16.1 16.2 16.5 16.4 16.3 4 16.3 16.2 15.9 16.4 16.2 5 16.1 16.1 16.4 16.5 16.0 6 16.1 15.8 16.7 16.6 16.4 7 16.1 16.3 16.5 16.1 16.5 8 16.2 16.1 16.2 16.1 16.3 9. 16.3 16.2 16.4 16.3 16.5 10 16.6 16.3 16.4 16.1 16.5 11 16.2 16.4 15.9 16.3 16.4 12 15.9 16.6 16.7 16.2 16.5 13 16.4 16.1 16.6 16.4 16.1 14 16.5 16.3 16.2 16.3 16.4 15 16.4 16.1 16.3 16.2 16.2 16 16.0 16.2 16.3 16.3 16.2 17 16.4 16.2 16.4 16.3 16.2 18 16.0 16.2 16.4 16.5 16.1 19 16.4 16.0 16.3 16.4 16.4 20 16.4 16.4 16.5 16.0 15.8
6.12. The net weight (in oz) of a dry bleach product is to
be monitored by ī and R control charts using a sam-
ple size of n = 5. Data for 20 preliminary samples
are shown in Table 6E.7.
(a) Set up ī and R control charts using these data.
Does the process exhibit statistical control?
(b) Estimate the process mean and standard deviation.
(c) Does fill weight seem to follow a normal distri-
bution?
(d) If the specifications are at 16.2 ± 0.5, what
conclusions would you draw about process
capability?
(e) What fraction of containers produced by this
process is likely to be below the lower specifi-
cation limit of 15.7 oz?
Transcribed Image Text:6.12. The net weight (in oz) of a dry bleach product is to be monitored by ī and R control charts using a sam- ple size of n = 5. Data for 20 preliminary samples are shown in Table 6E.7. (a) Set up ī and R control charts using these data. Does the process exhibit statistical control? (b) Estimate the process mean and standard deviation. (c) Does fill weight seem to follow a normal distri- bution? (d) If the specifications are at 16.2 ± 0.5, what conclusions would you draw about process capability? (e) What fraction of containers produced by this process is likely to be below the lower specifi- cation limit of 15.7 oz?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning