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.