# Project #69492 - SPC Project

Â

Insert all graphs and provide analysis in this word file after every question. Only The Word file is graded.

Â

a-Â Â  Calculate the Range Column in Excel (Largest-Smallest) and find mean and standard deviations for Average Weight, Smallest, Largest, and Range columns.Â

Â

b-Â Â  What is the standard deviation of individual bags if sample averages are based on 9 bags?Â  Explain your finding. Hint: Ã¯â€žâ€ x-bar = Ã¯â€žâ€ /sqrt(n). Having Ã¯â€žâ€ x-bar based on part b calculation, solve for Ã¯â€žâ€  given n= 9

Â

c-Â Â Â  Â Does the ADS data support the claim by DCI that the average weight of bags is less than 50 lbs.? Use Alpha=0.01 and do hypothesis testing on mean.

Â

d-Â Â  Construct a time series plot of all four variables (4 graphs) and discuss your findings based on the graphs.

Â

e-Â Â Â  Construct X-bar and R Charts, graph, and discuss your findings based on the control charts.Â  Is it out of control?Â  Why? Explain.

Â

f-Â Â Â Â  Is there any differences between performances of three shifts? Hint: (Carve out the morning, afternoon, and night shift data into three columns and graph them.Â  Explain your findings.

Â

g-Â Â  Use One Way Analysis of Variance (ANOVA)to compare the three groups (shifts) to test if there is significant differences in the performance of three shifts.Â  Use Alpha =0.01.Â  Can you conclude that night shift is to be blamed for most of the variation?Â

Â

h-Â Â  Assume Tolerance limits of 50Â±1.5 lbs. is specified in the sales contract and find the Process Capability index Cpk.Â  Explain what it indicates and if process is capable to meet contractual agreement.

Â

i-Â Â Â Â  If the improved process average is adjusted to 50.0 lbs. and process standard deviation is reduced to .60, what is the new Cpk?Â  Are you comfortable for making such recommendation to management?Â  Explain.

Â

j-Â Â Â Â  Find the control limits for an X-bar and R chart if a new improved process has average of 50.1 lbs. and R-bar of 2 lbs. Assume n=7 for new process control.

Â

k-Â Â  Provide complete conclusion regarding your findings and make recommendations regarding the filling process in your conclusion paragraph.

Â

Â

Due Date: Sunday April 3, 2015.Â  Must submit both Excel file and Word File in Blackboard.

 Subject Business Due By (Pacific Time) 05/03/2015 05:00 pm
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews