One sided tolerance interval formula

[#1]

I have a data set and I determined the one-sided upper tolerance interval using JMP, using a 95/95%. For work, I need to do it in excel, does anyone have the formula for the one-sided tolerance interval, so I do it in excel, as new data comes in. I was able to determine the two-sided tolerance interval, but not one-sided.

Thank you

Andrea

[#2]

Have you read through JMP documentation? Usually these things are documented there. Also, if you are using JMP, you should just get a license for it for work.

[#3]

I do have JMP at work, this is more for live results, we need a control excel sheet, we cant use JMP for that. Thank you for the response. 

[#4 · Accepted solution]

Hi @BetaBiasOx911 : in excel you will need an approximation because the exact calculation requires the non central t-distribution (not available in excel).  There are approximations though. For example, see the following.

https://www.itl.nist.gov/div898/handbook/prc/section2/prc263.htm

[#5]

thank you!

[#6]

Having one question, seen the old jump have quantile probability pop-up window feature to type probability to get the quantile number. Not seeing it in JUMP 17 any more, can I ask if tolerance interval is the same replacing it?

Hoping to find the matching quantile based on the sigma value provided and corresponding probability.

i.e. 6 sigma (0.999999999), 4.8 sigma (0.999999)

Selecting one-sided, specifying confidence 0.95 and proportion to cover 0.999999999, can I get the corresponding quantile value?

Thanks in advance

[#7]

Basic Analysis > Distributions > Options for Continuous Variables > Tolerance Intervals  

Basic Analysis > Distributions > Additional Examples of the Distribution Platform > Example of Tole...