In this proble, my p value is getting 1.71E-45 in the google sheet, after converting to number format, it gets 0. I check the T.test formula and I can’t find which part is wrong. Can you help me find the problem of my p value?
Hi @Miyato22
Your formula is correct, the very small p-value you got simply gets rounded to 0 because Google Sheets can’t display such tiny numbers in regular format. You can switch the cell format to Scientific notation or use =TEXT(cell, "0.000E+00") to see the actual value, and double-check that only numeric data (no headers) are included in both ranges.
Hope it helps! Feel free to ask if you need further assistance.
4 Likes
Thank you, I have changed the cell format to Scientific notation and it shows the actual value. Thanks a lot. Your comment really helps
1 Like
You’re welcome, happy to help 