homeworks1,2, and 3

profileJohnnetwork
todayactivities09-29-2021.xlsx

Sample Control Chart

Sample Number x1 x2 x3 x4 x5 Xbar CL=Xbarbar UCL LCL R CL=Rbar UCL LCL
1 -30 50 -20 10 30 8
2 0 50 -60 -20 30
3 -50 10 20 30 20
4 -10 -10 30 -20 50
5 20 -40 50 20 10
6 0 0 40 -40 20
7 0 0 20 -20 -10
8 70 -30 30 -10 0
9 0 0 20 -20 10
10 10 20 30 10 50
11 40 0 20 0 20
12 30 20 30 10 40
13 30 -30 0 10 10
14 30 -10 50 -10 -30 Data to be gathered:
15 10 -10 50 40 0 m 20
16 0 0 30 -10 0 n 5
17 20 20 30 30 -20 A2 0.577
18 10 -20 50 30 10 D3 0
19 50 -10 40 20 0 D4 2.115
20 50 0 0 30 10
X-BarBar Rbar

Where Xbar is the average of the sample Xbarbar is the grand average, this will be used as the center line on the Xbar Chart m is the number of samples n is the sample size

Control limits for the R chart

Control Chart 1

Sample number x1 x2 x3 x4 x5 x6 x7 x8 x9 x10
1 2.5 0.5 2 -1 1 -1 0.5 1.5 0.5 -1.5
2 0 0 0.5 1 1.5 1 -1 1 1.5 -1
3 1.5 1 1 -1 0 -1.5 -1 -1 1 -1
4 0 0.5 -2 0 -1 1.5 -1.5 0 -2 -1.5
5 0 0 0 -0.5 0.5 1 -0.5 -0.5 0 0
6 1 -0.5 0 0 0 0.5 -1 1 -2 1
7 1 -1 -1 -1 0 1.5 0 1 0 0
8 0 -1.5 -0.5 1.5 0 0 0 -1 0.5 -0.5
9 -2 -1.5 1.5 1.5 0 0 0.5 1 0 1
10 -0.5 3.5 0 -1 -1.5 -1.5 -1 -1 1 0.5
11 0 1.5 0 0 2 -1.5 0.5 -0.5 2 -1
12 0 -2 -0.5 0 -0.5 2 1.5 0 0.5 -1
13 -1 -0.5 -0.5 -1 0 0.5 0.5 -1.5 -1 -1
14 0.5 1 -1 -0.5 -2 -1 -1.5 0 1.5 1.5
15 1 0 1.5 1.5 1 -1 0 1 -2 -1.5
n=10

Control Chart 2

x1 x2 x3 x4
120.03 120.02 120.01 120.01
120.01 120 120.03 119.98
120.02 120.01 120 120
120 120.03 120.04 120.01
120.01 120.02 120.02 119.99
120.01 119.98 120.01 120
120 120.01 120.02 119.99
120 120 120.02 120
120.03 120.02 119.99 120.02
120.01 120.01 120.01 119.99
120.03 120.02 120.01 120
120.02 119.99 120 120.01
120.01 120.01 120 120.03
120 120.03 119.97 119.98
120.01 119.99 120 119.98
120.01 120 120 120
120.01 120 120.02 120.01
120 119.99 119.99 120.02
119.99 120.03 120 120.01
120.02 119.98 119.99 120.01
120.01 120.02 119.99 120
119.98 120.02 119.99 119.99
120 120.01 120.02 120.02
120.01 120.04 119.98 119.99
120.03 120.01 120 120.01

Pareto Chart and a HIstogra,

1. Build a Histogram where you identify the age where people pay less taxes
2. Using the same data, build a Pareto chart ages where people pay more medical expenses
3. You are asked to submit both chart and includeoone or two sentences with your conclusions for each chart
4. Search in Internet for information to support your chart

image1.wmf

R

A

X

UCL

2

+

=

image2.wmf

R

A

X

LCL

2

-

=

_951209144.unknown

_951209448.unknown

RAXUCL

2



RAXLCL

2



deviation standard

3XLCL

3XUCL





m

m

i

i

å

=

=

1

X

X