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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how can I get a corresponding T-score for a P-value in excel? (https://www.excelbanter.com/excel-worksheet-functions/141985-how-can-i-get-corresponding-t-score-p-value-excel.html)

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

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

Which command in excel can be used?

Teethless mama

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

Need more detail...

"DQ" wrote:

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

Which command in excel can be used?

ryguy7272

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

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?

--
RyGuy

"DQ" wrote:

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

Which command in excel can be used?

All times are GMT +1. The time now is 05:48 AM.