**Confidence intervals for proportions and related quantities**

The following resources have been developed by Professor Robert Newcombe to calculate confidence intervals for proportions and related quantities, and display appropriate plots. All are available in MS Excel form.

**Proportions and their differences**

CIPROPORTION.xls [30.5 Kb]

Single proportion, unpaired and paired differences

TANGO.xls [45.5 Kb]

A better method for the paired difference of proportions

ICPROPORCION.xls [24.0 Kb]

Single proportion, unpaired and paired differences (Spanish Version)

CHCYFRANNEDD.xls [24.0 Kb]

Single proportion, unpaired and paired differences (Welsh Version)

**Interaction – difference of differences of proportions**

INTERACTIONUNPAIRED.xls [30.5 Kb]

Difference of two differences of independent proportions

INTERACTIONPAIRED.xls [30.5 Kb]

Difference of two differences of paired proportions

**2 by 2 tables**

ODDSRATIOANDRR.xls [123 Kb]

Confidence intervals for odds ratio and ratios of proportions and rates – two independent groups

PPVNPV.xls [127 Kb]

Projected positive and negative predictive values, with confidence regions

BONETTPRICE.xls [27.5 Kb]

Confidence interval for ratio of proportions for paired data

**Mean of a variable taking the values 0, 1 and 2**

MEAN012.xls [46.0 Kb]

Confidence interval for the mean of a variable taking the values 0, 1 and 2

**Simultaneous comparison of sensitivity and specificity**

SESPPAIRED.xls [59.5 Kb]

Paired case

SESPUNPAIRED.xls [56.0 Kb]

Unpaired case

**Theta = U/mn, a generalisation of the Mann-Whitney statistic**

VISUALISETHETA.xls [36.5 Kb]

Visualise theta by two Gaussian curves

GENERALISEDMW.xls [72.0 Kb]

Confidence interval for U/mn

**Psi = DeltaT/max, a generalisation of the paired Wilcoxon statistic**

VISUALISEPSI.xls [37.5 Kb]

Visualise psi by a Gaussian curve

GENWILCOXON.xls [74.0 Kb]

Confidence interval for DeltaT/max.

**Obtaining a confidence interval for a quantity derived from two other independently estimated quantities**

MOVER-D.xls [27 Kb]

Calculates a confidence interval for a difference of two quantities, starting from independent estimates and confidence intervals for both.

MOVER-R.xls [55 Kb]

Calculates a confidence interval for a ratio of two quantities, starting from independent estimates and confidence intervals for both.

RD from BR and RR.xls [47 Kb]

Calculates a confidence interval for a rate difference, starting from independent estimates of baseline rate and relative risk and confidence intervals for them.