math homeowrk

File

s:

·

HYPERLINK “/bbcswebdav/pid-13209346-dt-content-rid-30383790_2/xid-30383790_2″FPRIVATE “TYPE=PICT;ALT=File”

File

Survey Data for Seminar 2.xls

(36.5 KB)

A survey of Baker College students enrolled in MTH401 (Summer 2013) produced the results shown in the attached Excel spreadsheet. Using the information in the file, create a carefully proofread and grammatically correct Word document that includes the bar graph and answers to the questions below. The rubric that will be used is attached.

1. Using Excel, create a bar graph using the favorite tv sport (x) and the number of respondents (y). Make sure the bar graph is appropriately labeled and titled. Make sure the scale is reasonable. This video may be helpful: http://www.youtube.com/watch?v=_SnskklZ0No (5 points)

a. Appropriately graphed (3 points)

b. Appropriate title (1 point)

c. Appropriate labels (1 point)

2. Using your bar graph, answer the following questions (5 points):

a. Why did you choose the scale you did? (1 points)

b. What is the most popular sport to watch and why? (2 points)

c. What is the least popular sport to watch and why? (2 points)

3. Consider a function, f, whose domain is the set of favorite sports watched on tv and whose range is the number of people who watch those sports. (20 points)

a. Write function f as a set of ordered pairs. Is this relation a function? Explain your answer. (10 points)

b. Write the relation that is the inverse of f as a set of ordered pairs. Is this relation a function? Explain your answer. (10 points)

A survey of Baker College students enrolled in MTH401 (Summer 2013) produced the following results:

Using the information in the excel document, answer the following questions:

1. Using Excel, create a bar graph using the favorite tv sport (x) and the number of respondents (y). Make sure the bar graph is appropriately labeled and titled. Make sure the scale is reasonable. This video may be helpful: http://www.youtube.com/watch?v=_SnskklZ0No (5 points)

o Appropriately graphed (3 points)

o Appropriate title (1 point)

o Appropriate labels (1 point)

Scatterplot

Points Possible

Points Earned

Comments

Appropriately graphed

3

Appropriate title
1

Appropriate label
1

Total
5

2. Using your bar graph, answer the following questions (5 points):
a. Why did you choose the scale you did? (1 points)
b. What is the most popular sport to watch and why? (2 points)
c. What is the least popular sport to watch and why? (2 points)
Scatterplot Analysis

Points Possible

Points Earned

Comments

Why scale chosen?
1

What is the most popular sport and why?
2

What is the most popular sport and why?
2

Total
5

3. Consider a function, f, whose domain is the set of favorite sports watched on tv and whose range is the number of people who watch those sports. (20 points)
a. Write function f as a set of ordered pairs. Is this relation a function? Explain your answer. (10 points)
b. Write the relation that is the inverse of f as a set of ordered pairs. Is this relation a function? Explain your answer. (10 points)
Scatterplot Analysis

Points Possible

Points Earned

Comments

Function of f
2

Is the relation a function?
2

Why or why not (explanation)
6

Inverse of f
2

Is the relation a function?
2

Why or why not (explanation)
6

Total
20

 
 

2

>Sheet

1

/

–

1

Rent

2

Rent

Female

0

2 Football Brown Rent

10

Female

2 None, I don’t watch sports Brown Rent

.5

Female

1 None, I don’t watch sports

Rent

10

Female

1

Brown Rent 60 7

Female

4 None, I don’t watch sports Brown Own 63 9

Female 26-30 3 Football

Own

9

Male

3 None, I don’t watch sports Brown Rent

10

Male 36-40 2 None, I don’t watch sports Brown Rent

10

Female 26-30 3

Blue Rent 63

Female < 25 1 Football Brown Rent 65 Male 31-35 3 Basketball Brown Own

Female < 25 5 Hockey Brown Rent 64 7 Female

3 Hockey Hazel Own

10

Female 36-40 2 None, I don’t watch sports

Own 65 9

Female 36-40 3 Basketball Hazel Own 67 9
Female 26-30 1

Brown Own

10

Female 41-45 3 Football Brown Own 67 9
Male 36-40 1

Brown Rent 69

Female 31-35 5

Brown Own 63 7

Male 26-30 3 Baseball Brown Own

12

Male 36-40 4 Football Blue Own 72

Female 26-30 1 None, I don’t watch sports Brown Rent

9

Female

1 Football Brown Rent 60 10

Female 41-45 2 Football Blue Own 64 7
Male < 25 1 Baseball Blue Own 68 12 Female 31-35 2 None, I don’t watch sports Hazel Rent 69 10
Male 31-35 1 Basketball Blue Rent 68

Male < 25 2 None, I don't watch TV Blue Rent

13

Male 36-40 1 Football Brown Own

8

Male 31-35 2

Brown Own 70 10

Female 36-40 1 None, I don’t watch sports Brown Rent

6

Female < 25 1 Football Hazel Rent 64 8 Female 36-40 0 Hockey Green Own 63 8
Female

