Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

  1. In cell D1, type "Female" in bold
  2. In cell E1, type "Male" in bold
  3. In cell F1, type "Other" in bold

  1. In cell A1, click the triangle next to "Gender," then select Sort A to Z
  2. Copy the Female heights to column D
  3. Copy the Male heights to column E
  4. Copy the Other heights to column F
  5. Highlight columns D:F, then select Home > Cell Styles > Normal

  1. In cell M1, type "Female" in bold
  2. In cell N1, type "Male" in bold
  3. Highlight the cell range K2:K12, then fill right to the cell range K2:N12
  4. 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:

  1. Highlight the cell range D1:E290
  2. Select Insert > Insert Statistic Chart > Box and Whisker
  3. Enlarge the chart by dragging a corner
  4. Right-click on the vertical axis, then select Format Axis...
  5. Set the minimum to 40.0
  6. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Mathematical Analysis

Authors: Charles C Pugh

2nd Edition

3319177710, 9783319177717

More Books

Students also viewed these Mathematics questions

Question

Were multiple treatments used? Did they interfere with each other?

Answered: 1 week ago