Advanced Excel (Statistics)

profileguevara
BA3010Assignment1.xlsx

Name

Assignment completed by:

If you worked in groups, ALL group members MUST have place their names on this page. Then EACH group member should submit the homework.

Q1

Data on Various Household Financial Variables
Household Family_Size Location
Christopher J. Zappe, Ph.D.: Location of residence within the given city: 1=SW sector, 2=NW sector, 3=NE sector, and 4=SE sector.
Ownership
Christopher J. Zappe, Ph.D.: 0= rent home (house or apartment) or 1= own home.
First_Income
Christopher J. Zappe, Ph.D.: Annual income of first household wage earner.
Second_Income
Christopher J. Zappe, Ph.D.: Annual income of second household wage earner (if applicable).
Monthly_Payment
Christopher J. Zappe, Ph.D.: Monthly home mortgage payment or rent payment.
Utilities
Christopher J. Zappe, Ph.D.: Average monthly expenditure on utilities.
Debt
Christopher J. Zappe, Ph.D.: Total indebtedness (excluding home mortgage) in dollars.
Age
Michael H. Way: Age of the "head" of the household: young adult (20-39); middle-age (40-59); senior (60 and older).
1 2 2 1 $58,206 $38,503 $1,585 $252 $5,692 Middle-Age
2 6 2 0 $48,273 $29,197 $1,314 $216 $4,267 Young Adult
3 3 4 0 $37,582 $28,164 $383 $207 $2,903 Senior
4 1 1 1 $56,610 $1,002 $249 $3,896 Middle-Age
5 3 3 0 $37,731 $21,454 $743 $217 $3,011 Young Adult
6 4 1 0 $30,434 $26,007 $991 $208 $3,718 Senior
7 1 1 1 $47,969 $849 $243 $5,907 Young Adult
8 1 1 1 $55,487 $752 $242 $2,783 Young Adult
9 3 2 1 $59,947 $1,498 $256 $6,275 Middle-Age
10 6 1 0 $36,970 $31,838 $991 $222 $4,845 Middle-Age
11 1 1 1 $53,113 $1,163 $251 $5,267 Young Adult
12 3 4 0 $27,350 $20,969 $619 $209 $2,256 Senior
13 1 1 1 $48,064 $1,434 $250 $3,918 Middle-Age
14 2 4 0 $29,692 $20,617 $997 $190 $879 Young Adult
15 4 4 1 $25,853 $948 $254 $4,606 Young Adult
16 3 1 1 $49,728 $1,378 $272 $5,427 Young Adult
17 2 3 0 $49,883 $29,240 $902 $201 $3,482 Young Adult
18 4 1 1 $46,265 $1,626 $256 $6,658 Senior
19 2 1 1 $49,809 $834 $253 $4,234 Young Adult
20 4 4 1 $43,640 $729 $259 $5,393 Young Adult
21 1 1 1 $57,395 $1,473 $248 $4,456 Young Adult
22 1 3 1 $52,847 $1,038 $245 $3,999 Senior
23 2 2 1 $59,486 $933 $251 $2,598 Young Adult
24 4 2 1 $57,577 $52,088 $903 $255 $6,261 Middle-Age
25 1 2 1 $63,825 $1,346 $250 $5,402 Young Adult
26 3 1 0 $66,868 $57,974 $574 $202 $3,911 Young Adult
27 2 2 1 $48,376 $39,894 $1,407 $257 $5,889 Middle-Age
28 4 4 1 $33,646 $606 $264 $4,275 Middle-Age
29 3 2 1 $65,241 $47,205 $699 $254 $5,737 Senior
30 3 1 1 $34,531 $21,536 $988 $264 $5,538 Young Adult
31 3 4 0 $18,846 $12,196 $746 $214 $1,852 Middle-Age
32 3 1 1 $49,181 $35,091 $1,510 $264 $7,020 Young Adult
33 4 2 1 $65,276 $61,140 $1,091 $261 $7,212 Young Adult
34 2 4 0 $23,597 $20,798 $402 $211 $1,796 Middle-Age
35 5 3 0 $28,851 $22,682 $696 $225 $3,452 Middle-Age
36 3 2 1 $62,276 $31,231 $1,548 $249 $6,428 Senior
37 4 1 1 $42,639 $32,912 $919 $258 $4,469 Middle-Age
38 2 2 1 $35,592 $23,074 $1,669 $245 $5,516 Middle-Age
39 3 1 1 $49,777 $27,773 $1,049 $256 $5,239 Young Adult
40 3 4 1 $21,451 $13,309 $493 $259 $3,731 Young Adult
41 7 3 1 $37,808 $28,022 $722 $286 $7,228 Middle-Age
42 3 1 1 $56,375 $881 $261 $3,441 Middle-Age
43 5 2 1 $67,798 $33,945 $1,424 $264 $6,067 Middle-Age
44 1 1 1 $29,805 $1,161 $253 $5,462 Young Adult
45 1 4 0 $35,289 $457 $192 $1,734 Young Adult
46 5 2 1 $63,354 $52,656 $1,458 $277 $6,153 Middle-Age
47 2 3 0 $30,693 $23,046 $977 $199 $3,763 Young Adult
48 2 2 1 $68,806 $1,453 $251 $4,930 Young Adult
49 1 2 1 $66,770 $1,658 $257 $6,025 Middle-Age
50 1 2 1 $59,321 $1,664 $247 $5,314 Young Adult
51 4 2 1 $49,954 $30,758 $1,062 $260 $5,179 Middle-Age
52 2 2 1 $55,752 $37,404 $1,660 $253 $5,768 Senior
53 5 3 0 $43,436 $21,855 $699 $215 $2,767 Middle-Age
54 5 3 1 $36,780 $21,609 $573 $279 $5,311 Young Adult
55 3 1 0 $64,489 $43,448 $748 $207 $3,934 Young Adult
56 2 1 1 $30,433 $23,929 $1,318 $244 $4,648 Young Adult
57 5 4 0 $20,234 $17,507 $572 $223 $3,030 Middle-Age
58 2 3 1 $32,848 $720 $254 $4,113 Middle-Age
59 2 4 0 $16,252 $11,539 $669 $206 $1,428 Senior
60 3 2 1 $75,225 $71,930 $1,272 $260 $6,434 Young Adult
61 2 3 1 $38,838 $36,513 $1,084 $247 $4,428 Senior
62 3 2 1 $60,993 $44,220 $1,476 $257 $6,675 Middle-Age
63 2 1 0 $31,051 $26,520 $1,033 $195 $1,821 Senior
64 1 1 1 $43,847 $847 $244 $4,264 Middle-Age
65 1 3 1 $39,862 $1,472 $250 $4,809 Young Adult
66 2 4 0 $27,222 $17,215 $520 $201 $3,705 Middle-Age
67 2 4 0 $27,651 $18,644 $501 $195 $3,661 Young Adult
68 3 2 1 $53,650 $50,636 $1,292 $259 $7,043 Young Adult
69 5 1 0 $42,168 $39,108 $490 $221 $1,739 Senior
70 4 3 1 $36,472 $33,832 $1,435 $260 $5,895 Senior
71 2 2 1 $66,346 $1,914 $247 $6,584 Middle-Age
72 4 1 1 $63,572 $54,048 $1,123 $249 $6,165 Middle-Age
73 2 3 1 $50,233 $39,539 $1,293 $259 $7,177 Middle-Age
74 3 4 0 $35,466 $28,368 $776 $212 $3,949 Middle-Age
75 2 2 1 $77,892 $74,072 $875 $246 $6,309 Young Adult
76 4 2 1 $53,117 $48,393 $1,534 $254 $6,956 Middle-Age
77 4 2 1 $56,310 $41,558 $1,283 $261 $7,363 Senior
78 3 1 1 $58,563 $43,579 $1,138 $272 $4,848 Senior
79 2 3 1 $33,105 $976 $249 $3,634 Senior
80 4 1 1 $34,259 $28,438 $1,302 $251 $5,235 Young Adult
81 1 2 1 $26,910 $1,028 $244 $3,752 Middle-Age
82 5 3 1 $36,065 $28,020 $640 $278 $5,430 Middle-Age
83 2 2 1 $56,330 $54,315 $989 $254 $5,429 Young Adult
84 2 1 1 $54,863 $41,329 $1,751 $245 $6,172 Middle-Age
85 5 3 1 $48,304 $752 $265 $5,131 Young Adult
86 3 4 0 $36,373 $32,341 $428 $207 $3,187 Senior
87 5 1 0 $60,940 $57,432 $888 $218 $2,615 Middle-Age
88 3 1 1 $53,249 $39,777 $1,469 $254 $7,415 Young Adult
89 2 2 1 $59,064 $53,545 $943 $255 $4,752 Young Adult
90 3 4 0 $32,061 $27,840 $577 $202 $983 Young Adult
91 1 4 1 $27,377 $815 $254 $3,233 Middle-Age
92 2 2 0 $48,232 $30,728 $1,134 $199 $3,285 Middle-Age
93 3 2 1 $62,280 $52,654 $1,278 $259 $4,497 Middle-Age
94 3 3 1 $37,184 $27,569 $1,014 $265 $5,736 Young Adult
95 2 2 1 $64,154 $1,088 $259 $5,048 Middle-Age
96 2 2 1 $86,398 $43,989 $1,137 $241 $6,145 Middle-Age
97 6 4 1 $41,335 $959 $278 $6,188 Middle-Age
98 4 2 1 $62,522 $55,855 $831 $265 $7,345 Young Adult
99 3 3 0 $41,490 $35,158 $578 $205 $3,144 Senior
100 6 2 1 $45,391 $30,121 $1,040 $275 $5,991 Senior
101 2 2 1 $39,367 $1,233 $245 $3,895 Young Adult
102 1 1 1 $75,865 $1,078 $239 $5,288 Middle-Age
103 2 4 0 $36,588 $30,278 $602 $202 $1,800 Senior
104 2 3 0 $48,726 $48,694 $622 $203 $3,120 Young Adult
105 3 1 1 $75,208 $1,503 $254 $6,411 Senior
106 4 2 0 $38,740 $24,806 $568 $208 $2,584 Young Adult
107 4 4 0 $26,219 $16,165 $530 $211 $3,309 Middle-Age
108 2 4 1 $32,806 $771 $242 $4,410 Middle-Age
109 4 1 1 $46,667 $29,334 $1,250 $255 $5,735 Middle-Age
110 4 2 1 $65,115 $53,755 $1,300 $259 $5,481 Young Adult
111 3 3 0 $40,397 $31,725 $576 $214 $2,916 Middle-Age
112 2 1 0 $65,601 $54,278 $992 $201 $2,671 Middle-Age
113 1 1 0 $43,657 $848 $191 $4,311 Middle-Age
114 1 3 1 $37,523 $1,829 $250 $5,117 Middle-Age
115 3 2 1 $73,734 $73,481 $1,731 $264 $4,112 Senior
116 3 3 1 $58,580 $51,488 $670 $261 $3,671 Young Adult
117 3 1 1 $55,806 $37,384 $1,676 $257 $6,247 Middle-Age
118 1 3 1 $31,400 $1,030 $246 $4,726 Middle-Age
119 3 3 1 $48,455 $31,331 $635 $270 $5,719 Middle-Age
120 2 1 1 $40,858 $34,114 $1,049 $247 $5,212 Senior
121 2 2 1 $59,737 $59,510 $1,588 $254 $5,924 Young Adult
122 1 4 0 $24,478 $989 $196 $2,871 Middle-Age
123 4 4 0 $36,395 $27,650 $655 $215 $3,067 Senior
124 3 2 1 $42,843 $36,965 $1,500 $261 $4,963 Young Adult
125 5 4 0 $21,557 $14,322 $658 $217 $2,606 Middle-Age
126 3 3 0 $37,186 $24,577 $689 $204 $2,759 Young Adult
127 1 3 0 $34,806 $681 $207 $2,592 Young Adult
128 2 3 1 $35,479 $21,271 $964 $255 $3,933 Young Adult
129 6 4 0 $30,584 $17,372 $586 $223 $4,229 Middle-Age
130 1 1 1 $52,448 $1,121 $248 $5,412 Young Adult
131 5 1 1 $39,096 $37,336 $1,203 $263 $6,631 Young Adult
132 5 4 0 $24,128 $13,889 $762 $216 $2,812 Senior
133 1 4 0 $46,342 $560 $201 $2,792 Middle-Age
134 3 4 0 $23,302 $20,987 $626 $223 $2,961 Senior
135 1 4 1 $39,578 $953 $239 $3,863 Senior
136 2 2 1 $49,132 $36,007 $2,171 $250 $6,796 Young Adult
137 2 2 1 $56,838 $32,021 $810 $252 $5,963 Middle-Age
138 4 2 1 $61,955 $57,445 $1,460 $253 $6,727 Middle-Age
139 1 1 1 $71,211 $1,514 $253 $5,135 Young Adult
140 1 4 0 $28,837 $569 $202 $1,552 Middle-Age
141 5 3 0 $34,354 $22,543 $778 $228 $5,593 Middle-Age
142 4 4 0 $24,442 $12,940 $558 $205 $2,013 Senior
143 5 4 0 $22,259 $19,683 $680 $223 $2,408 Middle-Age
144 6 1 1 $48,910 $40,063 $1,007 $268 $6,810 Middle-Age
145 1 4 0 $25,713 $814 $191 $2,163 Young Adult
146 3 4 1 $22,991 $14,387 $1,252 $257 $4,661 Young Adult
147 2 2 1 $84,820 $70,096 $1,467 $245 $6,661 Young Adult
148 1 4 0 $27,721 $723 $198 $2,082 Middle-Age
149 7 1 0 $39,602 $32,198 $848 $237 $5,906 Young Adult
150 3 1 0 $31,100 $28,489 $1,083 $210 $2,072 Young Adult
151 3 2 1 $58,451 $29,753 $1,470 $257 $6,623 Young Adult
152 4 4 0 $20,277 $14,502 $500 $215 $2,794 Young Adult
153 2 3 1 $33,963 $33,168 $991 $243 $4,006 Young Adult
154 1 1 1 $45,869 $1,377 $246 $6,206 Young Adult
155 1 2 1 $62,071 $1,326 $255 $6,186 Young Adult
156 1 4 0 $30,557 $601 $211 $1,185 Young Adult
157 3 4 0 $30,482 $18,684 $588 $208 $4,557 Middle-Age
158 3 1 1 $90,488 $68,619 $1,537 $262 $7,904 Senior
159 3 1 1 $61,174 $35,481 $1,601 $261 $4,504 Senior
160 3 4 1 $28,378 $644 $256 $4,375 Young Adult
161 3 2 1 $39,847 $32,802 $1,573 $253 $5,097 Young Adult
162 1 4 0 $37,154 $657 $201 $1,348 Young Adult
163 5 1 0 $42,841 $33,961 $892 $213 $2,551 Middle-Age
164 5 2 1 $56,072 $55,593 $1,248 $271 $6,969 Middle-Age
165 3 3 0 $33,442 $21,920 $770 $201 $2,584 Young Adult
166 4 1 1 $28,822 $22,936 $959 $257 $8,190 Senior
167 2 1 1 $33,018 $871 $249 $4,591 Young Adult
168 3 2 1 $30,225 $1,117 $260 $4,560 Young Adult
169 5 3 1 $42,178 $40,211 $1,269 $278 $6,286 Middle-Age
170 2 3 0 $28,340 $18,533 $627 $198 $1,854 Senior
171 2 3 1 $43,027 $38,600 $1,235 $251 $4,694 Middle-Age
172 2 2 1 $76,547 $53,513 $926 $252 $7,161 Middle-Age
173 3 4 0 $41,275 $35,920 $1,120 $206 $3,826 Middle-Age
174 1 2 1 $59,708 $1,070 $255 $3,274 Young Adult
175 3 1 0 $68,115 $65,099 $1,159 $205 $6,910 Middle-Age
176 3 3 0 $25,755 $20,267 $847 $209 $2,171 Middle-Age
177 1 4 0 $33,699 $797 $208 $227 Young Adult
178 1 1 0 $36,384 $601 $202 $2,391 Young Adult
179 4 4 0 $25,816 $20,903 $562 $209 $3,200 Young Adult
180 3 1 0 $30,415 $17,213 $728 $207 $2,781 Young Adult
181 1 1 0 $34,150 $643 $205 $1,763 Young Adult
182 8 4 0 $31,484 $24,850 $644 $233 $3,688 Young Adult
183 5 2 1 $68,108 $57,895 $1,521 $275 $7,025 Middle-Age
184 4 4 0 $26,788 $26,101 $1,059 $203 $3,864 Middle-Age
185 1 1 1 $68,299 $1,271 $246 $6,579 Middle-Age
186 3 3 1 $36,015 $1,150 $252 $3,073 Middle-Age
187 3 1 1 $46,561 $26,631 $1,984 $255 $6,440 Young Adult
188 3 4 1 $52,434 $1,093 $271 $5,594 Middle-Age
189 2 4 0 $37,650 $32,230 $534 $201 $2,158 Young Adult
190 4 3 1 $34,308 $25,247 $963 $254 $5,121 Young Adult
191 4 1 1 $53,576 $48,666 $1,108 $257 $4,263 Middle-Age
192 2 1 1 $46,249 $1,133 $254 $3,931 Young Adult
193 1 4 1 $33,940 $1,027 $247 $4,923 Senior
194 1 4 1 $37,924 $653 $248 $4,017 Young Adult
195 4 4 0 $26,167 $16,259 $553 $212 $2,353 Young Adult
196 10 4 0 $33,456 $22,267 $405 $226 $4,354 Young Adult
197 4 4 0 $20,182 $16,653 $603 $218 $2,989 Middle-Age
198 3 2 1 $65,699 $50,202 $1,065 $263 $4,977 Middle-Age
199 4 2 1 $59,015 $34,549 $1,262 $254 $7,340 Middle-Age
200 6 2 1 $81,366 $45,443 $1,800 $267 $7,850 Senior
201 4 4 0 $31,198 $20,115 $497 $213 $2,092 Young Adult
202 3 2 1 $40,383 $31,270 $1,086 $256 $5,276 Young Adult
203 3 3 0 $24,578 $23,269 $1,286 $207 $3,154 Middle-Age
204 3 4 0 $30,002 $18,632 $349 $212 $2,808 Young Adult
205 1 4 1 $42,058 $884 $254 $4,607 Young Adult
206 4 3 0 $25,835 $15,362 $797 $209 $3,136 Young Adult
207 1 4 0 $18,276 $478 $196 $1,657 Young Adult
208 1 4 0 $22,380 $746 $194 $854 Young Adult
209 3 1 1 $48,893 $676 $254 $5,112 Middle-Age
210 4 1 0 $60,953 $58,573 $1,186 $205 $3,374 Senior
211 4 3 0 $29,322 $17,787 $674 $212 $1,582 Middle-Age
212 4 1 1 $36,170 $1,185 $253 $5,467 Middle-Age
213 3 2 1 $70,692 $69,115 $1,088 $252 $6,915 Young Adult
214 5 1 1 $36,742 $19,478 $1,304 $262 $5,697 Senior
215 4 3 0 $39,255 $36,234 $949 $207 $3,848 Young Adult
216 3 1 0 $43,737 $37,196 $797 $206 $3,273 Middle-Age
217 4 2 0 $41,401 $33,059 $724 $205 $2,554 Young Adult
218 4 4 0 $23,779 $17,567 $784 $207 $2,954 Young Adult
219 4 2 0 $53,165 $33,644 $1,740 $199 $6,727 Senior
220 2 3 0 $34,756 $21,101 $801 $205 $3,163 Young Adult
221 2 3 0 $49,479 $48,203 $647 $201 $3,054 Middle-Age
222 1 2 0 $72,949 $1,522 $200 $3,729 Middle-Age
223 1 4 0 $39,987 $538 $204 $1,570 Middle-Age
224 1 1 0 $34,204 $838 $197 $1,855 Young Adult
225 2 4 0 $38,975 $32,867 $369 $192 $2,494 Middle-Age
226 1 1 1 $39,991 $796 $246 $3,657 Middle-Age
227 4 4 0 $18,706 $9,549 $690 $214 $2,672 Young Adult
228 4 3 0 $52,965 $37,370 $766 $214 $5,498 Middle-Age
229 3 2 0 $65,318 $58,628 $1,687 $219 $3,482 Young Adult
230 9 1 1 $32,630 $25,291 $1,391 $287 $7,930 Middle-Age
231 2 1 0 $56,645 $47,472 $797 $197 $2,910 Middle-Age
232 6 1 1 $40,270 $31,773 $854 $276 $6,545 Senior
233 4 4 0 $33,538 $26,083 $617 $215 $2,375 Middle-Age
234 3 4 1 $37,599 $1,058 $255 $5,605 Senior
235 1 1 1 $59,579 $1,161 $254 $5,364 Young Adult
236 4 3 0 $32,271 $17,847 $818 $211 $3,191 Young Adult
237 2 1 1 $41,427 $1,377 $249 $4,882 Young Adult
238 3 3 0 $37,235 $20,488 $745 $206 $2,100 Young Adult
239 2 3 1 $31,519 $1,218 $245 $4,669 Young Adult
240 1 2 1 $73,980 $823 $244 $3,831 Young Adult
241 4 4 1 $20,514 $18,732 $629 $266 $4,441 Young Adult
242 3 2 1 $81,612 $1,787 $254 $6,863 Young Adult
243 4 1 1 $65,717 $1,251 $263 $6,689 Young Adult
244 3 1 1 $50,155 $1,068 $254 $4,262 Middle-Age
245 2 4 1 $35,502 $829 $253 $3,371 Senior
246 3 3 1 $40,874 $33,446 $1,217 $260 $6,199 Middle-Age
247 5 4 0 $38,425 $35,376 $398 $224 $3,822 Middle-Age
248 5 3 1 $30,045 $25,054 $924 $271 $6,338 Young Adult
249 6 1 1 $31,644 $19,893 $821 $266 $5,859 Young Adult
250 2 4 0 $34,052 $17,805 $585 $200 $2,030 Middle-Age
251 4 1 1 $47,336 $30,437 $1,044 $261 $4,896 Senior
252 2 2 1 $38,007 $21,144 $840 $259 $4,505 Young Adult
253 5 4 0 $21,402 $13,964 $788 $222 $2,503 Senior
254 2 4 1 $39,353 $495 $247 $4,631 Young Adult
255 1 2 0 $64,179 $1,432 $199 $4,287 Senior
256 1 2 1 $67,184 $756 $242 $4,742 Young Adult
257 3 4 0 $43,163 $22,622 $941 $208 $2,491 Middle-Age
258 1 2 0 $51,372 $887 $191 $1,789 Middle-Age
259 5 4 0 $23,763 $21,360 $953 $226 $3,829 Senior
260 4 4 0 $20,987 $14,189 $355 $214 $3,635 Senior
261 3 3 0 $49,819 $36,911 $960 $211 $2,853 Young Adult
262 2 1 1 $58,303 $1,266 $256 $4,910 Middle-Age
263 4 2 0 $71,130 $39,826 $1,262 $216 $5,036 Senior
264 3 3 1 $37,375 $985 $255 $3,616 Senior
265 4 4 0 $21,701 $20,331 $799 $206 $2,493 Young Adult
266 1 4 0 $27,700 $728 $203 $555 Middle-Age
267 1 1 0 $32,420 $1,075 $203 $1,352 Young Adult
268 2 2 1 $65,740 $33,583 $1,044 $244 $4,646 Young Adult
269 4 4 1 $37,552 $22,103 $893 $260 $4,997 Young Adult
270 3 2 1 $58,182 $37,835 $1,576 $248 $8,318 Senior
271 2 4 1 $34,662 $22,798 $724 $245 $4,596 Young Adult
272 3 4 0 $38,634 $27,213 $549 $207 $2,706 Middle-Age
273 3 3 1 $27,085 $965 $268 $5,298 Senior
274 3 2 1 $60,590 $1,167 $264 $6,004 Middle-Age
275 2 2 1 $98,881 $74,825 $1,295 $249 $6,608 Middle-Age
276 5 1 1 $46,473 $37,134 $1,489 $261 $7,121 Middle-Age
277 1 3 1 $54,374 $804 $252 $5,410 Young Adult
278 2 1 1 $64,630 $62,321 $1,585 $249 $7,559 Young Adult
279 2 3 1 $39,320 $1,259 $254 $4,220 Young Adult
280 3 3 0 $31,461 $20,949 $888 $207 $2,621 Senior
281 4 3 0 $38,389 $21,554 $712 $222 $3,712 Middle-Age
282 3 1 1 $43,179 $909 $257 $5,218 Middle-Age
283 3 4 0 $31,721 $25,940 $525 $210 $1,619 Middle-Age
284 1 3 0 $28,835 $793 $205 $1,003 Senior
285 2 1 1 $65,852 $44,595 $908 $246 $6,546 Middle-Age
286 4 3 1 $49,156 $838 $258 $5,598 Senior
287 5 2 1 $57,772 $48,723 $1,070 $269 $6,650 Senior
288 3 3 0 $45,455 $37,997 $732 $217 $2,263 Senior
289 1 3 1 $46,890 $577 $244 $5,140 Young Adult
290 10 3 0 $48,330 $37,135 $616 $230 $4,681 Middle-Age
291 3 3 0 $50,724 $38,092 $653 $201 $5,330 Middle-Age
292 4 2 1 $48,586 $679 $258 $4,678 Young Adult
293 1 3 0 $29,289 $833 $206 $1,413 Young Adult
294 1 1 0 $36,838 $621 $192 $2,365 Young Adult
295 3 1 1 $39,080 $1,103 $259 $4,371 Middle-Age
296 5 4 0 $21,382 $16,970 $557 $215 $2,265 Middle-Age
297 2 1 1 $42,390 $26,173 $1,008 $247 $3,516 Young Adult
298 2 2 1 $48,120 $41,952 $1,317 $246 $5,620 Young Adult
299 2 4 1 $35,343 $556 $239 $4,899 Middle-Age
300 5 2 1 $75,049 $55,657 $1,380 $272 $5,384 Middle-Age
301 1 3 1 $32,316 $790 $260 $3,138 Young Adult
302 3 3 0 $46,289 $42,421 $778 $208 $2,395 Young Adult
303 2 4 0 $35,883 $19,692 $895 $203 $2,350 Senior
304 3 3 1 $37,904 $23,890 $1,614 $267 $6,846 Middle-Age
305 3 3 1 $54,901 $28,768 $1,306 $266 $5,224 Middle-Age
306 4 3 0 $32,649 $24,742 $1,103 $212 $4,999 Senior
307 2 4 1 $16,971 $807 $241 $3,459 Senior
308 3 4 1 $34,431 $805 $258 $5,426 Middle-Age
309 5 4 0 $30,539 $22,543 $334 $213 $2,962 Young Adult
310 1 4 0 $32,697 $623 $202 $1,340 Young Adult
311 4 2 1 $84,886 $1,141 $260 $6,490 Middle-Age
312 3 1 0 $29,386 $17,430 $875 $205 $2,334 Middle-Age
313 4 4 0 $24,109 $20,314 $389 $211 $2,560 Young Adult
314 2 1 1 $36,493 $32,221 $1,434 $248 $5,504 Middle-Age
315 4 1 1 $55,506 $53,412 $1,112 $264 $5,924 Young Adult
316 3 3 1 $39,627 $21,831 $933 $264 $5,137 Middle-Age
317 2 4 0 $28,910 $14,855 $490 $203 $1,129 Senior
318 4 3 1 $24,493 $1,136 $268 $4,678 Senior
319 3 1 1 $41,965 $36,335 $1,242 $256 $6,195 Young Adult
320 2 1 0 $69,615 $63,710 $1,038 $205 $4,300 Middle-Age
321 3 2 1 $41,069 $1,493 $259 $3,374 Senior
322 1 4 0 $22,091 $613 $208 $2,562 Young Adult
323 6 1 1 $40,813 $21,383 $1,039 $266 $5,677 Middle-Age
324 3 3 1 $40,742 $1,403 $258 $4,857 Young Adult
325 3 3 0 $21,699 $13,704 $418 $212 $3,074 Young Adult
326 3 3 0 $24,430 $20,987 $610 $214 $2,269 Young Adult
327 2 3 1 $49,744 $1,734 $254 $5,868 Senior
328 4 4 0 $19,316 $10,680 $760 $212 $3,452 Senior
329 8 1 1 $52,862 $42,294 $1,042 $279 $8,323 Middle-Age
330 3 2 0 $83,859 $65,582 $1,166 $209 $5,906 Young Adult
331 2 2 1 $46,023 $30,393 $1,589 $245 $5,452 Middle-Age
332 1 4 0 $26,351 $623 $201 $2,097 Senior
333 4 1 1 $50,383 $35,749 $614 $266 $6,669 Senior
334 5 1 1 $36,630 $22,871 $1,295 $268 $7,437 Senior
335 6 1 1 $39,773 $853 $272 $5,070 Senior
336 2 3 0 $38,891 $23,808 $1,060 $202 $1,664 Middle-Age
337 5 3 1 $42,323 $28,427 $866 $279 $5,509 Young Adult
338 3 2 1 $43,891 $43,745 $1,707 $257 $6,445 Young Adult
339 5 2 1 $71,659 $70,436 $1,138 $267 $5,896 Middle-Age
340 5 3 0 $35,241 $18,677 $553 $221 $3,903 Young Adult
341 5 4 0 $17,881 $10,509 $558 $217 $2,818 Middle-Age
342 3 4 0 $35,310 $25,405 $675 $203 $2,738 Middle-Age
343 3 4 0 $25,167 $19,673 $519 $210 $2,468 Middle-Age
344 1 4 0 $24,859 $509 $201 $2,119 Middle-Age
345 4 1 0 $38,993 $26,866 $921 $208 $3,089 Middle-Age
346 5 3 1 $30,384 $24,582 $1,432 $264 $6,805 Young Adult
347 3 2 1 $56,967 $37,901 $1,050 $268 $7,739 Middle-Age
348 1 4 1 $53,283 $974 $248 $3,745 Middle-Age
349 4 1 1 $44,436 $32,162 $1,217 $264 $6,412 Young Adult
350 4 4 0 $30,527 $27,055 $765 $209 $2,204 Young Adult
351 5 2 1 $95,583 $71,599 $1,253 $262 $9,104 Middle-Age
352 5 3 0 $24,064 $18,095 $755 $218 $3,874 Young Adult
353 2 4 0 $28,950 $18,542 $427 $205 $2,067 Senior
354 2 3 0 $33,176 $23,897 $711 $201 $3,032 Senior
355 4 2 0 $37,297 $28,010 $1,830 $212 $5,425 Senior
356 3 1 1 $33,653 $26,704 $1,055 $266 $3,773 Senior
357 2 3 0 $33,723 $27,480 $622 $192 $1,588 Middle-Age
358 2 1 0 $45,572 $23,213 $931 $202 $4,325 Senior
359 3 1 0 $46,672 $28,877 $1,054 $215 $2,258 Senior
360 2 2 1 $37,093 $18,561 $1,287 $248 $3,511 Young Adult
361 2 3 0 $36,588 $32,728 $729 $199 $3,123 Middle-Age
362 2 2 1 $43,934 $41,731 $1,802 $252 $5,914 Senior
363 3 4 0 $28,068 $17,927 $603 $206 $3,203 Senior
364 1 2 1 $75,737 $1,596 $249 $5,542 Young Adult
365 6 1 1 $37,107 $30,047 $1,331 $271 $7,349 Senior
366 4 2 1 $62,634 $59,352 $1,355 $256 $4,343 Middle-Age
367 3 2 1 $63,946 $62,523 $1,321 $251 $6,548 Young Adult
368 3 3 0 $35,943 $20,494 $568 $214 $3,001 Middle-Age
369 1 4 1 $24,992 $579 $242 $3,225 Young Adult
370 5 2 1 $48,643 $36,651 $1,439 $264 $6,628 Young Adult
371 2 3 0 $27,160 $26,619 $707 $201 $2,765 Senior
372 4 2 1 $49,699 $1,516 $250 $5,072 Middle-Age
373 2 2 1 $47,659 $26,827 $1,051 $257 $5,891 Senior
374 3 3 0 $39,778 $33,336 $812 $212 $2,326 Middle-Age
375 7 1 0 $31,090 $21,586 $694 $231 $4,468 Senior
376 2 3 1 $42,708 $41,601 $753 $253 $6,474 Senior
377 4 3 0 $31,238 $29,402 $827 $216 $3,579 Young Adult
378 1 2 1 $60,240 $989 $252 $4,161 Middle-Age
379 4 1 0 $37,117 $34,071 $523 $206 $4,268 Senior
380 4 2 0 $43,832 $32,996 $760 $200 $3,188 Young Adult
381 1 3 0 $35,105 $960 $201 $2,372 Young Adult
382 3 2 0 $45,609 $29,602 $991 $209 $3,848 Young Adult
383 4 1 1 $41,914 $38,478 $1,223 $270 $5,346 Middle-Age
384 3 1 1 $51,202 $29,289 $1,619 $267 $6,031 Senior
385 3 4 0 $22,393 $11,802 $549 $213 $3,051 Senior
386 3 1 0 $49,447 $36,562 $854 $208 $4,042 Senior
387 5 2 1 $83,363 $72,930 $1,799 $267 $6,072 Senior
388 2 4 0 $25,997 $13,295 $566 $209 $1,817 Middle-Age
389 4 4 0 $46,656 $31,044 $671 $210 $2,493 Middle-Age
390 3 2 1 $56,857 $49,696 $1,533 $247 $7,728 Young Adult
391 5 1 1 $49,943 $34,731 $873 $267 $6,309 Middle-Age
392 1 1 1 $72,515 $1,085 $250 $6,349 Senior
393 2 1 0 $53,248 $44,398 $490 $192 $1,827 Middle-Age
394 2 2 1 $35,572 $31,433 $914 $249 $3,566 Young Adult
395 4 3 1 $32,425 $31,348 $1,176 $253 $5,659 Young Adult
396 2 3 0 $46,271 $40,282 $941 $208 $1,490 Young Adult
397 3 1 1 $85,621 $81,979 $1,827 $260 $6,289 Middle-Age
398 2 1 1 $25,076 $21,758 $1,081 $252 $3,388 Young Adult
399 2 4 0 $38,697 $24,277 $765 $203 $4,138 Middle-Age
400 5 4 0 $32,794 $32,704 $405 $216 $3,187 Young Adult
401 2 4 0 $26,101 $13,983 $538 $204 $2,049 Middle-Age
402 8 4 0 $25,655 $23,464 $493 $234 $3,826 Senior
403 3 3 0 $44,158 $32,616 $719 $225 $2,609 Young Adult
404 6 3 1 $24,114 $13,577 $925 $265 $4,894 Young Adult
405 5 4 0 $24,503 $16,321 $453 $218 $1,974 Middle-Age
406 1 2 1 $48,914 $1,153 $249 $5,167 Young Adult
407 4 4 0 $23,695 $16,558 $510 $211 $2,722 Middle-Age
408 5 4 1 $30,372 $799 $279 $4,205 Young Adult
409 2 3 0 $24,306 $15,467 $540 $199 $3,300 Senior
410 2 1 1 $35,079 $29,542 $961 $257 $5,067 Young Adult
411 1 1 0 $25,886 $820 $205 $1,551 Young Adult
412 2 1 0 $45,625 $40,583 $887 $199 $3,250 Young Adult
413 3 3 1 $39,341 $34,520 $773 $270 $6,248 Young Adult
414 2 4 1 $32,433 $22,666 $780 $248 $3,482 Senior
415 2 1 0 $64,570 $62,590 $931 $202 $3,311 Middle-Age
416 2 2 1 $55,665 $1,048 $252 $6,545 Young Adult
417 5 4 0 $31,657 $31,596 $530 $213 $2,780 Middle-Age
418 4 2 1 $85,374 $53,417 $1,103 $255 $6,845 Young Adult
419 1 2 1 $76,800 $1,237 $258 $4,260 Young Adult
420 2 3 1 $38,681 $33,853 $956 $251 $5,524 Young Adult
421 9 4 0 $26,380 $22,382 $648 $232 $4,229 Middle-Age
422 6 1 1 $71,206 $56,268 $1,009 $276 $6,647 Senior
423 2 2 1 $69,863 $57,019 $1,705 $245 $5,764 Young Adult
424 2 3 0 $37,435 $21,724 $996 $201 $4,289 Young Adult
425 3 2 0 $42,419 $40,654 $1,187 $206 $2,911 Senior
426 1 3 0 $43,482 $735 $200 $1,783 Young Adult
427 5 1 1 $48,439 $44,434 $1,147 $262 $5,940 Senior
428 1 2 0 $45,038 $984 $201 $2,030 Senior
429 1 4 0 $33,087 $633 $211 $818 Young Adult
430 1 2 1 $45,993 $1,689 $248 $4,652 Middle-Age
431 3 3 1 $45,220 $25,914 $994 $257 $5,226 Young Adult
432 1 3 0 $29,407 $857 $203 $2,685 Young Adult
433 3 3 1 $34,933 $21,844 $1,705 $256 $6,158 Young Adult
434 4 2 1 $49,206 $37,614 $980 $259 $5,567 Middle-Age
435 4 3 1 $61,764 $1,066 $250 $6,303 Young Adult
436 2 2 1 $64,982 $34,370 $1,700 $261 $5,562 Middle-Age
437 3 3 0 $20,844 $11,948 $861 $216 $1,656 Middle-Age
438 2 1 0 $53,607 $33,620 $831 $194 $2,489 Young Adult
439 4 3 0 $38,481 $31,892 $475 $210 $2,301 Middle-Age
440 1 2 1 $56,151 $1,128 $252 $3,816 Middle-Age
441 2 4 0 $31,118 $30,705 $595 $204 $3,482 Senior
442 5 2 1 $53,338 $793 $274 $5,444 Middle-Age
443 6 3 0 $25,246 $15,707 $954 $222 $4,001 Senior
444 4 2 1 $32,705 $25,029 $1,142 $252 $4,802 Middle-Age
445 5 2 1 $79,696 $42,497 $814 $273 $7,041 Young Adult
446 2 4 0 $24,327 $24,250 $628 $194 $1,675 Senior
447 5 1 1 $84,098 $60,049 $1,213 $267 $5,861 Young Adult
448 3 4 0 $23,653 $15,052 $474 $216 $1,623 Middle-Age
449 2 2 1 $58,305 $1,171 $247 $5,803 Young Adult
450 1 1 0 $47,570 $918 $200 $2,689 Young Adult
451 3 4 0 $20,435 $18,013 $547 $215 $2,538 Middle-Age
452 2 2 1 $84,675 $1,068 $249 $4,130 Young Adult
453 5 1 0 $42,603 $30,072 $931 $220 $2,958 Young Adult
454 3 1 0 $35,043 $18,189 $930 $207 $2,340 Young Adult
455 4 3 0 $18,782 $13,096 $719 $206 $3,330 Young Adult
456 1 1 0 $32,125 $597 $196 $1,597 Young Adult
457 3 2 1 $38,157 $27,643 $727 $264 $5,260 Middle-Age
458 3 3 0 $29,101 $15,967 $500 $206 $3,447 Young Adult
459 3 1 1 $37,869 $30,059 $941 $262 $5,642 Young Adult
460 4 3 0 $26,103 $17,435 $934 $215 $2,932 Young Adult
461 4 1 1 $55,264 $46,778 $1,420 $265 $6,729 Senior
462 2 3 0 $29,718 $17,955 $1,240 $206 $2,851 Senior
463 4 3 1 $34,884 $783 $251 $3,871 Middle-Age
464 3 3 0 $33,467 $30,032 $1,286 $214 $3,210 Middle-Age
465 1 3 0 $18,119 $1,452 $211 $3,523 Young Adult
466 8 2 1 $46,100 $44,847 $820 $286 $6,840 Young Adult
467 3 1 1 $48,369 $1,222 $259 $5,107 Middle-Age
468 2 2 0 $45,275 $29,055 $1,076 $197 $1,686 Middle-Age
469 1 3 1 $35,430 $1,029 $259 $3,978 Young Adult
470 3 4 0 $42,249 $32,387 $615 $208 $2,658 Middle-Age
471 3 1 1 $84,823 $44,388 $1,136 $254 $5,801 Young Adult
472 1 2 1 $60,069 $1,434 $249 $3,578 Young Adult
473 2 4 1 $28,534 $760 $255 $3,281 Young Adult
474 4 4 1 $30,433 $28,204 $584 $260 $4,823 Young Adult
475 3 1 1 $53,184 $41,624 $1,033 $254 $5,889 Middle-Age
476 1 3 0 $49,358 $562 $205 $2,962 Young Adult
477 1 3 1 $41,628 $1,732 $253 $5,370 Young Adult
478 3 3 1 $46,389 $1,780 $258 $6,341 Young Adult
479 2 1 1 $85,051 $1,307 $246 $5,460 Young Adult
480 3 3 0 $46,703 $40,502 $1,078 $205 $3,606 Young Adult
481 3 4 0 $33,268 $17,587 $680 $208 $1,909 Middle-Age
482 3 2 1 $76,435 $40,136 $1,009 $259 $6,806 Young Adult
483 2 4 1 $37,450 $21,464 $618 $248 $3,098 Young Adult
484 1 3 0 $47,244 $638 $196 $2,896 Middle-Age
485 3 3 0 $57,525 $29,514 $1,001 $213 $3,436 Middle-Age
486 3 4 1 $33,919 $31,371 $713 $259 $4,619 Senior
487 3 1 1 $50,643 $37,465 $1,436 $261 $5,744 Middle-Age
488 1 3 0 $26,610 $999 $197 $1,629 Young Adult
489 5 2 1 $52,656 $30,422 $747 $266 $6,447 Middle-Age
490 2 3 1 $49,255 $35,491 $1,280 $253 $4,684 Middle-Age
491 3 4 0 $31,142 $18,969 $400 $218 $3,409 Young Adult
492 5 1 1 $39,189 $24,834 $1,067 $275 $6,570 Middle-Age
493 3 4 0 $46,379 $26,253 $484 $215 $1,458 Young Adult
494 1 3 1 $42,313 $883 $248 $3,132 Middle-Age
495 2 1 1 $46,828 $39,596 $1,032 $246 $6,001 Middle-Age
496 3 1 0 $42,758 $34,067 $1,184 $197 $3,194 Middle-Age
497 5 2 1 $66,397 $54,716 $990 $274 $8,400 Middle-Age
498 2 2 1 $43,599 $33,364 $1,603 $253 $5,675 Middle-Age
499 4 4 1 $25,713 $831 $266 $4,879 Middle-Age
500 1 4 1 $39,187 $948 $251 $3,278 Middle-Age

