QI Macros SPC Software for Excel Lesson 4

QI Macros Lesson 4 - Anova and Statistical Analysis Tools
home · products · services · search · view cart · contact

NAVIGATION

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

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:

Just click and drag over your data to select it.
Then click on the QI Macros menu and select Anova and Analysis Tools
Then select the statistical test you want to perform.

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.

Normality Test
Proportions Hypothesis testing
- Test of a Proportion
- Test of Two Proportions
Rank and percentile
Regression Analysis
Sample Size Calculator
t-test One Sample
t-test Two-Sample assuming equal variances
t-test Two-Sample assuming unequal variances
t-test Paired Two-Sample for Means
Tukey Quick Test
z-test two sample

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
FREE
For 30-Days

QI Macros Lesson 4 - Anova and Statistical Analysis Tools