XLSTAT - Comparison of two proportions

XLSTAT uses the z-test to compare two proportions.

Let n1 be the number of observations verifying a certain property for sample S1 of size N1, and n2 the number of observations verifying the same property for sample S2 of size N2. The proportion of sample S1 verifying the property is defined by p1 = n1 / N1, and the proportion for S2 is defined by p2 = n2 / N2. Let D be the assumed difference (exact, minimum or maximum) between the two proportions p1 and p2. D is usually 0.

The test can be two-tailed:

  • H0 : p1 - p2  = D
  • Ha : p1 - p2 ≠ D

For the left-sided one-tailed test we have:

  • H0 : p1 - p2  = D
  • Ha : p1 - p2 < D

And for the right-sided one-tailed test we have:

  • H0 : p1 - p2  = D
  • Ha : p1 - p2 > D

This test is based on the following assumptions:

  • the observations are mutually independent,
  • the probability p1 of having the property in question is identical for all observations in sample S1,
  • the probability p2 of having the property in question is identical for all observations in sample S2,
  • the number of observations N1 and N2 are large enough, and the proportions are neither too close to 0 nor to 1.

XLSTAT

This analysis is available in the XLStat-Base addin for Microsoft Excel

About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey

Share: FacebookFacebook TwitterTwitter RedditReddit
Del.icio.usDel.icio.us Stumble UponStumble Upon

 

Like us on Facebook

Get in Touch

  • Email:
    sales@kovcomp.com
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414