Math 221 WEEK 2 LAB Assignment Statistics

Question # 00032570 Posted By: spqr Updated on: 11/20/2014 01:38 PM Due on: 12/12/2014
Subject Mathematics Topic General Mathematics Tutorials:
Question
Dot Image
FHEALTH

The required values for this lab can be computed by using either (or both) Excel and/or the TI calculator.
The required graphs can be created by either (or both) Excel and/or hand-drawing.
All answers must be entered on this document. Cutting and Pasting from Excel is one very acceptable
method to enter the answers into this Word document. The finished document can be submitted in either
electronic form to the drop box (for the Week 2) or in hard-copy form during class.

Part 1. Data Analysis for AGE variable.
Open in the Excel File called FHEALTH
AGE variable.

WEEK 2.xlsx and compute the requested values for the

1.

Find the sample mean.
Sample mean = ________________________

2.

Find the sample standard deviation.
Sample Standard Deviation = ______________________

3.

Make a frequency distribution for the data. Start this distribution with a lower class limit of 10 and
make each class width 10.

4.

Create and insert a histogram for the data.

5.

Does the histogram appear to be bell-shaped?

6.

Find the median.
Median = _______________________

7.

Find the maximum and the minimum value.
Minimum value = ________________________
Maximum value = _______________________

8.

What is the range?
Range = ___________________________

1

9.

What is the first Quartile?
Q1 = ________________________

10.

What is the second Quartile? (What is this also called?)
Q2 = ______________________
Q2 is also called __________________________

11.

What is the third Quartile?
Q3 = ________________________

12.

What is the Interquartile Range, IQR?
IQR = ___________________

13.

What is the 80th percentile?
P80 = __________________________

14a.

Starting from the mean value, compute the values that are +/- one standard deviation from the
mean.

__________________________
__________________________
14b.

Count the number of data values that are between these two computed numbers (from 14a).
Number of data values within 1 standard deviation of mean = ____________________

14c.

This counted number corresponds to what percent of the total data values?
Percent of data values within 1 standard deviation of mean = ______________________

14d.

Does this percent agree with the Empirical Rule? Explain why or why not.

15a.

Starting from the mean value, compute the values that are +/- two standard deviations from the
mean.
__________________________
__________________________

15b.

Count the number of data values that are between these two computed numbers (from 15a).
Number of data values within 2 standard deviations of mean = ______________________

15c.

This counted number corresponds to what percent of the total data values?
Percent of data values within 2 standard deviations of mean = ________________________

15d.

Does this percent agree with the Empirical Rule? Explain why or why not.

16a.

Both the mean and the median are measures of central tendency. Both of these values were
computed above. In this case, does one measure have any benefits over the other in describing
the center of the distribution? Does a comparison of these two values provide additional information about the shape of the distribution?

16b.

Similarly, both the standard deviation and the IQR are measures of variation. Both of these values
were computed above. In this case, does one measure have any benefits over the other in describing the spread of the data? Does a comparison of the two values for Q 1 and Q3 (used to
compute the IQR) provide additional information about the shape of the distribution?

2

Part 2. Data Analysis for WT variable.
Open in the Excel File called FHEALTH
variable. This is the weight variable.

WEEK 2.xlsx and compute the requested values for the WT

1.

Find the sample mean.
Sample mean = ________________________

2.

Find the sample standard deviation.
Sample Standard Deviation = _____________________

3.

Make a frequency distribution for the data. Start this distribution with a lower class limit of 75 and
make each class width 25.

4.

Create a histogram for the data.

5.

Does the histogram appear to be bell-shaped?

6.

Find the median.
Median = _________________________

7.

Find the maximum and the minimum value.
Minimum value = _________________________
Maximum value = _________________________

8.

What is the range?
Range = ______________________

9.

What is the first Quartile?
Q1 = ________________________

10.

What is the second Quartile? (What is this also called?)
Q2 = _______________________
Q2 is also called ________________

11.

What is the third Quartile?
Q3 = _____________________

12.

What is the Interquartile Range, IQR?
IQR = _____________________

13.

What is the 80th percentile?
P80 = ______________________

14a.
Starting from the mean value, compute the values that are +/- one standard deviation from the
mean.
_____________ = ________
_____________ = ________

3

14b.

Count the number of data values that are between these two computed numbers (from 14a).
Number of data values within 1 standard deviation of mean = ___________________

14c.

This counted number corresponds to what percent of the total data values?
Percent of data values within 1 standard deviation of mean = ____________________

14d.

Does this percent agree with the Empirical Rule? Explain why or why not.

15a.

Starting from the mean value, compute the values that are +/- two standard deviations from the
mean.
____________________
____________________

15b.

Count the number of data values that are between these two computed numbers (from 15a).
Number of data values within 2 standard deviations of mean = ______________________

15c.

This counted number corresponds to what percent of the total data values?
Percent of data values within 2 standard deviations of mean = _______________________

15d.

Does this percent agree with the Empirical Rule? Explain why or why not.

16a.

Both the mean and the median are measures of central tendency. Both of these values were
computed above. In this case, does one measure have any benefits over the other in describing
the center of the distribution? Does a comparison of these two values provide additional information about the shape of the distribution?

16b.

Similarly, both the standard deviation and the IQR are measures of variation. Both of these values
were computed above. In this case, does one measure have any benefits over the other in describing the spread of the data? Does a comparison of the two values for Q 1 and Q3 (used to
compute the IQR) provide additional information about the shape of the distribution?

4

Part 3. Random Sampling for AGE Variable
Create a simple random sample of size 20 from the
ferent individuals.

AGE variable. Be sure to have the ages for 20 dif-

1.

What method did you choose to randomly select 20 different individuals to get their ages?

2.

Did you have any duplicate observations in your data? If yes, what actions did you take?

3.

List the age data you generated for the all 20 individuals.

4a.

What is the mean age for this simple random sample of 20 individuals?
Mean = ____________________________

4b.

How does the mean age from 4a compare with the mean age from the Part 1 mean age?
Mean age from Part 1 Number 1 = _________________
Mean age from Part 3 Number 4a = __________________

4c.

Comment on the values from 4b above. For example, are they close, why are they different, etc..

Dot Image
Tutorials for this Question
  1. Tutorial # 00031940 Posted By: spqr Posted on: 11/20/2014 01:39 PM
    Puchased By: 2
    Tutorial Preview
    The solution of Math 221 WEEK 2 LAB Assignment Statistics...
    Attachments
    Math_221_WEEK_2_LAB_Assignment_Statistics_Solution.doc (103.5 KB)

Great! We have found the solution of this question!

Whatsapp Lisa