topic One sided tolerance interval formula in Discussions

One sided tolerance interval formula

BetaBiasOx911 — Mon, 14 Apr 2025 16:38:08 GMT

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

Re: One sided tolerance interval formula

jthi — Mon, 14 Apr 2025 16:57:11 GMT

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.

Re: One sided tolerance interval formula

BetaBiasOx911 — Mon, 14 Apr 2025 18:07:06 GMT

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.

Re: One sided tolerance interval formula

MRB3855 — Mon, 14 Apr 2025 18:47:15 GMT

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

Re: One sided tolerance interval formula

BetaBiasOx911 — Wed, 16 Apr 2025 12:09:56 GMT

thank you!

Re: One sided tolerance interval formula

SignalRaccoon27 — Thu, 07 Aug 2025 14:38:22 GMT

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

Re: One sided tolerance interval formula

jthi — Thu, 07 Aug 2025 15:02:47 GMT

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

Basic Analysis > Distributions > Additional Examples of the Distribution Platform > Example of Tolerance Intervals