1
Multivariate Analysis Final Assignment
Answer all questions and submit your final report in Microsoft word file or PDF format.
Support your answer with output obtained from calculation performed using Minitab.
Question 1 (15 marks)
A company needs to enhance their measurement system accuracy. Six inspectors were
selected to measure the length of three parts twice.
Use the MSA data file to perform the following:
A. Perform Gauge R & R study and provide your conclusion on the results.
B. Provide your recommendation to improve the measurement system accuracy.
C. Provide the best estimate for each part length.
Question 2 (10 marks)
A supplier was requested to deliver order within 25 to 35 days after receiving the Purchase
Order.
Use Delivery Time Data to perform the following:
A. Calculate the capability indices and provide your comments on the results.
B. Provide your recommendation to improve the supplier performance.
Question 3 (10 marks)
Cycle Time was measured and found to be a non-normal distribution.
Use Cycle Time Data to perform the following:
A. Transform Cycle Time data using Box-Cox transformation.
B. Transform Cycle Time data using Johnson transformation.
2
Question 4 (20 marks)
Car manufacturing plant is studying the stability of its processes.
Use Car Factory Data to perform the following:
A. Provide your comments on the stability of daily production.
B. Provide your comments on the stability of defective cars.
C. Provide your comments on the stability of car defects.
Question 5 (15 marks)
Sales manager wishing to predict the future sales.
Use Sales Data to perform the following:
A. Provide your comments on the sales trend.
B. Provide your comments on the sales seasonality.
C. Provide your comments on the obtained accuracy model.
D. Predict the upcoming 3 quarter sales.
Question 6 (15 marks)
Your trip between home and office may be conducted through 2 different roads using Uber
service or your private car.
Use Trip Duration Data to perform the following:
A. Draw Multi-Vari chart.
B. Provide your comments on the Multi-Vari chart.
Question 7 (15 marks)
You wish to evaluate supplier using 4 criteria:
1. Price.
2. On time delivery
3. Quality of product
4. Responding to emergency changes in order
A. Use Analytic Hierarchy Process to determine the weight of each criterion.
B. Provide your comments on Decision Matrix & Consistency Ratio