95% confidence interval - median

lavster

To calculate the 95% confidence interval of the mean of a normal distribution you calculate 1.96 χ standard error on the mean.
what do you do if you want to calculate the 95% confidence interval on the median of the distribution, for a distribution that is most definitely skewed and not gaussian?
Thanks

Number Nine

I would bootstrap it.

lavster

can you do that in excel?

Number Nine

You'll have to check the documentation. Any worthwhile statistical program will have bootstrapping support; you might want to look at R.