Course Quality Management and continuous improvement (MGT656)

profileHurokoaty
exampleofcontrolchart.xlsx

Sheet1

Sample Obs 1 Obs 2 Obs 3 Obs 4 Obs 5 sample mean Range
1 10.68 10.689 10.776 10.798 10.714 10.7314 0.118 n A2
2 10.79 10.86 10.601 10.746 10.779 10.7552 0.259 2 1.88
3 10.78 10.667 10.838 10.785 10.723 10.7586 0.171 3 1.023
4 10.59 10.727 10.812 10.775 10.73 10.7268 0.222 4 0,729
5 10.69 10.708 10.79 10.758 10.671 10.7234 0.119 5 0.577
6 10.75 10.714 10.738 10.719 10.606 10.7054 0.144 6 0.483
7 10.79 10.713 10.689 10.877 10.603 10.7344 0.274 7 0.419
8 10.74 10.779 10.11 10.737 10.75 10.6232 0.669 8 0.373
9 10.77 10.773 10.641 10.644 10.725 10.7106 0.132 9 0.337
10 10.72 10.671 10.708 10.85 10.712 10.7322 0.179 10 0.308
11 10.79 10.821 10.764 10.658 10.708 10.7482 0.163
12 10.62 10.802 10.818 10.872 10.727 10.7678 0.252
13 10.66 10.822 10.893 10.544 10.75 10.7338 0.349
14 10.81 10.749 10.859 10.801 10.701 10.784 0.158
15 10.66 10.681 10.644 10.747 10.728 10.692 0.103
10.7284666667
X-double Bar
10.7284666667 UCL 10.8565306667
LCL 10.6004026667
R-bar
0.2208
sample mean 10.731399999999999 10.755199999999999 10.758599999999998 10.726800000000001 10.7234 10.705400000000001 10.734400000000001 10.623200000000001 10.710599999999999 10.732200000000001 10.748200000000001 10.767799999999999 10.733799999999999 10.784000000000001 10.692

Sheet2

Sheet3

x

Chart Con

trol Limit

s

UCL

=

x

+

A

R

LCL

=

x

-

A

R

2

2

x Chart Con trol Limit s

UCL = x + AR

LCL = x - AR

2

2