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.