| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate and show negative time in Excel? | Excel Worksheet Functions | |||
| Can I calculate negative numbers to = zero in excel? | Excel Discussion (Misc queries) | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
| Formula to calculate only the negative numbers | Excel Worksheet Functions | |||
Threaded Mode
