TTest Function Error Hi: I\'m doing a report for a simple class project, which i

Question

TTest Function Error

Hi: I'm doing a report for a simple class project, which is to test the hypothesis that gender and height are correlated (of course they are, but this is just to demonstrate the point).

One column is gender with letter arguments of either "F" or "M" while the other column has corresponding heights in centimeters (number arguments). I'm trying to use the ttest function to generate a p-value. The function I entered is "=TTEST(A2:A65, B2:B65, 2, 3)" with the A column having the categorical variable F or M, and the B column having the numbers. Yet Excel just keeps returning "#DIV/0!" error. What am I doing wrong? I would greatly appreciate any help. Thanks.

Explanation / Answer

..Hi,

Both arrays must be numerical..<?

You could replace F & M by a numerical value.

=TTEST(CODE(A1:A7),B1:B7,2,3)

CODE will replace F by 70 and M by 77.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.