Regression Analysis Assignment

profilegarinh
Excelexercise9-wagedata3.xlsx
Home>Business & Finance homework help>Economics homework help>Regression Analysis Assignment

Data

Hourly wage ($) Education (years) Experience (years) Job tenure (years) Female dummy West dummy East dummy South dummy Midwest dummy Gender Region
10.53 4 39 15 Male West
9 14 3 3 Female West
41.85 16 41 16 Male Midwest
10.62 13 6 7 Female Midwest
39.99 12 14 11 Male East
9.75 12 42 0 Female West
14.04 16 3 1 Female Midwest
25.35 12 19 13 Male East
17.13 16 3 0 Female East
16.89 16 2 2 Male East
11.25 12 7 0 Female East
19.89 15 21 3 Female West
8.85 8 15 2 Female East
19.5 12 33 2 Male Midwest
17.49 8 36 15 Female East
10.5 14 18 2 Male Midwest
12 12 22 3 Male South
10.74 12 13 0 Male South
11.25 10 15 0 Male East
13.8 14 7 0 Female East
16.8 15 31 15 Female Midwest
15 16 2 1 Female South
9.78 16 15 5 Female South
10.5 13 29 1 Female South
9.39 12 6 5 Female South
15.75 10 44 7 Male Midwest
10.5 12 7 6 Female Midwest
20.01 12 35 10 Male East
8.7 11 2 0 Female South
10.35 10 11 0 Female South
13.5 12 47 4 Female Midwest
9 15 9 0 Male Midwest
37.5 15 30 0 Male West
23.34 14 9 3 Male East
12 12 22 11 Female Midwest
19.5 14 41 33 Male Midwest
8.7 12 26 1 Female South
12 12 5 2 Male South
27 17 7 0 Female East
12 9 22 18 Male South
24.3 12 38 3 Female Midwest
8.7 11 1 0 Female Midwest
8.61 12 45 8 Female Midwest
10.5 14 5 4 Female West
13.5 12 2 1 Female East
10.2 12 26 15 Female Midwest
29.04 13 16 16 Female West
12 14 22 3 Female East
15.15 12 19 0 Female South
17.73 12 14 6 Male East
8.7 12 39 1 Female South
39 14 23 5 Male West
35.13 13 40 20 Female East
26.25 16 9 8 Male West
13.14 16 7 0 Male East
21.75 12 14 5 Male West
6.81 10 2 0 Female West
9 7 26 1 Female South
18 13 21 13 Male South
12 12 28 0 Female East
18.24 16 9 0 Male South
8.73 11 1 0 Female Midwest
10.05 7 35 0 Female South
35.28 14 40 39 Male East
9 11 1 1 Female South
33.33 12 30 8 Male Midwest
11.85 6 49 6 Male South
14.07 10 7 7 Male Midwest
30 14 43 4 Male Midwest
20.28 12 19 3 Male East
12.3 14 6 0 Female South
10.5 12 14 0 Female South
8.67 10 8 0 Female East
66.6 12 31 15 Male West
30 18 9 8 Male Midwest
11.25 12 14 0 Female East
30 17 5 3 Male Midwest
12.6 13 11 3 Female Midwest
22.5 12 10 0 Female West
28.68 16 3 3 Male West
16.74 16 1 1 Male East
20.55 15 11 3 Female East
8.76 14 1 3 Male East
25.5 8 38 26 Male Midwest
8.79 12 36 2 Female West
18.75 12 21 6 Male South
17.13 16 10 5 Male East
53.13 16 10 3 Male West
15.33 11 3 0 Male West
30 8 9 0 Male Midwest
6.51 13 1 4 Female Midwest
18.45 12 15 6 Female West
10.8 12 13 0 Female West
12 13 6 0 Female Midwest
13.32 8 29 11 Male South
6 13 2 6 Female Midwest
5.01 10 1 0 Male West
10.11 11 45 12 Male East
12 10 34 12 Male Midwest
29.4 17 7 0 Male East
16.29 14 10 3 Male South
9 12 1 0 Male South
9 8 45 1 Female East
18.75 17 4 0 Female West
33.75 17 28 25 Male South
30 14 28 11 Female South
26.25 16 3 2 Male Midwest
17.85 11 15 9 Male South
10.5 8 4 0 Male East
20.64 12 31 19 Male Midwest
13.95 16 3 1 Male East
13.5 12 36 6 Female West
9.75 12 14 2 Female South
52.5 16 23 22 Male West
9 12 36 1 Female West
18.78 13 37 17 Female East
9.6 15 2 2 Female South
15.39 15 6 6 Female East
32.73 12 25 23 Male South
27.99 14 12 11 Male East
13.5 14 10 0 Male Midwest
9 11 3 0 Female West
20.64 12 11 4 Female West
36.66 16 10 2 Male South
25.29 8 27 3 Male South
45 11 35 31 Male South
12 12 10 1 Female East
18 13 8 0 Male Midwest
16.8 11 11 8 Male South
11.25 14 13 0 Female Midwest
27.27 15 11 12 Male West
9 9 23 20 Female South
11.25 12 11 0 Male South
15.15 10 5 0 Female Midwest
13.95 12 27 2 Male South
9 13 3 1 Male South
19.89 12 36 0 Female South
18.45 12 35 12 Female Midwest
16.44 10 36 3 Female South
4.5 8 31 30 Male South
65.58 12 24 16 Male Midwest
8.7 12 37 0 Female South
14.25 12 48 2 Female Midwest
9 10 7 0 Female Midwest
22.08 8 36 24 Male Midwest
9.75 8 9 1 Female West
19.5 10 14 11 Male South
13.5 12 3 0 Male West
30 12 15 0 Male East
18.75 15 12 4 Female East
10.53 12 7 2 Female Midwest
9 12 2 0 Male East
24 16 23 4 Male Midwest
17.52 13 5 0 Female South
19.38 12 27 0 Male Midwest
15.45 16 39 21 Female West
18.75 16 2 1 Female Midwest
14.16 12 15 1 Female South
13.65 16 34 2 Male South
7.5 12 2 0 Male East
8.7 5 34 0 Female West
14.37 12 41 8 Male Midwest
26.31 12 15 0 Male West
8.7 11 1 2 Male South
24 12 26 2 Male Midwest
15 6 18 0 Female West
18.75 16 4 3 Male West
16.2 12 6 3 Male East
34.65 16 20 5 Female South
14.73 12 17 8 Male East
8.67 0 42 0 Female West
11.25 14 8 4 Female South
8.76 9 49 0 Female South
30 12 20 5 Female West
51.99 16 14 0 Male West
37.5 14 40 30 Male Midwest
30 16 3 2 Male South
9.3 11 2 0 Female West
9 8 33 2 Male South
6.9 10 2 0 Female Midwest
11.25 12 39 2 Female Midwest
12 12 8 0 Female Midwest
19.14 13 11 4 Female West
9.39 10 1 1 Male West
39.48 12 34 22 Male East
8.1 9 2 0 Female Midwest
13.5 12 13 0 Male South
13.02 16 5 2 Female South
18 16 2 2 Male East
12.87 12 47 25 Female South
13.89 12 16 1 Female South
20.4 12 14 10 Male South
19.5 12 4 1 Female East
9 10 47 0 Male South
8.64 10 2 0 Female East
8.73 11 2 2 Male Midwest
24.54 13 21 5 Male West
30 12 29 0 Male East
60 12 22 4 Male South
8.7 12 2 2 Female West
13.5 12 31 4 Female South
18 11 37 8 Female West
11.49 12 18 2 Female South
18.75 16 9 2 Male Midwest
9.39 10 1 0 Female Midwest
11.25 18 1 2 Male Midwest
9.75 9 29 0 Male Midwest
10.92 12 7 2 Male South
10.5 12 6 2 Female East
25.89 12 23 9 Male South
15.75 11 13 11 Male South
11.4 15 6 1 Male South
16.56 13 31 3 Male South
17.25 14 6 5 Male East
24 12 17 6 Male South
17.31 10 44 3 Male Midwest
22.5 12 11 7 Male East
30 8 13 0 Male East
25.59 10 14 6 Male South
10.05 13 22 0 Female Midwest
9 14 17 0 Female South
30 12 31 2 Male South
10.05 12 9 1 Male Midwest
68.58 16 16 7 Male East
12.99 18 1 0 Male East
59.94 14 26 23 Male East
9 10 2 1 Female South
9.72 12 16 0 Female South
15 15 15 0 Male South
11.55 16 5 0 Male Midwest
12.51 0 22 10 Female South
13.5 12 13 0 Male West
15 14 15 5 Male South
12 12 9 0 Male South
10.5 12 31 3 Female West
13.5 14 2 5 Female West
9 8 33 0 Male South
10.5 13 1 2 Male Midwest
12.15 8 44 25 Male Midwest
12 10 2 0 Female West
9.6 11 1 0 Male East
12 12 43 6 Female East
13.5 12 35 12 Female East
22.5 16 11 0 Male Midwest
26.76 18 3 3 Male South
6.42 13 34 15 Female South
15 12 15 5 Male East
12.3 12 3 2 Female Midwest
8.7 10 23 2 Female South
10.5 12 3 0 Male East
22.5 16 6 2 Female South
17.34 16 11 4 Male Midwest
9.45 12 26 1 Male Midwest
15 11 24 5 Male South
10.05 14 5 4 Female Midwest
10.95 14 9 2 Male West
43.74 18 13 7 Female Midwest
21.78 13 8 2 Male South
9 12 11 0 Female South
30 16 9 3 Male South
33.3 15 1 4 Female South
9 4 48 0 Male South
9.6 12 15 5 Female South
9.18 12 14 10 Female South
12.33 14 5 0 Male South
24.06 18 23 3 Female South
9.9 12 25 8 Male Midwest
9.99 12 45 4 Female East
11.64 12 12 3 Male South
18.24 16 42 10 Male Midwest
9.87 14 30 13 Male Midwest
18.99 12 23 8 Male South
27.9 15 2 2 Male South
24.39 13 3 0 Female West
18.75 16 5 0 Male East
13.5 11 3 9 Male South
37.17 14 42 5 Male East
16.5 12 18 3 Male West
14.43 12 2 0 Female East
13.5 14 5 0 Male Midwest
10.8 12 26 4 Female West
15 12 5 3 Female West
18.75 13 6 5 Female Midwest
18.75 10 36 8 Male East
10.5 12 20 4 Female East
18 15 19 4 Female South
19.08 14 8 1 Male South
6 9 2 0 Male Midwest
23.43 12 3 0 Female West
33.75 18 15 7 Male West
14.25 12 19 0 Male South
11.25 12 18 0 Female Midwest
21 16 26 3 Female South
27 12 11 5 Female Midwest
12.75 14 5 2 Male East
9.72 12 22 2 Female West
37.5 18 6 2 Male South
22.5 12 18 5 Male West
12.3 16 5 0 Female Midwest
9 12 38 0 Female Midwest
25.29 16 8 6 Male South
13.89 14 4 0 Female South
9.3 12 2 1 Female East
18.75 12 13 0 Female Midwest
9 4 36 0 Male South
13.5 9 22 5 Male East
20.01 12 7 5 Male East
8.7 11 6 0 Female South
17.7 12 14 7 Male South
18.75 16 7 4 Female East
21.42 18 13 0 Male East
4.29 12 17 0 Female East
26.25 12 4 4 Male South
7.62 9 2 0 Female South
11.73 18 17 3 Male South
1.59 12 3 1 Female West
28.26 14 23 0 Female South
15.6 6 47 13 Male South
54.48 16 29 7 Male South
8.85 12 3 1 Male Midwest
25.92 12 28 8 Male Midwest
27 12 38 1 Male East
9 13 5 0 Female South
14.01 15 13 18 Male West
8.76 11 1 0 Female Midwest
23.34 16 11 10 Male West
39.24 17 17 2 Male East
9 12 26 9 Female South
9 12 11 1 Female East
8.7 10 4 0 Female East
12.15 9 7 4 Female South
13.32 12 3 0 Male Midwest
15.9 12 7 2 Male West
8.25 13 1 2 Female Midwest
9 14 33 3 Female East
9.84 12 17 2 Female South
18.33 14 15 0 Male East
10.8 10 34 26 Female South
12.6 16 8 0 Female Midwest
15 14 19 5 Male South
12 11 45 12 Female West
8.49 10 1 0 Male Midwest
6.93 9 4 1 Female Midwest
25.95 18 13 1 Female Midwest
35.94 18 8 10 Male South
11.13 10 13 0 Female East
21 12 6 5 Male South
25.44 12 29 13 Male West
11.25 2 39 13 Male South
13.14 13 7 0 Male West
24.99 15 33 26 Male East
32.76 12 34 5 Male South
25.8 16 3 2 Female East
22.8 12 41 11 Female Midwest
8.73 12 4 0 Male South
21.42 12 43 5 Female Midwest
8.76 12 4 0 Female South
30 12 25 3 Male East
24 13 28 5 Male Midwest
13.5 14 16 0 Female West
31.89 13 16 10 Female West
22.89 12 8 4 Female East
54 18 13 0 Female South
37.5 12 8 1 Male Midwest
19.29 16 17 3 Female South
10.65 12 6 0 Female East
30 12 24 24 Male Midwest
5.88 11 38 3 Female South
13.5 12 37 14 Female West
9.15 8 50 24 Female South
9.75 12 14 0 Female East
17.1 16 2 0 Male South
13.65 12 11 0 Male Midwest
4.89 12 18 0 Female East
9 15 32 0 Male South
45 14 7 7 Male East
5.25 11 2 1 Male West
9.99 12 36 8 Female South
24 12 12 3 Female South
9 16 19 10 Female Midwest
15 11 13 1 Male South
9.3 6 14 0 Female South
9 9 3 0 Female East
12.72 10 14 5 Male South
37.5 17 21 18 Male East
13.53 12 5 2 Male Midwest
64.89 18 8 8 Female East
8.7 12 17 1 Female Midwest
19.89 16 3 0 Male South
18.75 12 11 0 Female West
15.75 12 19 10 Female Midwest
7.59 12 46 0 Female East
18 8 44 28 Male West
8.7 6 49 7 Male South
19.5 12 20 14 Male West
19.5 17 3 0 Male Midwest
9.9 12 21 9 Female South
10.5 14 5 0 Female South
27.15 12 10 2 Male Midwest
8.7 12 15 1 Female West
9.3 12 2 2 Female South
15 8 45 2 Male Midwest
11.13 9 14 7 Male South
18.54 14 9 3 Female Midwest
17.7 12 9 7 Female Midwest
6 10 3 0 Female South
9 11 2 0 Male East
18.66 12 19 9 Female Midwest
17.13 13 10 2 Female East
9.45 13 1 0 Female Midwest
18.99 16 9 9 Female West
10.5 13 1 0 Male East
9.15 12 10 0 Female Midwest
9.24 12 3 1 Male East
32.85 16 23 20 Male South
18.75 12 10 0 Male South
17.4 12 19 6 Female Midwest
13.5 13 23 2 Female South
54.48 16 35 28 Male Midwest
10.2 16 1 1 Female East
9 15 1 0 Male South
11.43 12 8 1 Female Midwest
12 9 19 1 Female East
9 14 3 2 Female Midwest
31.14 18 16 2 Male Midwest
12.81 16 22 4 Female West
22.5 14 29 24 Male Midwest
15.75 16 4 0 Male South
19.05 14 10 1 Female South
37.5 16 31 0 Male West
13.5 16 21 10 Male South
13.5 11 37 10 Male South
7.95 12 42 10 Female West
13.71 14 3 0 Male South
43.14 17 10 9 Male South
10.5 12 2 0 Female South
9.75 12 4 0 Male East
26.25 14 9 3 Male East
8.7 10 18 0 Female South
13.71 14 37 7 Female East
10.5 18 3 1 Female East
10.35 12 6 5 Female South
12.84 13 1 1 Female East
16.95 12 2 0 Male West
18.75 16 8 2 Female West
24.99 16 6 2 Male West
37.5 18 16 5 Male Midwest
8.85 14 41 23 Male Midwest
19.08 16 25 0 Male South
4.5 12 11 1 Female Midwest
26.25 16 1 2 Male Midwest
10.5 11 23 2 Female South
20.64 13 34 21 Male South
18.75 7 39 21 Male South
74.94 18 29 25 Male East
7.8 9 4 0 Male West
11.28 6 6 0 Male South
14.04 12 3 0 Female West
19.59 16 3 2 Female Midwest
27.39 12 14 12 Male South
18 14 11 3 Female South
15 14 5 0 Male Midwest
18.75 16 11 4 Male Midwest
13.5 12 35 0 Female South
10.65 12 21 0 Female South
12.42 13 29 0 Female South
14.37 12 12 3 Female Midwest
54.54 17 22 21 Male West
9 8 33 12 Female South
9.6 12 29 0 Female South
10.5 12 26 20 Female South
41.1 15 20 13 Male West
8.7 8 49 6 Female East
12.6 14 33 16 Female East
12.87 12 3 0 Female South
14.25 13 47 1 Male West
14.85 7 25 17 Male East
18 14 11 0 Male Midwest
20.64 18 4 4 Male Midwest
18.75 11 35 31 Male South
15.75 12 4 0 Male Midwest
14.04 16 1 0 Male South
26.25 12 47 44 Male East
10.5 13 2 0 Female East
11.25 12 5 2 Female South
9 11 2 0 Male West
13.5 12 12 0 Male South
15 12 14 11 Female Midwest
24 12 14 4 Female East
18.87 17 10 3 Male South
7.14 9 5 0 Male South
11.19 9 33 2 Female Midwest
10.05 15 3 1 Female South
8.73 12 20 34 Female East
23.7 12 2 0 Male South
35.7 13 24 19 Male East
18 12 7 7 Male East
26.4 16 9 1 Male South
15 9 31 9 Male South
9.75 12 40 2 Female Midwest
6.75 12 5 0 Female South
9.75 15 3 0 Male East
6 12 3 2 Female East
15 12 7 3 Female West
35.46 16 35 13 Male West
16.5 12 9 4 Male South
19.35 12 7 6 Male South
45 16 14 2 Female West
56.67 17 26 20 Male East
46.14 13 25 21 Male Midwest
29.55 8 40 24 Male East
6.69 8 28 3 Male South
26.25 12 24 1 Male Midwest
18.75 16 24 2 Female West
18 12 22 8 Male East
12.24 12 43 17 Female Midwest
9 12 1 0 Female East
9.54 12 5 0 Female Midwest
34.68 16 5 1 Male West
9.15 12 2 0 Female Midwest
9.9 13 5 0 Female Midwest
8.76 3 51 30 Male South
19.5 12 8 5 Female South
9.78 12 13 3 Female East
30 14 18 5 Male South
10.56 12 48 1 Male South