moving data from Spreadsheet into 2-Var based on a category

[mbeddo]

I have data in the Spreadsheet app (circumference of wrist in inches, height in inches, gender) and I'd like to do 2-Var stats using wrist and height values, but grouped by gender. I'd like to copy wrist values for males in C1, height values for males in C2, and wrist values for females in C3, and height values for females in C4. This way, I can do 2-Var stats on males and females separately.

But I'm stuck on how to do this copy/filter operation. Conceptually, I want something like "insert wrist values into C1 if gender is male", and so on. I'd like to avoid sorting the spreadsheet by gender, then copying cell regions from the Spreadsheet into 2-Var using the Home view. A program to do this would be cool (I'd learn a lot).

The wrist/height/gender columns contain:

Code:


6.5    69.5    "M"
6.5    72.25    "M"
6.5    67    "M"
6.25    62.5    "F"
7    73.25    "M"
6.75    66.75    "M"
5.75    61.5    "F"
6.75    63    "F"
6.5    65    "M"
7.25    65.75    "F"
6    68.5    "F"
7    68    "F"
6.5    66.25    "F"
6.75    71.5    "M"
6    63    "F"
5.8    64.25    "F"
6    66    "F"
6.25    67.25    "M"
6.5    67.75    "F"
6.75    63.5    "F"
7.5    71.5    "M"
7.25    67.5    "M"