I’ve got 2 columns of numbers (showing here in rows):

20 20 30 40 60 30

30 14 34 45 57 20

Running the CHITEST function from menu ( Data / Statistics / Chi-square Test… ) it gives a P value of 0.33.

Running the function manually ( CHITEST(A1:A6, B1:B6) ) gives a P value of 0.03. I can reproduce the difference with other data as well.

I can see that the menu version has more functions in the CHITEST arguments like transpose and others.

Why? What value does CHITEST give this way then?

Thank you.