Question
Gender Height Female 65 Male 66 Female 63 Male 70 Female 66 Female 68 Female 61 Male 71 Male 72 Male 75 Female 61 Female
Gender | Height |
Female | 65 |
Male | 66 |
Female | 63 |
Male | 70 |
Female | 66 |
Female | 68 |
Female | 61 |
Male | 71 |
Male | 72 |
Male | 75 |
Female | 61 |
Female | 64 |
Male | 69 |
Female | 63 |
Female | 64 |
Male | 71 |
Female | 64 |
Male | 73 |
Female | 59 |
Compare the heights of students of different genders:
- In cell D1, type "Female" in bold
- In cell E1, type "Male" in bold
- In cell F1, type "Other" in bold
- In cell A1, click the triangle next to "Gender," then select Sort A to Z
- Copy the Female heights to column D
- Copy the Male heights to column E
- Copy the Other heights to column F
- Highlight columns D:F, then select Home > Cell Styles > Normal
- In cell M1, type "Female" in bold
- In cell N1, type "Male" in bold
- Highlight the cell range K2:K12, then fill right to the cell range K2:N12
- Right-click on column L, then select Delete
Among female students, how many low outliers are there?
Among female students, how many high outliers are there?
Among male students, how many low outliers are there?
Among male students, how many high outliers are there?
Make side-by-side box plots of the heights of male and female students:
- Highlight the cell range D1:E290
- Select Insert > Insert Statistic Chart > Box and Whisker
- Enlarge the chart by dragging a corner
- Right-click on the vertical axis, then select Format Axis...
- Set the minimum to 40.0
- Title the chart "Height by Gender"
Are female students taller or shorter than male students, on average?
Group of answer choices
Female students tend to be shorter than male students.
Female students tend to be about the same height as male students.
Female students tend to be taller than male students.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started