The Student Room Group

P-value is greater than 1?

Hi i did an ANOVA test on excel and my p-value is 6.19643045503977E-163, which doesn't make sense as p-value is always between 0 and 1. Does anyone know if i have to divide this number by something to get my actual value or am i doing it wrong on excel?
Original post by escpolina1
Hi i did an ANOVA test on excel and my p-value is 6.19643045503977E-163, which doesn't make sense as p-value is always between 0 and 1. Does anyone know if i have to divide this number by something to get my actual value or am i doing it wrong on excel?


No the p value is the p value and it's less than one because of the negative power so whatever you're looking at is significant.
Reply 2
Original post by alleycat393
No the p value is the p value and it's less than one because of the negative power so whatever you're looking at is significant.


O thank you i get it now :smile:, so i would divide by 10 to the power of 163 to get actual value? In a report can i just write 6.19643045503977E-163?
Original post by escpolina1
O thank you i get it now :smile:, so i would divide by 10 to the power of 163 to get actual value? In a report can i just write 6.19643045503977E-163?


No you don't need to do anything to that value. That is your p value so report it to two decimal places with the 10 power value.
Reply 4
Original post by alleycat393
No you don't need to do anything to that value. That is your p value so report it to two decimal places with the 10 power value.


ok thanks so much :smile:

Quick Reply

Latest