Thread: how can I get a corresponding T-score for a P-value in excel?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
  
Posts: 2,836
Default 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?
Reply With QuoteReply With Quote