Test of Two Proportions

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

Copyright © 2011



 

Use our Two Proportion test template to compute a confidence interval and perform a hypothesis test of the difference between two proportions.

For example, if you are sending a direct mail piece to a group of prospects you may want to know if the proportion of customers who respond could be increased by offering free shipping. You would offer free shipping on half of your mailings and see if you have more purchases from the group that was offered free shipping from the group that was not.

Here is how to perform a Test of Two Proportions using the QI Macros Proportion template:

Watch Test of Proportions in Excel Video

  1. If data isn't summarized, use PivotTables to summarize the trials and successes
  2. Click on the QI Macros pull down menu and select Anova and Analysis Tools, then Proportion tests. A template will open. Click on the tab labeled "Two Proportions."
  3. Test of two proportions in Excel

  4. Enter Test Difference in E2. The default is 0.
  5. Enter number of trials in A3 and A7
  6. Enter number of successes in B3 and B7
  7. Enter confidence Level in F1
  8. Null hypothesis is H0: P1=P2, H1: P1<>P2
    If cell I3:I5 is green, you cannot reject the null hypothesis
    If cell I3:I5 is red, reject the null hypothesis.

Other Statistical tests in the QI Macros

The Test of Two Proportions template is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

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

QI Macros - One License Per Computer - Download with backup CD & User Guide (#230) $199 + S&H
QI Macros - One License Per Computer - Download Only - No Shipping or Customs Duties (#W230) $199
 

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

QI Macros - One License Per Computer - Download with backup CD & User Guide (#230) $199 + S&H
QI Macros - One License Per Computer - Download Only - No Shipping or Customs Duties (#W230) $199
 
home | products | services | search | sitemap | view cart | contact
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