Statistics stuff

[scubadiver]

I have survey data and I want to do some T-tests using gender as the
grouping. Since the "gender" column will be mixed up with males and females,
does Excel allow a t-test to be carried in this situation or do the males and
females have to be grouped together?

cheers!

 

[Jerry W. Lewis]

While the TTEST function does not have such options, you can separate your
data in the TTEST call using array formulas, such as
=TTEST(IF(gender="M",data),IF(gender="F",data),2,2)
where gender and data are the ranges containing the specified information.
This formula must be array entered (Ctrl-Shift-Enter) to work; otherwise it
will return #VALUE!

Jerry

 

[ufo_pilot]

That depends on how you need the data presented.
you could click and scroll down the ROW HEADERS then sort by alpha,
so that you have two defined groups, Female and Male.
which could be represented in two identical charts, one for each group...