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 help people think!

Copyright © 2009

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 a sample size calculator, it 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)

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.

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.

• 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:

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.
2. Over 80 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.
4. Data Transformation tools to help organize and analyze your data including stack and restack, and WordCount and PivotTable Wizards.
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

:

Try QI Macros
FREE
For 30-Days

Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee