Sample Size Estimation and Power Calculations

The Microsoft Excel spreadsheets contained on the following pages accompany the CASC short course 'Sample Size Estimation and Power Calculations in Excel'. The section numbers given below relate to the associated sections in the course notes, within which formulae and calculations are given. 

If you click on any of the sections below, you will be taken to a page containing excel spreadsheets (all .xls format) for each of the sample estimates referenced in that section (e.g., single mean, difference between two means, single rate, time-to-event, etc.).

Precision - Section 2

Power - Section 3

Unequal Groups - Section 5

All pages and materials have been produced and provided by the Centre for Applied Statistics Courses (CASC), UCL Great Ormond Street Institute of Child Health.

If you experience problems accessing materials on these pages please email ich.statscou@ucl.ac.uk detailing the specific problem.

To download all spreadsheets for this course in a zip file, click here.

For other statistics courses, click here to go to the main CASC homepage.