Â

**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 C_{pk}.Â 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 C_{pk}?Â 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 |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |