See attached assignment
Requirements:
- Must read and follow all instructions and grading rubic
- Must show all work in Excel (calc, formulas, etc.)
- Due Date: Saturday, 7/6 @ 11 PM PST
Controls
As a quality analyst you are also responsible for controlling the weight of a box of cereal. The Operations Manager asks you to identify the ways in which statistical quality control methods can be applied to the weights of the boxes. Provide your recommendations to the Operations Manager in a two-three page report. Using the data provided labeled M4A2Data, create Xbar and R charts.
Your report should indicate the following along with valid justifications of your answers:
a. The control limits of the weights of the boxes.
b. Nonrandom patterns or trends, if any.
c. If the process is in control.
d.
The appropriate action if the process is not in control.
Due by
Saturday, July 6, 2013
.
Assignment 2 Grading Criteria
Maximum Points
Using the data provided created Xbar and R charts.
15
Set control limits for the weights of the boxes.
15
Established the criteria for nonrandom patterns or trends, if any.
15
Stated whether the process is in control, according to the limits and the criteria established in b and c above.
15
Suggested the appropriate action if the process is not in control.
15
Gave valid and supported reasons for their answer.
15
Used correct grammar, spelling, and word choice and cited all sources using correct APA style.
10
Total:
100
>Sheet ote: The following consists of sets of three box weights in ounces
.3
6.32 735027
3333333
6.33 88 58
6.33 6.323 6.28 6.39 6.4 6.3391
N
12
N
#1
#2
#
3
StdDev
Xbar
1
6
6.2
8
6.26
0.02
6.28
2
6.32
6.33
0.00
5
7
6.323
3
6.2
9
6.36
0.035
11
4
6.3266666667
4 6.3 6.29
6.34
0.0264575131
6.31
5
6.295
6.315
6.39
0.050083264
6.3333333333
6
6.292
6.319
0.0195533458
6.3136666667
7
6.289
6.4
0.0568711995
6.3373333333
8
6.286
6.327
6.471
0.0971613778
6.3613333333
9
6.283
6.331
6.498
0.1128553647
6.3706666667
10
6.335
6.525
0.1285496013
6.38
11
6.277
6.339
0.0565891627
6.3353333333
12
6.274
6.343
0.0630951662