Sample Size Estimation and Power Calculations with Excel

Logo for UCL
Learn More

Before you apply - don't miss out!

Subscribe to our weekly update on new listings

By registering you agree to our terms & conditions and privacy policy.

You can unsubscribe anytime using the link in the bottom of the email.

You will receive an email asking you to confirm your subscription

Start - End
13 Jan - 14 Jan
Study Options
Contact Name
Centre for Applied Statistics Courses
Contact Email

13 January 2021–14 January 2021, 9:30 am–1:00 pm

This course gives the basics of sample size estimation. It will be of use to those embarking on a research project and who are perhaps trying to complete ethics and grant application forms. Both precision and power estimation approaches are covered.

NOTE: Due to the coronavirus outbreak, all courses will now be delivered online through a live video feed. You can expect the same level of group and individual support as you would have received in our face-to-face courses.

The concepts of sample size estimation are introduced, including when and why this might be necessary. Formulae are presented and discussed. An accompanying weblink is introduced which hosts excel sheets pre-programmed to facilitate use of the formulae. In the first part of the course, the precision-based approach to sample size estimation is introduced, whereby the numbers are selected to produce a confidence interval for the relevant estimate with a specified width. In the second part, we progress to the more traditional power calculations that aim to give the sample required to determine a specified difference with selected power and significance levels. All terminology will be explained as it is introduced in the sessions.

Sample size estimation is discussed for the following measurements:

  • Means
  • Proportions/ percentages
  • Rates

Notes and spreadsheets are also provided to cover the following, which will be discussed if time permits:

  • Time to event data
  • Measures of agreement
  • Percentiles

Everyone wishing to attend should ensure Microsoft Excel (or alternative compatible software) is installed.

Learn More

Featured Courses

UK Data Service

December 10, 2020

UK Data Service

November 26, 2020


February 12, 2021


February 03, 2021

Our Partners

Logo for Nhs
Logo for Waikato
Logo for Quiagen
Logo for Roche
Logo for Ucla

Like what you see?