【正文】 F P Factor 3 623995197 207998399 Error 89 45499333 511228 Total 92 669494530 Individual 95% CIs For Mean Based on Pooled StDev Level N Mean StDev ++++ BCS 18 13944 545 (*) Engine 22 18824 831 (*) OSS 22 21808 648 (*) Steering 31 17867 755 (*) ++++ Pooled StDev = 715 15000 17500 20xx0 22500 40 Analyze: Correlation Exercise From the “High Transportation Costs” cause and effects (Camp。E) diagram, the team decided to investigate “Move”. Specific potential causes are storage, volume of belongings and distance. Stratified data of the “Transport of Belongings” was gathered. Now we want to determine if any/all causes identified from the “Move” bone of the Camp。E diagram are correlated to “High Transportation Costs” using Minitab. Create a fitted line plot for cost vs. days in storage, cost vs. volume and cost vs. distance. Be able to demonstrate and discuss your findings. If the move was for a distance of 1375 miles, what would the expected cost be? File: 41 Analyze: Correlation Exercise Answers Stat Regression Fitted Line Plot… Perform function for each variable (storage days, volume and distance) 42 Analyze: Correlation Exercise Answers The one point at 63 days was investigated by the team and determined to be due to a special cause (estimate for lost data) and is helping to show a moderate correlation (RSq=%). With this point eliminated, there does not appear to be a correlation between storage days and cost (RSq=%). 0 10 20 30 40 50 60 2 0 0 0 3 0 0 0 4 0 0 0 5 0 0 0 6 0 0 0 7 0 0 0 8 0 0 0 9 0 0 010000S t o r a g e D a y sCost (transpC o s t ( t r a n s p = 5 2 3 6 . 7 0 + 8 7 . 0 4 9 1 S t o r a g e D a y sS = 1 4 2 6 . 4 4 R S q = 6 3 . 9 % R S q ( a d j) = 5 8 . 7 %C o s t v s . D a y s i n S t o r a g e1510 5 0750065005500450035002500S t o r a g e D a y sCost (transpS = 1 5 4 0 . 3 4 R S q = 1 2 . 0 % R S q ( a d j) = 0 . 0 %C o s t ( t r a n s p = 5 2 1 7 . 5 9 + 9 2 . 4 7 7 9 S t o r a g e D a y sC o s t v s . S t o r a g e D a y s ( e li m i n a t e d f ly e r )43 Analyze: Correlation Exercise Answers A positive correlation appears present due to our RSq=%. The trucking pany?s semi trailer has a total volume of 4000 cubic feet. They only bill at whole or half trailer increments which explains why data points only appear at 4000, 6000, 8000 and 120xx. 4 0 0 0 5 0 0 0 6 0 0 0 7 0 0 0 8 0 0 0 9 0 0 0 10000 11000 120xx 2 0 0 0 3 0 0 0 4 0 0 0 5 0 0 0 6 0 0 0 7 0 0 0 8 0 0 0 9 0 0 010000V o l u m e ( c u b iCost (transpC o s t ( t r a n s p = 4 6 0 . 8 7 0 + 0 . 9 3 0 4 3 5 V o lu m e ( c u b iS = 7 5 6 . 3 4 0 R S q = 8 9 . 8 % R S q ( a d j) = 8 8 . 4 %C o s t v s . V o lu m e44 Analyze: Correlation Exercise Answers Cost vs. Distance has the strongest correlation (RSq=%). Using the regression equation: Cost=124 + 6(distance), the cost for 1375 miles should be $8374. A visual check of this cost and distance on the graph confirms the calculation was performed correctly. 5 0 0 1000 1500 2 0 0 0 3 0 0 0 4 0 0 0 5 0 0 0 6 0 0 0 7 0 0 0 8 0 0 0 9 0 0 010000D i s t a n c eCost (transpC o s t ( t r a n s p = 1 2 3 . 7 4 3 + 6 . 3 9 4 1 5 D is t a n c eS = 1 1 6 . 6 6 0 R S q = 9 9 . 8 % R S q ( a d j) = 9 9 . 7 %C o s t v s . D i s t a n c e45 Improve: Involvement Matrix Developing, implementing and monitoring solutions is usually a group task。 many people are involved in making changes happen. Because this project will cover all groups in North America, it will be very important to have the right people involved in making and implementing solutions. On the following page, identify who would be involved at each level for the tasks listed. Be prepared to discuss your selection of specific groups or individuals. 46 Improve: Involvement Matrix TASKS Responsible For Involved In Consulted With Informed About Identifying solutions Selecting solutions Planning implementation Handling potential problems Implementing the solution Monitoring Results Which groups or individuals should be: 47 Improve: Involvement Matrix Sample Answer TASKS Responsible For Involved In Consulted With Informed About Identifying solutions Project Team HR Reps Legal HR Directors Selecting solutions Project Team amp。 HR Reps Purchasing Legal Business Unit VPs VP HR HR Directors Planning implementation Project Team amp。 HR Reps Purchasing Legal Communication VP HR HR Directors Handling potential problems Project Team HR Reps Communication Purchasing Legal HR Directors VP HR Implementing the solution Purchasing HR Reps amp。 Directors Project Team Communications CEO, COO VPs HR, Finance, Bu