This assignment applies concepts from the Analyze phase of a Lean Six Sigma project. It again...

Transcribed Image Text:

This assignment applies concepts from the Analyze phase of a Lean Six Sigma project. It again uses data from the first Cannabis Oil Data spreadsheet and from the Background Information document. The spreadsheet shows the milligrams of CBD in capsules from the east and west sites. Use this data to answer the following questions. Story Your initial investigation uncovered apparent differences between the east and west processes. You next need to determine whether the differences were due to actual differences between the processes, rather than to the randomness of the sampling procedure (i.e., were the capsules you chose just "lucky"). Questions 1. Draw 2 histograms to compare the "widths" of the two processes. In the first histogram show the distribution of CBD per cartridge for the east site. In the second histogram show the distribution for the west site. You can draw these using software or by hand. Use the same vertical and horizontal scales for both diagrams. You might need to try different "bin limits" to see what works best for the horizontal scales. Which process looks more consistent? 2. Perform a statistical test to compare the variability of the 2 processes. That is, do a 2-sample F-test to compare the CBD standard deviations of the east and west sites. Make sure the F- calculated value is greater than 1. Do this test using software or by hand. For hand calculations you can use the Excel functions "finv()" or "f.inv()" to get the critical value and "fdist()" or "f.dist.rt()" to get the significance p. Is there a difference in variability? 3. Perform a statistical test to compare the typical output of the 2 processes. That is, do a 2- sample t-test to compare the mean of the east process to the mean of the west one, assuming unequal variances. Do this test using software and include the results table in your answer. Are the processes different on average? 4. Perform a statistical test to assess the accuracy of the west process only. That is, do a 1-sample t-test to compare the mean CBD of the west process to the design target for the product. Do this test by hand. You can use the Excel functions "tinv()" or "t.inv.2t()" to get the critical value and "tdist()" or "t.dist.2t()" to get the p. Does the output match the target? This assignment applies concepts from the Analyze phase of a Lean Six Sigma project. It again uses data from the first Cannabis Oil Data spreadsheet and from the Background Information document. The spreadsheet shows the milligrams of CBD in capsules from the east and west sites. Use this data to answer the following questions. Story Your initial investigation uncovered apparent differences between the east and west processes. You next need to determine whether the differences were due to actual differences between the processes, rather than to the randomness of the sampling procedure (i.e., were the capsules you chose just "lucky"). Questions 1. Draw 2 histograms to compare the "widths" of the two processes. In the first histogram show the distribution of CBD per cartridge for the east site. In the second histogram show the distribution for the west site. You can draw these using software or by hand. Use the same vertical and horizontal scales for both diagrams. You might need to try different "bin limits" to see what works best for the horizontal scales. Which process looks more consistent? 2. Perform a statistical test to compare the variability of the 2 processes. That is, do a 2-sample F-test to compare the CBD standard deviations of the east and west sites. Make sure the F- calculated value is greater than 1. Do this test using software or by hand. For hand calculations you can use the Excel functions "finv()" or "f.inv()" to get the critical value and "fdist()" or "f.dist.rt()" to get the significance p. Is there a difference in variability? 3. Perform a statistical test to compare the typical output of the 2 processes. That is, do a 2- sample t-test to compare the mean of the east process to the mean of the west one, assuming unequal variances. Do this test using software and include the results table in your answer. Are the processes different on average? 4. Perform a statistical test to assess the accuracy of the west process only. That is, do a 1-sample t-test to compare the mean CBD of the west process to the design target for the product. Do this test by hand. You can use the Excel functions "tinv()" or "t.inv.2t()" to get the critical value and "tdist()" or "t.dist.2t()" to get the p. Does the output match the target?