## 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.