Suppose you have a random sample of people, with the sex, height, and weight of each person. ○ Leave the names unsorted, and set up a spreadsheet to calculate the average height and weight for men and women. ○ Use Data/Sort to separate the two sexes. Problem #4 - data Observation Sex Height (ft) Weight (lb) Observation Sex Height (ft) Weight (lb) 1 M 6.1 185 11 M 5.9 166 2 M 5.8 175 12 F 5.4 123 3 F 5.2 125 13 M 5.75 160 4 M 5.7 180 14 F 5.1 110 5 F 4.9 110 15 F 5 122 6 F 5.5 135 16 M 6.3 240 7 F 5.4 150 17 F 5.25 150 8 M 6.2 210 18 F 5.35 136 9 F 5.3 140 19 M 6.25 198 10 M 6 205 20 M 5.6 187
Unlock access to this and over
10,000 step-by-step explanations
Have an account? Log In