![]() Then used the insights gained to do your homework in Minitab. You can easily do your statistics and Six Sigma homework using the QI Macros for Excel Control Chart and Statistics Wizards. Red points show that Team B is also unstable: Select Team B's data and use the QI Macros Control Chart Wizard to select the right chart (XmR). QI Macros show additional unstable conditions. Note: By default, Minitab often shows only points outside of the UCL/LCL as out of control. The red points indicate that the process is unstable (i.e., out of control). ![]() QI Macros will create a moving range (mR) chart and an X chart (notice sheet names at the bottom of Excel's window): If you stack Team A's data (baseline and improved) and leave a space inbetween, you can then select the data and use the QI Macros Control Chart Wizard to help select the right chart (XmR). Team B should replicate Team A's solution to reduce call times. QI Macros can't help you here, but Team A has shorter call times with the improved process, so they should sustain the improvement (i.e., implement a system to control and monitor performance). What would you recommend should happen in Team A and Team B? The variances aren't statistically different. If you select column A and column C (Team A before and after) and run the QI Macros Statistics Wizard, you will find that the "Means are Different", meaning that the improvement was statistically different. How to Answer: "Is Team A's improvement representative?" Team A and B have statistically different call times. If you look at the QI Macros analysis, you'll see that the "Means are Different" but the variances aren't statistically different. How to Answer the Question: "What does this tell you?" After the QI Macros Statistics Wizard has helped identify the right tests, replicate the t-Test using Minitab's statistics assuming equal variances. Then, because the variances are not different, it will choose the t-Test for means with equal variances. If you copy the data from Minitab and paste it into Excel, you can then select Team A's and Team B's data and use the QI Macros Statistics Wizard to choose tests for you.įirst, it will choose an F-Test to analyze the variances. How to Determine What Test to Use on the Data What would you recommend should happen in Team A and Team B?.Is Team A's improvement representative?.What does this data tell you about Team A and Team B?.What statistical test would you use on this data?. ![]() If you run statistical analysis using this portion only, f-Test and t-Test outputs will not match what is shown below. NOTE: The sample data shown above is not the entirety of the data set. Team A had also done an improvement project (column C). The student's assignment was to analyze call center call time data to compare Team A and Team B (columns A:B). While I draw the line at teaching people how to use Minitab, I realized that the QI Macros could help most students figure out what chart or statistic to use. One student recently offered to pay us to do his homework in Minitab®. We usually tell them to select their data and use the Chart, Control Chart, PivotTable or Stat Wizard to get the desired answer. Students often call or email us about homework assignments. Lessons » How to Do Minitab Homework Using Excel and the QI Macros How to Do Minitab Homework Using Excel and the QI Macros Free Agile Lean Six Sigma Trainer Training.Animated Lean Six Sigma Video Tutorials.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |