Many students struggle to find critical values of z, t, and Chi-square for hypothesis tests. No matter how often I show them how to use the StatCrunch calculators to do this, they gravitate back to the tables. And make a lot of mistakes. To help a bit, I have created some Excel calculators that should make it a bit easier. A minimum of data/info is needed to use the calculators. First, you need to know which distribution you need and I have covered this in other posts. For the z, you just need to know alpha and the math operator in the alternative hypothesis. For the t, things get a bit more complicated as you also need to know the sample size(s) and whether or not the variances are assumed to be equal if you are dealing with a two-sample test. I have embedded the Critical Values workbook below.

Note you can use these calculators to find the degrees of freedom for the different tests too.

AjayI want this calculator