Equation/Formula for Critical Values Table

[chrishb59]

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?

Thank you in advance.

[BGM]

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.

[chrishb59]

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

[gianmarco]

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

[chrishb59]

Gianmarco,

Tante grazie.

Perfetto.

[gianmarco]

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

Spero sia stato utile.

Saluti
Gm

[Link]

Gianmarco,

Tante grazie.

Perfetto.

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

[gianmarco]

Hi Link,
now I would like to visit San Francisco :-)

Cheers
Gm