Plotting Scatter graph & Line graph

Topic 2, Problem 5 - 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 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 scatter plot 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?

Topic 2, Problem 6 - 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?

Topic 10, Problem 2 - The following table gives the percentage of the U.S. population living below the poverty level for the period from 1990 to 2002.

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.

See attached document.