T-test error

Copper Contributor

Hello,

 

Im trying to work on a group of data using a T-test and I continue to get some sort of error in the results. To be a bit more specific, I have two colums, one corresponds to a control group for wich I have 1603 values and the group with no control has 538 values.

I enter the formula and select the cels =T.TEST(Z2:Z1604,AA2:AA539,1,3) and my result is p= 3.18E-141

What does E-141 mean? Aditionally, I have tried to use the same amount of values for each side (example: Array 1 and Array 2: 538 cels selected for each colum) and I continue to get the E-141 as part of the result.

 

Thank you in advance for your help!

 

0 Replies