1

I'm testing the t.test functionality of Excel and when I specify two-sided, paired with two lists of 1,2,3,4,5,6,7 and 2,3,4,5,6,7,8, paired t-test, the p-value returns #DIV/0! I have made sure the cell is formatted as number. As soon as I change the last number 8 of the second list to 9, the result becomes normal.

enter image description here

Stack_Protégé
  • 302
  • 1
  • 15

1 Answers1

0

Thanks to @Axel Richter, the equation for paired student t-test has standard deviation of each paired difference in the denominator. since the difference between each pair is the same, the standard deviation is 0, which makes the denominator 0.

Stack_Protégé
  • 302
  • 1
  • 15