Critical values

[Claudio L.]

(06-13-2017 06:28 PM)Claudio L. Wrote:  

(06-12-2017 06:24 PM)ChrisHP Wrote:  Been searching all over, but can't find anything, hope somebody can help.

Can the Prime calculator return the critical values for the PMCC test? E.g. for a sample size of 8 at a conficence level of 95%, the critical value is 0.6215, but I just can't find anyway to get the calculator to tell me that. It must use and calculate such values internally, so how do I get at it?

Thanks

Chris

I believe you are looking for NORMALD_CDF(), or actually 1-NORMALD_CDF(), but in terms of a normal distribution, all you need to do is compute the average and standard deviation, then the value for 95% exceeding (or below) the average is simply A-1.645*d (or A+1.645*d). (here A=average, d=standard deviation of your samples).
In such case you don't need anything special from your calculator. Only if you want to determine where that 1.645 coefficient comes from, or if you need to change the percentile confidence, you would need NORMALD_CDF.

Nevermind - I think you are looking for something entirely different.

Actually, for Paersons you use the STUDENT_ICDF() function to get t for your confidence interval, for example for 95% one-tail and df=10 degrees of freedom (= Nsamples - 2) you do:
t=STUDENT_ICDF(df,0.05)
r=sqrt(t^2/(t^2+df))

And that's the value you'll find on most tables.