how can I get a corresponding T-score for a P-value in excel?

D

DQ

I have bunch of P-values. I would like to have their corresponding P-values.

Which command in excel can be used?
 
R

ryguy7272

Tools > Data Analysis > Anova: Two-Factor With Replication. After you have
created your Anova table, select a cell somewhere below the table and enter a
simple formula such as this:
=(Upper 95%-Coefficients)/Standard Error.

Does this give you what you want?
 
Top