ANALYSIS
Assume you are John Adams of ADS. Based on the following analysis, prepare a report to be submitted to both ADS and DCI executives regarding the status of the filling process at ADS and recommend method to improve quality control at the filling station and estimate the amount of credit to DCI. Use the data provided in the Excel data file.
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 4 bags? Explain your finding. Hint: ?x-bar = ?/sqrt(n). Having ?x-bar based on part (a) calculation, solve for ? given n= 4. So ? = (?x-bar)(sqrt(n))
c- Construct a time series plot of all four variables (two graphs: one includes avg., smallest, and largest and the other has range data) and discuss your findings based on the graphs.
d- Construct X-bar and R Charts, graph, and discuss your findings based on the control charts. Make sure to include the control limit calculations below. Is the process out of control? Why? Explain.
e- Is there any differences between performances of three shifts? Hint: (Carve out the morning, afternoon, and night shift data into three columns and graph their averages. Explain your findings based on graph.
f- 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 shift averages. Use Alpha =0.01. Indicate the Null and Alt. hypotheses and explain your findings based on ANOVA table.
g- Assume Tolerance limits of 25±1.5 lbs. is specified in the sales contract and find the Process Capability index Cpk. Discuss if this process is capable to meet contractual agreement.