Skip to content
Confidence intervals 3

Confidence intervals 3

Download: NonparametricConfidenceIntervals_init.xlsx

Introduction

Nonparametric confidence intervals make no assumptions about the sampling distribution, usually only assuming that measurements are independent and that the sample is suitably representative of the parent population. As such they are often preferred over parametric confidence intervals. In this screencast you will learn how to obtain nonparametric confidence intervals in Excel.

So why use parametric confidence intervals at all? Perhaps the most common use case is when the sample size is fairly small. One essentially makes up for the lack of information provided by a small sample size by making more assumptions about the sampling distribution.

Learning Outcomes

  • Understand the difference between parametric and nonparametric CIs
  • Learn how to obtain a nonparametric CI for the median using the inverse binomial method
  • Learn how to obtain nonparametric CIs using bootstrapping

Tasks

  • Calculate the nonparametric CI for the median using MedianCI, as well as the standard error of the median using BootSE (and default smoothing)
  • Demonstrate how to calculate the CI of any statistic using bootstrapping and the percentile method. Use B=2000B = 2000 with Bootstrap for this task, applying it to the untrimmed mean and 25% trimmed mean at various confidence levels.
  • Use BootCI to calculate the same CIs. Also demonstrate the BCa method. Compare bootstrap CIs to parametric CIs (and, for the median, to the inverse binomial CI).

At the end of the screencast your spreadsheet will look something like the image below.

Parametric CIs for the mean and 25% trimmed mean beside a non-parametric median CI and bootstrap percentile and BCa CIs from Bootstrap and BootCI