Statistical Tools in Excel Using the QI Macros

Shopping cart

0 Product(s) in cart

Total $0.00

» Checkout

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

Copyright © 2011

You don't have to be a statistician to perform statistical analysis on your data.

• Does the thought of performing complicated statistical analysis on your data intimidate you?
• Have you struggled with the awkward interface of Excel's Data Analysis Toolpak?

The QI Macros for Excel Anova and Analysis tools has a much easier to use interface than Excel's Data Analysis Toolpak. The QI Macros also has additional tools like the Statistics Wizard and a sample size calculator. It also mistake proofs some of your data entry and it interprets the results of many statistical tests for you.

Here's How to Perform Statistical Analysis using the QI Macros:

View Statistical Tools Tutorial (11 minutes)

View Anova and Analysis Tools Video (2 minutes)

Read how the Statistics Wizard works

Follow these steps:

1. Just click and drag over your data to select it.
2. Then click on the QI Macros menu and select Anova and Analysis Tools
3. Then select the statistical test you want to perform or if you don't know which test to perform select the Stat Wizard.

Excel 2000 to 2003 menu

Excel 2007 and 2010 menu

The biggest challenge is to ensure you have your data organized correctly. Go to the test data we loaded on your machine in c:\qimacro\testdata. Open the file called anova.xls for examples of how to organize your data.

Here is a list of the Statistical Tools in the QI Macros with links to more detailed articles.

Statistical Wizard

• Anova One Way
• Anova Two Way Without Replication
• Anova Two Way With Replication
• Chi-square Contingency Table
• Chi-square Goodness of Fit
• Correlation
• Covariance
• Descriptive Statistics
• Exponential smoothing
• Fisher Exact Test
• Hypothesis testing
• f-Test two sample for variances
• Levene's Test for non-normal variances
• Moving average
• Multiple Regression Analysis
• NonParametric Tests Including:
  • 1-sample sign test
  • Friedman test
  • Kolmogorov-Smirnov (K-S)
  • Kruskal-Wallis test
  • Mann-Whitney test
  • Mood's Median
  • Sign Test
  • Spearman test
  • Tukey Quick Test
  • Wilcoxon Signed Rank Test
  • Wilcoxon Rank Sum Test
• 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
• z-test Two-Sample for Means

View Statistical Tools Tutorial (11 minutes)

View Anova and Analysis Tools Video (2 minutes)

The QI Macros SPC Software for Excel has Five Parts and Numerous Wizards to Assist With Your Data Analysis:

1. Over 30 charts including histograms, pareto charts, scatter plots, box whisker plots and all variable and attribute control charts. Just select your data and then click on the QI Macros menu and select the chart you want to run. If you are not sure, select the Chart Wizard to run various charts on your data or the Control Chart Wizard to select the right control chart.
2. Over 90 Fill-in-the-blank templates and tools including fishbones, FMEA, DOE, Gage R&R, PPAP forms and more.
3. Statistical tools including Anova, f-test, t-test, regression, data normality test, sample size calculator and more. Select your data and click on the Statistics Wizard to run the most common statistical tests for your data.
4. Data Transformation Tools to help organize and analyze your data including stack and restack. Includes WordCount and PivotTable Wizards to help you summarize and organize your data.
5. Automated Control Chart Dashboards - just drop your data into these pre-formatted templates.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

:

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!