Are there FREE Excel alternatives to Minitab?
We get asked this question a lot. Many companies or individuals do not want to incur the expense for Minitab or other costly statistical analysis tools. Another reason this question is often asked is because most people are more comfortable with Microsoft Excel.
The answer is YES!
The answer to their question is YES! There is are free Microsoft Excel alternatives to Minitab for statistical analysis. Excel has an add-on called the Data Analysis Tool-pack. Plus there are many templates that have been developed and are available on the web.
Lean Six Sigma Six Sigma trained key contributor and team leader, a part-ti... Certification Training
Receive your Lean Six Sigma Green Belt training from an Accredited Authorized Training Organization through the IASSC (International Association of Six Sigma Certification). Once you complete the course, you have the option of completing the IASSC exam to receive the IASSC Certification; completing a Green Belt project; or both. Contact us for more details.
This is a reference to Microsoft Excel alternative tools and templates to Minitab statistical analysis that are taught in o Lean Six Sigma Green Belt and Experienced, recognized Six Sigma expert and project leader,... course. You will find YouTube videos and websites explaining the different tools.
Free Microsoft Excel Built In Graphs
These statistical analyses are created in MS Excel using tools other than the Data Analysis Tool (i.e., using MS Excel’s different default graphing functions)
- Pareto Chart – https://www.youtube.com/watch?v=SDzBkjo8Qeo
- 2nd The value of an input in an experimental run. Pareto Chart (Excel can’t perform this analysis)
- Box and Whiskers Plot – https://www.youtube.com/watch?v=EiS-q6euyf8.
- Time Series Plot – https://www.youtube.com/watch?v=gl28MOUyYu0
- Scatter Plot – https://www.youtube.com/watch?v=OVA2M7EIx80
Microsoft Excel Data Analysis Tool
These statistical analyses use the MS Excel Data Analysis Tool. We have also included an article explaining the different data analysis tool’s and how to load the MS Excel add-in.
- Installing and Using the MS Excel Data Analysis Tool: https://support.office.com/en-us/article/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6
- Descriptive Statistics – https://www.youtube.com/watch?v=wY-Fy-lsE6I
- One Sample t-Test – https://www.youtube.com/watch?v=v-ZcqrdTcIQ
- Two Sample t-Test – https://www.youtube.com/watch?v=DN4_1ynREIU
- One Way Analysis of Variance (ANOVA) – https://www.youtube.com/watch?v=jwAn7JTMknA
- Regression Analysis – https://www.youtube.com/watch?v=87iA8KC2l3s
- Correlation – https://www.youtube.com/watch?v=kr64tfZmiGA
FREE! Lean Six Sigma Root Cause Analysis Toolset(AD)
This FREE Downloadable ZIP file contains seven templates in the Lean Six Sigma Root Cause Analysis toolset (Including the SIPOC). Each template is in a Microsoft Excel format. These tools are used in the DMAIC is an abbreviation of the five improvement steps it co... Learn More... (Define, Measure, Improve, and Control) phases of a Lean Six Sigma Root Cause Analysis.
Third-Party templates that work with Excel
I have attached MS Excel templates to perform the statistical analyses functions below in Excel that we teach in our Lean Six Sigma Green Belt course using Minitab. **These tools were not developed nor are maintained by any Six Sigma Development Solution, Inc. employee.
- Chi-Squared Test – “Chi-Squared Test.xlsx”
- Gauge R&R (Crossed) – “Gauge R&R Crossed.xlsx”
- Attribute Agreement Analysis – “Attribute Agreement Analysis.xlsx”
- Process Capability Analysis – “Consists of input, value-add, and output. Learn More... Capability Analysis.xlsx”
- Variable Control Charts (IMR and XBarR) – “Variable Control Charts.xlsx”
- P-Chart – “P-Chart.xlsx”
If you know of other free Excel alternatives to costly statistical analysis tools, please let us know in the comments.
There are FREE Microsoft Excel alternative tools to Minitab (and other costly) statistical analysis tools. The plus side of these tools is the cost (absolutely FREE) but the downside of these tools are the limited functionality.