Please type your answers here:

Q3

Last Name First Name Position
Michael H. Way: This variable identifies the player's primary position. For those who don't follow hockey: C = centre R = right wing L = left wing D = defenseman G = goaltender
Salary
Michael H. Way: The player's salary for the season, in US$.
Forsberg Peter C $11,000,000
Sakic Joe C $9,832,727
Blake Robert D $9,285,194
Roy Patrick G $8,500,000
Foote Adam D $4,200,000
Hejduk Milan R $2,700,000
Drury Chris C $2,500,000
Keane Mike R $1,500,000
de Vries Greg D $1,375,000
Yelle Stephane L $1,200,000
Skoula Martin D $1,100,000
Tanguay Alex C $900,000
Messier Eric D $700,000
Hinote Dan R $600,000
Parker Scott R $574,750
Aubin Serge C $500,000
Muir Bryan D $500,000
Pitlick Lance D $500,000
Reinprecht Steven C $475,000
Aebischer David G $450,000
Larsen Brad L $423,500
Willsie Brian R $423,500
Hahl Riku C $415,000
Vrbata Radim R $400,000

Q4

Please type your answers to question 4 here.

Q5

Please type your answers to question 5 here. 5)

_STDS_DG2E685C67

Name Data Set #1
GUID DG2E685C67
Format Range FALSE
Variable Layout Columns
Variable Names In Cells TRUE
Variable Names In 2nd Cells TRUE
Data Set Ranges 1
Data Sheet Format 1
Formula Eval Cell 1
Num Stored Vars 9
1 : Info VG2978062F var1 ST_Household TRUE 0 4
1 : Ranges 10
1 : MultiRefs
2 : Info VG1C571486 var2 ST_FamilySize TRUE 0 4
2 : Ranges 1
2 : MultiRefs
3 : Info VG33E57EAA var3 ST_Location TRUE 0 4
3 : Ranges 1
3 : MultiRefs
4 : Info VG28D50A3C var4 ST_Ownership TRUE 0 4
4 : Ranges 1
4 : MultiRefs
5 : Info VG1E40085F var5 ST_FirstIncome TRUE 0 4
5 : Ranges 52847
5 : MultiRefs
6 : Info VG2E2AA31E var6 ST_SecondIncome TRUE 0 4
6 : Ranges 0
6 : MultiRefs
7 : Info VG3A059CE1 var7 ST_MonthlyPayment TRUE 0 4
7 : Ranges 606
7 : MultiRefs
8 : Info VG26491A6F var8 ST_Utilities TRUE 0 4
8 : Ranges 214
8 : MultiRefs
9 : Info VG25E3D7C5 var9 ST_Debt TRUE 0 4
9 : Ranges 1796
9 : MultiRefs