One sided tolerance interval formulaI 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
Basic Data Analysis and ModelingRe: One sided tolerance interval formulaHave 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 formulaI 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 formulaHi @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 formulathank you!
Re: One sided tolerance interval formulaHaving 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 Basic Analysis > Distributions > Options for Continuous Variables > Tolerance Intervals
Basic Analysis > Distributions > Additional Examples of the Distribution Platform > Example of Tolerance Intervals
