QI Macros Lesson 4 - Anova and Statistical Analysis Tools |
||
| home
· products
· services · search
· |
||
| NAVIGATION | |||||||
|
Jay Arthur
Copyright © 2011
|
Excel's Data Analysis Toolpak can be difficult to
use. The QI Macros for Excel Anova and Analysis tools are much easier to use.
The QI Macros also has additional tools like a sample size calculator and we interpret
the results of many of the tests for you. Here's How to Perform Statistical Analysis in Excel using the QI Macros: Follow these steps:
![]() The biggest challenge is to ensure you have your data organized correctly. Go to the QI Macros test data loaded on your machine in c:\qimacro\testdata. Open the file called anova.xls for examples of how to organize your data. View Statistical Tools Tutorial (11 minutes) View Anova and Analysis Tools Video (2 minutes) Here is a list of the Statistical Tools in the QI Macros with links to more detailed articles and videos.
In Lesson #5 we will cover Data Transformation Tools. View previous lesson .........View next lesson To sign up for this series tell your friends to send an email to qimacros@aweber.com If you love the QI Macros... Please ask a handful of friends to download the trial version. Here's what to say: Need easy to learn, easy to use software for Lean Six Sigma and SPC that works right in Microsoft Excel? Test drive the QI Macros! Find out more at www.qimacros.com/excel-spc-software.html. Get a 30-day trial at www.qimacros.com/free-spc-software.html. Going to a meeting of quality professionals? We can send you as many QI Macros 30-day trial CDs as you need. Just send an email with the address and quantities needed to orders@qimacros.com. |
Try QI Macros
|
|||||
|
home | products | services | search | sitemap | QI Macros | Excel SPC Software | SPC Software Free Trial Control Charts | c Chart | np Chart | p Chart | u Chart ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart Histograms | Pareto Chart | Scatter Plot | Run Chart Box Whisker Plot | Dot Plot | Multivari Chart Lean Six Sigma Training | Lean Six Sigma Training Denver Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training |
|||||||