# Thread: Equation/Formula for Critical Values Table

1. ## Equation/Formula for Critical Values Table

Dear All,

I have looked pretty extensively on the internet for a formula or equation for the Critical Values Tables.

I have a large Excel spreadsheet that in part of its calculations provides 21 Pearson correlations, both to "r" and "t". I need to establish the statistical significance for each Pearson.

I could use a Critical Values Table such as
http://www.unc.edu/~nielsen/soci708/...6e_table-d.pdf,

but having run the spreadsheet to then have to look up 21 results in a table and make a note of each one is not ideal.

I guess I could use a separate sheet, type in the table myself and use "Excel Lookup"s. But again not ideal, especially the memory usage.

Does anybody know the equation/formula used to provide calculate tables either themselves, or an internet site with the details?

2. ## Re: Equation/Formula for Critical Values Table

In excel, you have the function "tdist" for calculating the p-value of the t-test.

In the tail argument, enter 1 or 2 for corresponding 1-tailed/2-tailed test.

3. ## The Following User Says Thank You to BGM For This Useful Post:

chrishb59 (06-17-2011)

4. ## Re: Equation/Formula for Critical Values Table

Thanks BGM,

I was hoping to be able to effectively have a formula/equation to create the Critical Values table.
Something along the lines Cell A1 = DOF, say 10, Cell A2= Confidence Level, say 95. Then cell C1 has the equation to calculate the Critical Value, in this case 2.228.

I will keep hunting the internet.

Thanks again

5. ## Re: Equation/Formula for Critical Values Table

Hi!
It is quite simple: just use TINV funcion in Excel (and enter the DF and alpha level).

Just take a look to the attached .xls file.

Following your attached pdf, the critical values calculated in the .xls file are one-tailed. For two tailed, just remove the multiplying factor (i.e. "*2") from the formula.

Hope this helps
Regards
Gm

6. ## The Following User Says Thank You to gianmarco For This Useful Post:

Dason (06-17-2011)

7. ## Re: Equation/Formula for Critical Values Table

Gianmarco,

Tante grazie.

Perfetto.

8. ## Re: Equation/Formula for Critical Values Table

Ciao,
ogni tanto un compaesano (penso)...

Spero sia stato utile.

Saluti
Gm

9. ## Re: Equation/Formula for Critical Values Table

Originally Posted by chrishb59
Gianmarco,

Tante grazie.

Perfetto.
Awww...now I want to go to Italy.