FOR Mr.perfect Only

profilelad.no
wages-2007.xls
Home>Mathematics homework help>Numerical analysis homework help>FOR Mr.perfect Only

Introduction to the Assignment

Directions for the Assignment:
1. Identification of each column--
Column A are wages in nominal terms
Column B is industry: 0 is manufacturing, 1 is services, 2 is government sector
Column C is occupations within each industry
Column D is education level. Anything above 12 would college and anything 16 or more is graduate degree
Column E is whether the person lives in the south (1) or not (0)
Column F is nonwhite (1) or not nonwhite (0)
Column G is Hispanic (1) or not Hispanic (0)
Column H is female (1) or not female or male (0)
Column I is the number of years of experience
Column J is married (1) or not married (0)
Column K is the age of the person
Column L is a member of a union (1) not a member of a union (0)
2. The questions for the assignment.
a. Prepare descriptive statistics of wages in the South and not in the South. What are the differences between the two regions?
b. Prepare descriptive statistics of wages for those in a union or not in the union. What are the differences between the unionized workers and non-unioned workers? Why do you think so?
c. Prepare the descriptives of wages for males and females. What are the differences in wages by gender? What are the reasons for these possible differences?
d. From part c, prepare a confidence interval for wages for men and women. What do the confidence intervals reveal? Explain.

Data for Assignment

Wage Industry Occupation Ed South Nonwh Hisp Fe Ex Marr Age Union
19388 1 0 6 1 0 0 0 45 1 57 0
49898 2 0 12 0 0 0 0 33 1 51 1
28219 0 3 12 1 0 0 0 12 1 30 0
83601 0 5 17 0 0 1 0 18 1 41 0
29736 0 4 8 0 0 1 0 47 1 61 1
50235 1 0 16 0 0 0 0 12 1 34 0
45976 0 2 12 0 0 0 0 43 1 61 1
33411 1 2 12 1 0 0 0 20 1 38 0
21716 0 5 12 0 0 0 1 11 0 29 0
37664 0 5 18 0 0 0 0 19 1 43 0
26820 0 5 18 0 0 0 0 33 0 57 1
29977 0 4 16 0 1 0 1 6 1 28 0
33959 0 5 17 0 0 0 1 26 1 49 1
11780 0 2 11 0 0 0 1 33 1 50 0
10997 0 4 14 0 1 0 0 0 0 20 0
17626 0 3 12 0 0 0 1 45 1 63 0
22133 0 5 16 0 0 0 1 10 0 32 1
21994 0 1 12 0 0 0 1 24 1 42 0
29390 0 0 13 0 0 0 0 18 1 37 0
32138 0 4 14 0 0 0 0 22 1 42 1
30006 1 3 16 0 0 0 1 27 1 49 0
68573 0 5 16 1 0 0 0 14 1 36 1
17694 0 4 8 0 0 0 1 38 1 52 0
26795 0 0 7 1 0 0 0 44 1 57 0
19981 0 4 4 0 0 0 0 54 1 64 0
14476 0 5 12 0 0 0 1 3 1 21 0
19452 0 4 13 0 1 0 0 3 0 22 0
28168 1 0 13 0 0 0 0 17 0 36 0
19306 0 5 9 1 1 0 1 34 1 49 1
13318 1 0 11 1 0 0 1 25 1 42 1
25166 0 4 12 0 0 0 1 10 0 28 0
18121 1 3 12 0 0 0 1 18 1 36 0
13162 1 0 12 0 1 0 0 6 0 24 1
32094 0 3 12 1 0 0 1 14 1 32 0
16667 0 3 12 1 0 0 0 4 0 22 0
50171 0 5 12 0 0 0 0 39 1 57 1
31691 1 0 12 0 0 0 0 13 0 31 0
36178 0 3 12 0 0 0 1 40 1 58 0
15234 0 1 12 1 0 1 1 4 0 22 0
16817 0 3 12 1 0 0 1 26 0 44 0
22485 0 3 12 0 0 0 0 22 0 40 0
30308 0 4 12 0 0 0 0 10 1 28 0
11702 0 2 14 1 0 0 1 6 1 26 0
11186 0 0 12 0 0 0 0 0 0 18 0
12285 0 1 12 0 0 0 1 42 1 60 0
19284 1 4 16 0 0 0 0 3 0 25 0
11451 1 0 12 0 0 0 1 8 1 26 0
57623 0 1 15 0 0 0 0 31 1 52 0
25670 0 3 13 0 0 0 1 8 0 27 1
83443 0 5 17 0 0 0 1 5 0 28 0
49974 1 1 16 0 1 0 0 26 1 48 1
46646 2 0 5 1 0 0 0 44 1 55 0
31702 0 3 12 1 0 0 1 39 1 57 0
13312 0 4 12 1 0 0 1 9 1 27 0
44543 0 2 18 0 0 0 0 10 1 34 0
15013 0 4 16 0 0 0 0 21 1 43 0
33389 0 1 14 0 1 0 0 22 0 42 0
60626 0 5 18 0 0 0 0 7 1 31 0
24509 0 5 14 0 0 1 1 15 0 35 0
20852 1 0 12 0 0 0 1 38 1 56 0
30133 2 0 10 0 0 0 0 27 1 43 0
31799 0 3 12 0 0 0 1 25 0 43 0
16796 0 4 12 0 0 0 1 14 1 32 0
20793 0 0 12 1 0 0 1 6 0 24 0
29407 0 4 10 1 0 0 0 19 0 35 0
29191 0 0 12 0 0 0 0 9 0 27 0
15957 0 2 12 1 0 0 1 10 0 28 0
34484 0 3 13 1 0 0 1 28 0 47 0
35185 1 3 14 0 0 0 1 12 1 32 0
26614 1 0 12 0 0 0 1 19 1 37 0
41780 0 0 12 1 0 0 0 9 1 27 0
55777 0 1 14 1 0 0 0 21 1 41 0
15160 0 4 8 1 0 0 1 45 0 59 0
66738 0 0 9 1 0 0 0 29 1 44 0
33351 0 5 16 1 0 0 1 4 1 26 0
33498 0 1 10 0 0 0 0 20 1 36 0
29809 0 4 8 0 1 0 1 29 0 43 0
15193 1 0 12 0 0 0 1 15 0 33 0
23027 0 4 14 0 1 0 0 34 1 54 1
75165 0 1 15 0 0 0 0 12 1 33 0
18752 0 4 11 0 0 0 1 45 0 62 1
83569 0 1 18 0 0 0 0 29 1 53 0
32235 0 3 12 0 0 0 1 38 1 56 0
20852 0 0 12 1 0 0 0 1 0 19 0
13787 0 4 11 0 0 0 0 4 1 21 0
34746 0 3 14 1 0 0 1 15 1 35 0
17690 0 1 12 1 1 0 0 14 1 32 0
52762 0 5 18 0 0 0 0 7 1 31 0
60152 0 5 16 1 0 0 0 38 1 60 0
33461 0 1 16 0 0 1 0 7 1 29 1
13481 0 4 12 1 0 1 0 7 0 25 0
9879 0 3 12 1 0 0 1 28 1 46 0
16789 0 3 13 1 0 0 1 6 1 25 0
31304 0 1 16 0 0 0 1 26 1 48 0
37771 0 5 15 0 0 0 0 5 0 26 0
50187 0 3 12 0 0 0 1 24 1 42 0
39888 0 3 12 1 0 0 0 5 0 23 0
19227 0 3 12 0 0 0 1 15 1 33 0
32786 1 0 11 1 0 0 0 37 1 54 1
28440 0 4 12 0 0 0 1 24 1 42 0