WEDNESDAY, JUNE 19, 2013
Font Size
Topic Confidence intervals in order statistics

Confidence intervals in order statistics

HomeForumsGeneral ForumsTools & TemplatesConfidence intervals in order statistics

This topic has 2 voices, contains 2 replies, and was last updated by Avatar of Peter Örtlund Örtlund 393 days ago.

Viewing 3 posts - 1 through 3 (of 3 total)
Author Posts
Author Posts
February 1, 2011 at 6:44 am #168761
Avatar of Peter Örtlund
Örtlund
Reputation - 10
Rank - Aluminum

Hi, I’m trying to understand (with emphasis on trying) a new discipline in statistics for me, order statistics.

What I’m trying to figure out is how to calculate the CI (95%) for a specific percentile.

It is probably easiest described in my actual problem. The thing I am trying to achieve are how to calculate the CI for percentile P2,5 and P97,5 for a dataset of n=160 in excel.

The percentile is easy using the command “PERCENTILE(array,k)” instead of going by rank and find it. However it doesn’t seems to be a function to calculate the CI level?

Can anyone help me? Preferably in layman’s terms ;-)

Regards
/peteR
[file name=Data_exampel.xls size=22528]http://www.isixsigma.com/images/fbfiles/files/Data_exampel.xls[/file]

February 1, 2011 at 3:30 pm #168764
Avatar of Robert Butler
Butler
Reputation - 0
Rank - Aluminum

It’s too long to paraphrase but I can point you to a pretty good description of what you will need to do in order to build something in Excel.

pp. 15 – 19 Distribution FreeConfidence Intervals for Quantiles – in Order Statistics 2nd Edition by David. My copy is old. I suspect either the most recent edition of this work or any other basic book on order statistics will have the same information.

February 2, 2011 at 12:08 pm #168771
Avatar of Peter Örtlund
Örtlund
Reputation - 10
Rank - Aluminum

ok :ohmy: not as straight forward as I hoped for then… O well, I’m always glad for new books anyway =)

Thanks a lot for your answer, life is always easier with an direction ;-)

Regards

/peteR

Viewing 3 posts - 1 through 3 (of 3 total)

Register Now

  • Stop this in-your-face notice
  • Reserve your username
  • Follow people you like, learn from
  • Extend your profile
  • Gain reputation for your contributions
  • No annoying captchas across site
And much more! C'mon, register now.

Reply To: Confidence intervals in order statistics
Your information:






<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>


Practical Lean Six Sigma Problem Solving from Air Academy Associates
Lean and Six Sigma eLearning and Blended Solutions
Lean and Six Sigma Project Examples

Login Form