Use Excel’s Data Analysis tool to conduct a multiple regression, using Salary as the dependent variable, and all the rest of variables as independent variables. (Choose confidence level at 95 %.) 1) Based on the multiple regression analysis output, write the estimated regression equation. 2) Use the regression coefficient of Gender (b1) to explain the gender pay gap in the state government. 3) The regression coefficient of Gender (b1) are different in the estimated simple regression equation and estimated multiple regression equation. Explain why.
Use Excel’s Data Analysis tool to conduct a multiple regression, using Salary as the dependent variable, and all the rest of variables as independent variables. (Choose confidence level at 95 %.) 1) Based on the multiple regression analysis output, write the estimated regression equation. 2) Use the regression coefficient of Gender (b1) to explain the gender pay gap in the state government. 3) The regression coefficient of Gender (b1) are different in the estimated simple regression equation and estimated multiple regression equation. Explain why.
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section: Chapter Questions
Problem 4SGR
Related questions
Question
Use Excel’s Data Analysis tool to conduct a multiple regression, using Salary as the dependent variable, and all the rest of variables as independent variables. (Choose confidence level at 95 %.)
1) Based on the multiple
2) Use the regression coefficient of Gender (b1) to explain the gender pay gap in the state government.
3) The regression coefficient of Gender (b1) are different in the estimated simple regression equation and estimated multiple regression equation. Explain why.
Salary | Gender | Years Of Service | Years Of Education |
52,100 | 0 | 5 | 13 |
55,015 | 0 | 20 | 13 |
55,520 | 0 | 23 | 12 |
43,430 | 0 | 7 | 12 |
43,813 | 0 | 5 | 12 |
51,903 | 0 | 6 | 12 |
54,580 | 0 | 24 | 14 |
54,913 | 0 | 18 | 12 |
52,100 | 0 | 29 | 12 |
50,693 | 0 | 14 | 12 |
47,878 | 0 | 10 | 12 |
46,555 | 0 | 6 | 14 |
47,878 | 0 | 7 | 16 |
47,878 | 0 | 9 | 12 |
54,913 | 0 | 16 | 13 |
50,123 | 0 | 4 | 13 |
50,693 | 0 | 20 | 12 |
48,933 | 0 | 29 | 12 |
58,270 | 0 | 12 | 12 |
50,538 | 0 | 5 | 13 |
48,933 | 0 | 12 | 12 |
45,078 | 0 | 5 | 12 |
47,878 | 0 | 5 | 14 |
53,508 | 0 | 24 | 12 |
42,250 | 0 | 1 | 16 |
53,508 | 1 | 8 | 15 |
42,250 | 1 | 3 | 15 |
47,808 | 1 | 1 | 13 |
50,180 | 1 | 11 | 13 |
44,163 | 1 | 9 | 10 |
41,718 | 1 | 3 | 10 |
47,878 | 1 | 8 | 12 |
37,635 | 1 | 1 | 16 |
49,285 | 1 | 7 | 12 |
50,693 | 1 | 14 | 12 |
43,655 | 0 | 3 | 12 |
43,910 | 1 | 9 | 13 |
43,910 | 1 | 11 | 12 |
68,303 | 0 | 19 | 14 |
85,128 | 0 | 3 | 12 |
53,488 | 0 | 3 | 12 |
66,430 | 0 | 22 | 12 |
59,708 | 0 | 10 | 12 |
71,555 | 0 | 15 | 12 |
53,565 | 0 | 14 | 16 |
73,490 | 0 | 15 | 12 |
69,045 | 0 | 13 | 16 |
63,025 | 0 | 13 | 12 |
56,715 | 0 | 12 | 13 |
66,728 | 0 | 16 | 12 |
59,348 | 0 | 29 | 12 |
68,068 | 0 | 14 | 14 |
69,540 | 0 | 20 | 12 |
47,268 | 0 | 2 | 12 |
70,253 | 0 | 19 | 12 |
64,390 | 0 | 13 | 12 |
67,235 | 0 | 11 | 13 |
74,155 | 0 | 29 | 13 |
64,180 | 0 | 23 | 12 |
65,568 | 0 | 14 | 12 |
50,415 | 0 | 12 | 13 |
65,113 | 0 | 7 | 12 |
61,463 | 0 | 1 | 12 |
59,865 | 0 | 22 | 12 |
54,158 | 0 | 9 | 12 |
64,365 | 0 | 16 | 12 |
72,205 | 0 | 22 | 12 |
64,400 | 0 | 14 | 12 |
76,948 | 0 | 29 | 12 |
61,440 | 0 | 21 | 12 |
53,488 | 0 | 2 | 13 |
71,030 | 0 | 15 | 12 |
76,490 | 0 | 18 | 12 |
56,215 | 0 | 2 | 13 |
59,708 | 0 | 10 | 12 |
74,155 | 0 | 32 | 12 |
70,195 | 0 | 10 | 15 |
57,918 | 0 | 3 | 12 |
77,815 | 0 | 16 | 12 |
60,498 | 0 | 4 | 12 |
80,125 | 0 | 20 | 12 |
74,975 | 0 | 26 | 12 |
72,338 | 0 | 15 | 12 |
63,910 | 0 | 19 | 13 |
56,818 | 0 | 7 | 12 |
62,450 | 0 | 4 | 13 |
68,303 | 0 | 23 | 12 |
77,815 | 0 | 26 | 12 |
56,715 | 0 | 13 | 12 |
56,618 | 0 | 3 | 12 |
61,463 | 0 | 5 | 16 |
55,140 | 0 | 15 | 12 |
68,610 | 0 | 19 | 12 |
63,218 | 0 | 9 | 12 |
83,040 | 0 | 35 | 12 |
63,635 | 0 | 17 | 12 |
59,708 | 0 | 7 | 12 |
52,335 | 0 | 5 | 12 |
53,265 | 0 | 7 | 12 |
69,058 | 0 | 5 | 13 |
67,460 | 0 | 32 | 12 |
56,650 | 0 | 16 | 16 |
61,440 | 0 | 28 | 12 |
58,290 | 0 | 24 | 12 |
72,205 | 0 | 18 | 13 |
64,825 | 0 | 9 | 13 |
59,563 | 0 | 14 | 16 |
69,513 | 0 | 7 | 12 |
78,003 | 0 | 20 | 12 |
61,463 | 0 | 9 | 12 |
52,335 | 0 | 7 | 14 |
59,865 | 0 | 19 | 13 |
58,290 | 0 | 19 | 12 |
64,400 | 0 | 8 | 12 |
59,598 | 0 | 12 | 12 |
53,565 | 0 | 7 | 12 |
68,303 | 0 | 11 | 12 |
75,415 | 0 | 16 | 12 |
62,390 | 0 | 10 | 12 |
51,990 | 0 | 7 | 13 |
56,715 | 0 | 12 | 16 |
64,973 | 0 | 24 | 13 |
72,205 | 0 | 31 | 12 |
61,463 | 0 | 13 | 12 |
82,140 | 0 | 23 | 12 |
61,463 | 0 | 15 | 14 |
51,125 | 0 | 8 | 12 |
64,400 | 0 | 6 | 16 |
64,400 | 0 | 6 | 14 |
60,498 | 0 | 2 | 14 |
68,303 | 0 | 15 | 12 |
56,118 | 0 | 9 | 12 |
53,998 | 0 | 11 | 12 |
66,353 | 0 | 13 | 14 |
70,253 | 0 | 22 | 13 |
61,440 | 0 | 18 | 12 |
65,423 | 0 | 6 | 14 |
61,463 | 0 | 17 | 12 |
70,253 | 0 | 20 | 12 |
58,548 | 0 | 4 | 16 |
64,728 | 0 | 22 | 12 |
53,565 | 0 | 10 | 12 |
69,035 | 0 | 26 | 14 |
58,290 | 0 | 17 | 12 |
51,990 | 0 | 8 | 12 |
53,565 | 0 | 9 | 14 |
51,125 | 0 | 5 | 12 |
63,218 | 0 | 16 | 14 |
67,003 | 0 | 8 | 12 |
60,153 | 0 | 14 | 12 |
71,328 | 0 | 8 | 12 |
55,140 | 0 | 14 | 10 |
72,205 | 0 | 26 | 13 |
55,140 | 0 | 15 | 12 |
51,990 | 0 | 9 | 12 |
57,953 | 0 | 7 | 12 |
59,853 | 0 | 6 | 13 |
57,953 | 0 | 5 | 13 |
64,973 | 0 | 28 | 12 |
50,415 | 0 | 3 | 12 |
82,140 | 0 | 18 | 13 |
56,715 | 0 | 15 | 12 |
56,715 | 0 | 14 | 12 |
69,835 | 0 | 9 | 12 |
55,348 | 0 | 7 | 12 |
61,440 | 0 | 23 | 14 |
57,953 | 0 | 8 | 13 |
82,308 | 0 | 20 | 12 |
68,483 | 0 | 22 | 12 |
62,315 | 0 | 14 | 12 |
47,630 | 0 | 4 | 12 |
71,030 | 0 | 14 | 12 |
73,870 | 1 | 21 | 14 |
62,653 | 1 | 12 | 12 |
51,990 | 1 | 9 | 13 |
62,858 | 1 | 13 | 12 |
56,118 | 1 | 10 | 12 |
56,198 | 1 | 7 | 13 |
88,318 | 1 | 23 | 13 |
51,990 | 1 | 6 | 12 |
71,933 | 1 | 7 | 12 |
65,113 | 1 | 7 | 16 |
83,288 | 1 | 9 | 12 |
73,600 | 1 | 24 | 12 |
58,290 | 1 | 1 | 12 |
67,085 | 1 | 3 | 16 |
65,708 | 1 | 3 | 16 |
74,155 | 1 | 18 | 12 |
69,058 | 1 | 11 | 12 |
71,328 | 1 | 18 | 12 |
48,933 | 1 | 9 | 12 |
61,440 | 1 | 34 | 10 |
60,368 | 1 | 9 | 12 |
58,385 | 1 | 9 | 12 |
65,213 | 1 | 6 | 12 |
70,383 | 1 | 21 | 15 |
58,548 | 1 | 5 | 16 |
70,820 | 1 | 5 | 12 |
57,953 | 1 | 9 | 12 |
82,140 | 1 | 10 | 12 |
62,780 | 1 | 26 | 13 |
72,205 | 1 | 5 | 13 |
75,653 | 1 | 6 | 16 |
64,973 | 1 | 22 | 14 |
82,140 | 1 | 34 | 12 |
47,268 | 1 | 1 | 13 |
72,205 | 1 | 27 | 15 |
48,843 | 1 | 7 | 12 |
53,565 | 1 | 9 | 13 |
55,140 | 1 | 13 | 13 |
77,580 | 1 | 4 | 12 |
61,065 | 1 | 19 | 12 |
51,990 | 1 | 3 | 14 |
56,198 | 1 | 5 | 15 |
79,255 | 1 | 10 | 12 |
61,440 | 1 | 13 | 12 |
88,325 | 1 | 19 | 18 |
51,168 | 1 | 9 | 12 |
55,140 | 1 | 10 | 13 |
51,990 | 1 | 10 | 14 |
71,328 | 1 | 11 | 14 |
71,328 | 1 | 10 | 13 |
66,353 | 1 | 12 | 14 |
51,990 | 1 | 5 | 12 |
77,155 | 1 | 9 | 16 |
84,303 | 1 | 3 | 16 |
45,850 | 1 | 7 | 13 |
52,688 | 1 | 3 | 12 |
48,843 | 1 | 3 | 12 |
53,565 | 1 | 8 | 12 |
84,303 | 1 | 20 | 16 |
56,818 | 1 | 5 | 12 |
64,180 | 0 | 6 | 13 |
58,290 | 0 | 16 | 12 |
61,440 | 0 | 38 | 10 |
50,415 | 0 | 6 | 13 |
61,463 | 0 | 18 | 15 |
51,990 | 0 | 10 | 13 |
47,268 | 1 | 2 | 15 |
58,548 | 1 | 3 | 12 |
68,148 | 0 | 7 | 14 |
64,840 | 0 | 11 | 14 |
75,718 | 0 | 22 | 12 |
57,953 | 0 | 5 | 14 |
56,198 | 0 | 8 | 12 |
56,543 | 0 | 4 | 12 |
57,035 | 0 | 5 | 12 |
69,513 | 0 | 16 | 12 |
82,140 | 0 | 8 | 16 |
47,268 | 0 | 1 | 16 |
55,015 | 1 | 1 | 14 |
55,140 | 1 | 19 | 12 |
58,548 | 1 | 7 | 12 |
74,155 | 1 | 27 | 16 |
82,140 | 1 | 3 | 14 |
63,218 | 1 | 15 | 12 |
71,018 | 1 | 5 | 12 |
79,978 | 1 | 28 | 14 |
78,155 | 0 | 3 | 16 |
86,655 | 0 | 2 | 18 |
97,523 | 0 | 9 | 14 |
86,655 | 0 | 5 | 16 |
112,660 | 0 | 3 | 16 |
112,005 | 0 | 8 | 16 |
90,783 | 0 | 6 | 16 |
107,320 | 0 | 12 | 18 |
89,545 | 0 | 10 | 16 |
79,383 | 0 | 6 | 16 |
98,213 | 0 | 16 | 13 |
121,165 | 0 | 19 | 12 |
83,553 | 0 | 21 | 14 |
103,990 | 0 | 25 | 14 |
112,430 | 0 | 19 | 12 |
88,135 | 0 | 22 | 12 |
119,683 | 0 | 12 | 16 |
126,935 | 0 | 20 | 18 |
85,068 | 0 | 5 | 12 |
103,990 | 0 | 17 | 16 |
123,363 | 0 | 26 | 12 |
128,548 | 0 | 13 | 14 |
86,888 | 0 | 22 | 12 |
105,008 | 0 | 5 | 16 |
77,238 | 0 | 9 | 12 |
115,505 | 0 | 11 | 16 |
133,003 | 0 | 22 | 16 |
112,005 | 0 | 4 | 18 |
115,505 | 0 | 11 | 12 |
136,503 | 0 | 28 | 12 |
90,535 | 0 | 2 | 16 |
82,063 | 0 | 23 | 12 |
119,005 | 0 | 13 | 12 |
115,505 | 0 | 9 | 16 |
72,410 | 0 | 1 | 18 |
112,658 | 0 | 22 | 14 |
115,505 | 0 | 6 | 16 |
93,455 | 0 | 15 | 12 |
78,780 | 0 | 10 | 16 |
74,005 | 0 | 3 | 16 |
96,378 | 0 | 34 | 14 |
119,683 | 0 | 9 | 18 |
119,683 | 0 | 22 | 12 |
96,378 | 0 | 18 | 12 |
92,433 | 0 | 17 | 12 |
115,505 | 0 | 22 | 16 |
98,393 | 0 | 20 | 13 |
103,990 | 0 | 18 | 13 |
74,005 | 0 | 20 | 12 |
125,558 | 0 | 16 | 16 |
121,165 | 0 | 39 | 12 |
103,990 | 0 | 17 | 18 |
122,070 | 0 | 19 | 14 |
108,505 | 0 | 4 | 18 |
98,213 | 0 | 26 | 12 |
114,243 | 0 | 12 | 16 |
103,990 | 0 | 17 | 15 |
95,323 | 0 | 27 | 16 |
118,043 | 0 | 3 | 16 |
104,998 | 0 | 17 | 12 |
114,243 | 0 | 20 | 12 |
87,613 | 0 | 5 | 16 |
110,780 | 0 | 29 | 14 |
121,165 | 0 | 10 | 18 |
76,393 | 0 | 3 | 12 |
114,243 | 0 | 21 | 12 |
83,363 | 0 | 3 | 16 |
90,058 | 0 | 25 | 12 |
87,613 | 0 | 3 | 12 |
108,505 | 0 | 7 | 16 |
76,418 | 0 | 6 | 12 |
99,878 | 0 | 5 | 16 |
109,280 | 0 | 27 | 13 |
85,938 | 0 | 10 | 16 |
129,503 | 0 | 16 | 18 |
88,325 | 0 | 29 | 14 |
107,320 | 0 | 15 | 12 |
117,703 | 0 | 12 | 13 |
103,990 | 0 | 28 | 13 |
86,655 | 0 | 21 | 16 |
71,620 | 0 | 2 | 16 |
115,163 | 0 | 21 | 14 |
101,915 | 0 | 15 | 14 |
114,243 | 0 | 14 | 18 |
112,083 | 0 | 5 | 14 |
99,863 | 0 | 23 | 13 |
108,060 | 0 | 24 | 16 |
95,323 | 0 | 15 | 12 |
95,323 | 0 | 16 | 16 |
100,873 | 0 | 4 | 14 |
106,478 | 0 | 5 | 16 |
72,035 | 0 | 15 | 18 |
101,100 | 0 | 28 | 16 |
86,655 | 0 | 3 | 16 |
85,938 | 0 | 20 | 14 |
83,553 | 0 | 21 | 14 |
83,553 | 0 | 23 | 12 |
128,548 | 0 | 17 | 13 |
74,103 | 0 | 7 | 12 |
98,213 | 0 | 29 | 12 |
119,005 | 0 | 6 | 15 |
108,943 | 0 | 4 | 16 |
118,023 | 0 | 35 | 14 |
85,938 | 0 | 15 | 16 |
83,755 | 0 | 8 | 18 |
135,010 | 0 | 15 | 14 |
119,858 | 0 | 14 | 16 |
122,480 | 0 | 21 | 12 |
83,553 | 0 | 24 | 12 |
85,938 | 0 | 19 | 12 |
124,625 | 0 | 10 | 18 |
95,323 | 0 | 11 | 16 |
77,238 | 0 | 8 | 12 |
117,703 | 0 | 21 | 12 |
120,890 | 0 | 9 | 16 |
92,433 | 0 | 20 | 12 |
102,530 | 0 | 28 | 14 |
89,388 | 0 | 20 | 12 |
98,070 | 0 | 27 | 13 |
102,198 | 0 | 10 | 16 |
122,868 | 0 | 28 | 14 |
105,453 | 0 | 18 | 14 |
88,325 | 0 | 26 | 12 |
112,658 | 0 | 16 | 18 |
95,553 | 0 | 7 | 16 |
138,125 | 1 | 23 | 16 |
128,088 | 1 | 38 | 16 |
124,625 | 1 | 16 | 18 |
115,258 | 1 | 19 | 16 |
94,568 | 1 | 5 | 14 |
117,533 | 1 | 9 | 16 |
122,505 | 1 | 18 | 16 |
112,658 | 1 | 31 | 18 |
76,393 | 1 | 10 | 18 |
97,533 | 1 | 19 | 15 |
103,858 | 1 | 4 | 16 |
117,703 | 1 | 7 | 16 |
96,835 | 1 | 4 | 16 |
131,548 | 1 | 18 | 16 |
120,760 | 1 | 6 | 15 |
90,308 | 1 | 2 | 16 |
129,503 | 1 | 28 | 16 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL