Home

T-test error

alphaelement
Occasional Visitor

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!

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies