Description: This lab is designed to teach students to find descriptive statisti
ID: 3204661 • Letter: D
Question
Description:
This lab is designed to teach students to find descriptive statistics by using Excel. Students are also expected to describe the distribution of the data by interpreting the descriptive statistics.
Question 1:
The data from Excel table “Question 1” give the heights of 18 male college students and their fathers, in inches.
(a) Use Excel functions to find descriptive statistics and fill in the table “Descriptive Statistics” in “Question 1” sheet from Excel “Lab 1” file.
(b) Compare the heights of the sons and their dads, using the means and standard deviations.
(c) Compare the heights of the sons and their dads, using the medians and interquartile ranges.
(d) Which pair of statistics is more appropriate for comparing these samples: the mean and standard deviation or the median and interquartile range? Explain
Instruction:
STEP 1: Open the excel file “Lab 1” in the Blackboard. Click on “Question 3” Sheet.
STEP 2: Use Excel descriptive statistics functions to find Mean, Median, Standard Deviation and Interquartile range. Then fill the “descriptive statistics” table and insert the table to your lab report. For Interquartile Range, use the formula =QUARTILE(data range, 3) – QUARTILE(data range, 1).
STEP 3: Using Means and Standard Deviations to compare the heights of the sons and their dads. Explain your answers in the lab report.
STEP 4: Using Median and Interquartile Range to compare the heights of the sons and their dads. Explain your answers in the lab report.
STEP 5: Explain which pair of statistics is more appropriate for the comparison.
Question 2:
The “Question 2” data give the number of hurricanes classified as major hurricanes in the Atlantic Ocean each year from 1944 through 2010, as reported by NOAA.
(a) Compute the Mean, Standard Deviation, Median and IQR for the data
(b) Compare the Mean and Median, what will you comment on the shape of the distribution?
Son's Height Dad's Height 74 70 70 65 71 71 Descriptive Statistics 63 60 Mean Median Standard deviation Interquartile range 66 65 Sons 69 68 Dads 63 64 70 69 70 72 68 65 68 65 73 70 68 64Mean 72 70 68 67 72 70 71 69 71 71 Median Standard Deviation Interquartile Range Hurricanes (1944 - 2006) 3 3 Descriptive Statistics 1 Mean Median Standard deviation Interquartile range 2 Hurricanes 4 3 8 5 3 4 2 6 2 2 4 2 2 7 1 2 6 1 3 1 0 5 2 1 0 1 2 3 2 1 2 2 2 3 1 1 1 3 0 1 3 2 1 2 1 1 0 5 6 1 3 5 3 4 2 3 6 7 2 2 5 2 5 Mean St Dev Median IQR
Explanation / Answer
Question 1:
Following table shows the descriptive statistics:
STEP 3: Using Means and Standard Deviations to compare the heights of the sons and their dads. Explain your answers in the lab report.
Mean height of Son's height is greater than mean height of Dad's height. While standrad deviation is less for Son's height in comparison to Dad's height.
STEP 4: Using Median and Interquartile Range to compare the heights of the sons and their dads. Explain your answers in the lab report.
Median height of Son's height is greater than median height of Dad's height. While interquartile range is less for Son's height in comparison to Dad's height.
That is distribution of Son's height has less variation in comaprison to distribution of Dad's height.
STEP 5: Explain which pair of statistics is more appropriate for the comparison.
Since mean and median are not same for the distribution so we can assume that distribution are symmetric. Therefore median and interquratile range are more appropriate to describe the distribtuion.
Descriptive statistics Son's Height Dad's Height count 18 18 mean 69.28 67.50 sample standard deviation 3.04 3.26 sample variance 9.27 10.62 minimum 63 60 maximum 74 72 range 11 12 1st quartile 68.00 65.00 median 70.00 68.50 3rd quartile 71.00 70.00 interquartile range 3.00 5.00 mode 68.00 70.00 low extremes 0 0 low outliers 2 0 high outliers 0 0 high extremes 0 0