4 None, I don’t watch sports Blue Own 64 8

Male 36-40 2 Football Blue Own 74 13
Female < 25 1 Hockey Blue Rent

6

Female 46-50 1 Hockey Blue Rent 64 8
Male 31-35 5 MMA Blue Own

14

Female < 25 2 Baseball Green Own 62 8 Male 26-30 6 Baseball Hazel Own

9

Male 26-30 1 None, I don’t watch sports Blue Own 65 9
Female < 25 1 None, I don't watch sports Brown Rent 68 9 Female 36-40 3 Football Brown Rent 67 10
Female 26-30 3 None, I don’t watch sports Brown Own 69 9
Female 26-30 1 None, I don’t watch sports Hazel Rent 67 8.5
Male 31-35 5 Football Green Own 69 11
Male 36-40 1 None, I don’t watch sports Brown Rent 75 13

Male 36-40 2 None, I don’t watch sports Brown Rent 68 10

Male 26-30 0 Football Brown Rent 74 11

Male 26-30 3 Baseball Brown Own 72 12

Female 31-35 4 Football Brown Rent 64 8
Female 26-30 2 Basketball Brown Rent

5

Female 41-45 4 None, I don’t watch sports Blue Own 65 9
Male < 25 2 None, I don't watch TV Green Rent 64 11 Female 36-40 1 None, I don’t watch sports Brown Rent 52 6
Female 26-30 3 Basketball Brown Rent 52 5
Female 31-35 3 Basketball Brown Own 62 7
Female 36-40 3 Football Green Own 64 10
Female 46-50 1 Basketball Blue Rent 62 8
Female 46-50 1 Football Brown Own 50 7
Female < 25 2 None, I don't watch sports Green Rent

8

Female 31-35 3 Football Brown Own 66 7
Female 26-30 2

Brown Rent 60 5

Female 26-30 4 None, I don’t watch sports Blue Own 64 8
Male 31-35 1 None, I don’t watch sports Blue Own

12

Female 26-30 1 Football Green Own 62 7
Female 41-45 2 Baseball Hazel Own 65 8
Female 36-40 1 None, I don’t watch sports Hazel Rent 65 9

Female 46-50 1 Football Brown Own 50 7

Male 31-35 1 None, I don’t watch sports Brown Own 75 10.5
Female < 25 2 Football Blue Rent 67 9 Male 26-30 0 Football Heterochromian (different colored eyes) Rent 70 12
Female 41-45 1 None, I don’t watch sports Blue Own 66 10
Female 26-30 0 Football Blue Own 68 8
Male 36-40 3 Football Brown Rent

10

Female 31-35 3 Basketball Brown Own 62 7

Male 41-45 5 None, I don’t watch sports Green Rent 71 10
Male 41-45 1 Football Heterochromian (different colored eyes) Own 72 11
Female < 25 2 NASCAR Blue Own 64 11 Female < 25 3 Football Hazel Own 71 9 Male 36-40 0 Football Brown Rent 74 12
Female 31-35 3 Hockey Blue Own 66 9
Male 26-30 1 None, I don’t watch sports Blue Rent 72 13
Female 46-50 1 Hockey Blue Rent 64 8.5
Female 26-30 7 Basketball Green Rent 63 8
Female 46-50 3 Baseball Green Own 63 9
Female < 25 2 Football Brown Rent 65 9 Female 46-50 4 Hockey Hazel Own 66 4
Female 41-45 3 NASCAR Green Own 64 7
Female 26-30 3 Baseball Blue Own 66 9
Female 31-35 5 Hockey Brown Own 65 7

Female 46-50 1 Football Brown Own 50 7

Female 31-35 5 None, I don’t watch sports Brown Own 68 11
Female 26-30 1 Hockey Blue Rent 64 9
Female 26-30 1 Basketball Brown Rent 64 8
Female 26-30 1 Football Blue Rent

8

Female

1 None, I don’t watch sports Blue Own 72 6

Male 26-30 2 Baseball Hazel Own 69 10
Female < 25 2 NASCAR Blue Rent 65 11 Female < 25 1

Brown Rent 61 9

Male 26-30 2 Football Blue Rent 72 13

Gender	Age	# people in household	Favorite TV sport	Eye color																																																					Own																																																			Rent	Height (inches)	Shoe size
																																																																						Female			2					6																						3					0																															Football												Green		6														7																	10
																															Male			31-3										5																													None, I don’t watch sports																																														Brown			75						13
36-								4					67
55-			60															64																					9
																< 25																														Blue							63
																								26-30											Hockey
														31-35
											Hazel										65
																	36-40				6															8
			68
										Basketball			8.5
7.5
			74		14
								41-45						69
		Heterochromian (different colored eyes)
									Baseball			70
WWE							12
		None, I don’t watch TV
						72
							11
					62
55-60
	10.5
73
53
	MMA
			50
								46-50
59
78
					66
		52
56
			NASCAR
76
		71
	61
over 61
Soccer

Sheet2

Sheet3