Question

use the numbers on excel

6.2.13 In Exercise 6.2.8, we presented height data that were self-reported by female undergraduate engineering students in a core course at ASU. In the same class, the male students self-reported their heights as follows. Construct a comparative stem-and-leaf diagram by listing the stems in the center of the display and then placing the female leaves on the left and the male leaves on the right. Comment on any important features that you notice in this display. 69 67 69 70 65 68 69 70 71 69 66 67 69 75 68 67 68 69 70 71 72 68 69 69 70 71 68 72 69 69 68 69 73 70 69 71 67 68 68 69 70 73

Answer 1

The back to back stemplot is obtained in excel by following these steps,

Step 1: Write the data values in excel. The screenshot is shown below

А 1 Male в Female 69 67 n л

Step 2: Sort the data values for both male and female

Select the data values then DATA > Sort > OK. then Select Sort by: Treatment, Sort On: Values, Order: Smallest to Largest.

Step 3: Make a stem as shown below,

Stem
65
66
67
68
69
70
71
72
73
74
75

Step 4: Write the decimal 0 values in front of the corresponding stem value. The screenshot for the plot is shown below,

Female Male o Stem 65 66 0 ооо 69 o o o o o o o o o o o o o o o o o o o o o o o o 0 o o o o o o о 0 о о o o o o o o о 0 оооооо o o o o o o o o o ooo ооо о o o o o o o o o o 73 74 75

The distribution of the height data for both male and female is slightly skewed to right (positively skewed).