Microsoft removed the Data Analysis Toolpak from Excel 2011 for the Macintosh in 2008, eliminating statistical tools such as ANOVA, t test, F Test, and regression analysis. Hypothesis testing using these tools is a key element in advanced problem solving, so the loss of these tools has been a major challenge for practitioners of Six Sigma who use the Macintosh, but not anymore.
The QI Macros Lean Six Sigma SPC software has supported Excel for the Macintosh since 1998. The Analysis Toolpak has been rewritten for Excel 2011 and includes many previously unavailable features like 1-sample t tests, Fishers Exact test, Levene’s test, normality tests, non-normality tests, and proportion tests. There’s even a statistics wizard to simplify hypothesis testing.
The QI Macros are an add-in for Microsoft Excel that automate all of the charts and diagrams required for statistical process control (SPC) and lean Six Sigma. The QI Macros consist of four parts: 30 charts and two “chart wizards” that use existing Excel data to create Pareto, control charts, and histograms; more than 90 fill-in-the-blank templates for lean Six Sigma; a statistics wizard; and data transformation tools such as the PivotTable wizard that automates data analysis.
icrosoft removed the Data Analysis Toolpak from Excel 2011 for the Macintosh in 2008, eliminating statistical tools such as ANOVA, t test, F Test, and regression analysis. Hypothesis testing using these tools is a key element in advanced problem solving, so the loss of these tools has been a major challenge for practitioners of Six Sigma who use the Macintosh, but not anymore.
icrosoft removed the Data Analysis Toolpak from Excel 2011 for the Macintosh in 2008, eliminating statistical tools such as ANOVA, t test, F Test, and regression analysis. Hypothesis testing using these tools is a key element in advanced problem solving, so the loss of these tools has been a major challenge for practitioners of Six Sigma who use the Macintosh, but not anymore.
Comments --
Add