Log-in | Contact Jeff | Email Updates

Question 411:



No answer provided yet.

You can find the critical values of significance levels using excel and this depends on the type of critical value. For the z-critical value you'd use =NORMSINV() function. For example, the critical z-value for the common two sided .05 level is =NORMSINV(1-(0.05/2)), which will provide the result of 1.959

For the t-critical value, you can use the Excel formula, =TINV(). You need to know your sample size. For example, at the typical .05 alpha level and for a sample size of 20, you'd use the formula =TINV(0.05,19). Enter 1 less than the sample size, which are the degrees of freedom. You then get 2.086

Not what you were looking for or need help?

Ask a new Question

Browse All 869 Questions

Search All Questions: