I have a column in a spreadsheet labled SEX with the value of 1 or 2 for male or female. How do I calculate the average number of males and females? Or should I use a different value to calculate??
DaveSolano
0
Newbie Poster
gerbil
216
Industrious Poster
Total the ones (or the twos) with an IF statement (or both)..
IF(SEX=1;M+1;F+1).
That will give you the ratio of M vs F; ratio of Ms and Fs in population is straightforward from there.
An average does not strictly apply in your case.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.