Complete the following:
Q1 - The following table gives information from a sample of college students: gender, number of children in family of origin, and number of children in their ideal family, in which they may someday be a parent.
Gender No. of Children in Family of Origin No. of Children in Ideal Family
|
Gender
|
Origin
|
Ideal
|
|
F
|
2
|
2
|
|
M
|
3
|
2
|
|
M
|
4
|
3
|
|
F
|
2
|
2
|
|
F
|
4
|
3
|
|
M
|
5
|
5
|
|
F
|
3
|
3
|
|
F
|
2
|
3
|
|
F
|
2
|
2
|
|
F
|
4
|
4
|
|
M
|
3
|
3
|
|
F
|
4
|
0
|
|
F
|
3
|
3
|
|
F
|
3
|
4
|
|
F
|
1
|
2
|
|
M
|
2
|
2
|
|
M
|
3
|
3
|
|
M
|
2
|
2
|
|
M
|
1
|
1
|
|
M
|
2
|
0
|
a. Use the scatterplot feature in Excel to determine the relationship between the two variables origin and ideal and discuss any trends.
b. Which variable did you choose for the horizontal axis and which variable did you choose for the vertical axis? Does it matter?
Q2 -The following table of data gives hockey star Eric Lindros' career numbers for the eight seasons he played with the Philadelphia Flyers.
|
Year
|
Games
|
Goals
|
Assists
|
Points
|
|
1993-94
|
65
|
44
|
53
|
97
|
|
1994-95
|
46
|
29
|
41
|
70
|
|
1995-96
|
73
|
47
|
68
|
115
|
|
1996-97
|
52
|
32
|
47
|
79
|
|
1997-98
|
63
|
30
|
41
|
71
|
|
1998-99
|
71
|
40
|
53
|
93
|
|
1999-2000
|
55
|
27
|
32
|
59
|
|
Totals
|
486
|
290
|
369
|
659
|
a. Use the scatterplot feature in Excel to determine the relationship between the two variables games and points and discuss any trends.
b. Which variable did you choose for the horizontal axis and which variable did you choose for the vertical axis? Does it matter?
c. Determine if there appears to be a relationship between goals and assists. What might explain this?
Q3 - One way to find out whether your weight is "reasonable" for your height is to calculate your body mass index (BMI). A BMI of 20 to 25 is normal. BMI is a function of height and weight and is determined as follows: To calculate a person's BMI, divide his or her weight in kilograms by the square of his or her height in meters. (To convert into kilograms, multiply pounds by 0.4536; to convert into meters, multiply inches by 0.0254.) Thus, you can write an equation to calculate BMI:
BMI = 0.4536 * wt. in pounds
(0.0254 * ht. in inches)2
a. Describe how this equation can be used to calculate BMI for a friend who does not understand the description of BMI.
b. Abraham Lincoln was 6 feet 4 inches in height and weighed about180 pounds, according to one historical account. From pictures you have seen of Abraham Lincoln, do you think his BMI would fall in the normal range? Calculate Lincoln's BMI.
c. Find the BMI for a man who weighs the same amount as Lincoln did but who is 5 feet 8 inches tall. Comment on how this compares to Lincoln's BMI.
d. A person who is 5 feet 8 inches tall reduces his or her weight from 200 pounds to 140 pounds. Create a table that contains weights at ten-pound intervals and find this person's BMI at each of those weights. By how much is BMI reduced when weight is reduced from 200 to 170 pounds? By how much is BMI reduced when weight is reduced from 170 to 140 pounds? What can you say about the formula to calculate BMI for fixed height?
Q4 - A student's final grade in a course is often a function of various student performance measures such as homework, class participation, hour exams, and final exam, as well as the weights the professor assigns to each of these measures.
Suppose one professor uses the system:
Final grade = 0.4 * hour exam average + 0.25 * final exam score + 0.25* homework average + 0.1 * class participation grade
A second professor uses the system:
Final grade = 0.6 * hour exam average + 0.15 * final exam score + 0.15* homework average + 0.1 * class participation grade
a. Which professor's grading system would you prefer if your grades were as follows: hour exam average = 84; final exam grade = 68; homework average = 90; class participation grade = 95?
b. If you scored 10 points higher on the final exam, what effect would that have on your final grade under each professor's grading system?
c. If you scored 6 points lower on your hour exam average, what effect would that have on your final grade under each professor's grading system?
d. Suppose you earned the following grades in a class: hour exam average = 78; final exam grade = 88; homework average = 70; class participation grade = 80. What weights would you assign to each of these components to set up a grading system? Assume each component must count for at least 5 percent of the grade (that is, have a weight of at least .05), and explain why you chose the weights you did.
Q5 - The following table gives the percentage of the U.S. population living below the poverty level for the period from 1990 to 2002.
Year Percentage of U.S. Population Living Below Poverty Level
|
Year
|
%
|
|
1990
|
13.5
|
|
1991
|
14.2
|
|
1992
|
14.8
|
|
1993
|
15.1
|
|
1994
|
14.5
|
|
1995
|
13.8
|
|
1996
|
13.7
|
|
1997
|
13.3
|
|
1998
|
12.7
|
|
1999
|
11.8
|
|
2000
|
11.3
|
|
2001
|
11.7
|
|
2002
|
12.1
|
a. Graph out the data using a bar chart or line graph.
b. Do you predict that the poverty rate will increase or decrease in the next several years? Explain which problem-solving technique you used to answer the question.