calculate the p-value for a negative t-value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(x>0,TDIST(x,deg_freedom,tails),(1-(TDIST(ABS(x),deg_freedom,tails))))
 
Camper -

Here are some excerpts from my book, "Data Analysis Using Microsoft Excel:
Updated for Office XP":

Left-Tail Test
p-value =IF(t<0,TDIST(ABS(t),df,1),1-TDIST(t,df,1))

Right-Tail Test
p-value =IF(t>0,TDIST(t,df,1),1-TDIST(ABS(t),df,1))

Two-Tail Test
p-value =TDIST(ABS(t),df,2)

- Mike
www.mikemiddleton.com
 
Aloha Mike,

That answers my question and is exactly what I needed. Mahalo for the
reference to the book. I will have to track down a copy for my
library/reference collection.
--
Mahalo for your help,
Camper


Mike Middleton said:
Camper -

Here are some excerpts from my book, "Data Analysis Using Microsoft Excel:
Updated for Office XP":

Left-Tail Test
p-value =IF(t<0,TDIST(ABS(t),df,1),1-TDIST(t,df,1))

Right-Tail Test
p-value =IF(t>0,TDIST(t,df,1),1-TDIST(ABS(t),df,1))

Two-Tail Test
p-value =TDIST(ABS(t),df,2)

- Mike
www.mikemiddleton.com

Camper said:
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(x>0,TDIST(x,deg_freedom,tails),(1-(TDIST(ABS(x),deg_freedom,tails))))
Click to expand...
Click to expand...
 
Back
Top