View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Camper
 
Posts: n/a
Default calculate the p-value for a negative t-value

My question is how can I calculate a p-value for a negative t-value?

In several tests the t-test value is negative and I cannot use the standard
TDIST(x,df,1) function. Is it correct to calculate the p-value of negative
t-values as:
1 - absolute(P[x])?

If the above is correct, is this the correct adaption to the TDIST function:
=IF(x0,TDIST(x,deg_freedom,tails),(1-(TDIST(ABS(x),deg_freedom,tails))))

--
Mahalo for your help,
Camper