Question

1. Calculate descriptive statistics for the variable Height by Gender. Sort the data by gender by clicking on Data and then Sort. Copy the heights of the males form the data file into the Descriptive Statistics worksheet of the week 1 Excel file. Type the standard deviations below. These are sample data. Then from the data file, copy and paste the female data into the Descriptive Statistics workbook and do the same.

   Height (inches)
   75
   74
   74
   73
   73
   71
   71
   71
   70
   70
   70
   70
   70
   69
   69
   69
   69
   69
   69
   69
   68
   68
   67
   67
   67
   67
   66
   66
   65
   65
   64
   63
   63
   62
   61

   Gender

   M

   M

   M

   F

   M

   M

   M

   M

   F

   F

   F

   F

   M

   M

   M

   M

   F

   M

   F

   M

   M

   M

   M

   F

   F

   F

   F

   M

   F

   F

   F

   F

   F

   F

   M

Answer 1