Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Run a regression analysis to estimate staring salary based on academic performance (GMAT score and GPA), and years of work experience, including interaction with the
Run a regression analysis to estimate staring salary based on academic performance (GMAT score and GPA), and years of work experience, including interaction with the gender variable.
- What does your final model reveal about the relationship between salary, academic performance, and work experience? Think about the relationship of each of the variables as well as any significant interactions you have identified.
- How good is your model?
gmat_tot | salary | work_yrs | sex | Gender_DV | Gender_GMAT | Gender_GPA | Gender_WorkYear |
660 | 85000 | 1 | 2 | 0 | 0 | 0 | 0 |
700 | 85000 | 2 | 2 | 0 | 0 | 0 | 0 |
680 | 86000 | 2 | 2 | 0 | 0 | 0 | 0 |
650 | 88000 | 3 | 2 | 0 | 0 | 0 | 0 |
710 | 92000 | 2 | 1 | 1 | 710 | 3.4 | 2 |
620 | 93000 | 5 | 2 | 0 | 0 | 0 | 0 |
670 | 95000 | 0 | 1 | 1 | 670 | 3.28 | 0 |
560 | 95000 | 1 | 2 | 0 | 0 | 0 | 0 |
530 | 95000 | 3 | 2 | 0 | 0 | 0 | 0 |
650 | 96000 | 1 | 1 | 1 | 650 | 3.4 | 1 |
590 | 96000 | 4 | 2 | 0 | 0 | 0 | 0 |
650 | 100000 | 2 | 2 | 0 | 0 | 0 | 0 |
560 | 100000 | 2 | 1 | 1 | 560 | 3.54 | 2 |
610 | 100000 | 6 | 1 | 1 | 610 | 3.4 | 6 |
650 | 105000 | 2 | 1 | 1 | 650 | 3.15 | 2 |
550 | 105000 | 3 | 1 | 1 | 550 | 3.5 | 3 |
570 | 105000 | 3 | 1 | 1 | 570 | 3.65 | 3 |
580 | 105000 | 2 | 1 | 1 | 580 | 3.48 | 2 |
600 | 105000 | 5 | 1 | 1 | 600 | 3.28 | 5 |
570 | 105000 | 6 | 1 | 1 | 570 | 3.55 | 6 |
620 | 106000 | 8 | 1 | 1 | 620 | 3.25 | 8 |
680 | 106000 | 6 | 2 | 0 | 0 | 0 | 0 |
630 | 107500 | 3 | 1 | 1 | 630 | 3.28 | 3 |
600 | 108000 | 3 | 1 | 1 | 600 | 3.38 | 3 |
640 | 110000 | 6 | 2 | 0 | 0 | 0 | 0 |
600 | 112000 | 16 | 1 | 1 | 600 | 3.55 | 16 |
570 | 115000 | 4 | 1 | 1 | 570 | 3.85 | 4 |
710 | 115000 | 1 | 1 | 1 | 710 | 3.55 | 1 |
620 | 118000 | 10 | 1 | 1 | 620 | 3.5 | 10 |
600 | 120000 | 3 | 1 | 1 | 600 | 3.25 | 3 |
700 | 120000 | 5 | 1 | 1 | 700 | 3.9 | 5 |
600 | 120000 | 5 | 1 | 1 | 600 | 3.38 | 5 |
670 | 120000 | 8 | 2 | 0 | 0 | 0 | 0 |
630 | 146000 | 15 | 1 | 1 | 630 | 2 | 15 |
700 | 162000 | 1 | 1 | 1 | 700 | 3.68 | 1 |
670 | 82000 | 1 | 2 | 0 | 0 | 0 | 0 |
620 | 92000 | 2 | 2 | 0 | 0 | 0 | 0 |
540 | 93000 | 8 | 1 | 1 | 540 | 3.05 | 8 |
670 | 95000 | 2 | 1 | 1 | 670 | 3.35 | 2 |
610 | 95000 | 3 | 1 | 1 | 610 | 3.26 | 3 |
560 | 96000 | 2 | 1 | 1 | 560 | 3.23 | 2 |
500 | 96500 | 2 | 1 | 1 | 500 | 2.88 | 2 |
590 | 98000 | 2 | 1 | 1 | 590 | 3.23 | 2 |
570 | 98000 | 2 | 1 | 1 | 570 | 3.23 | 2 |
570 | 98000 | 3 | 2 | 0 | 0 | 0 | 0 |
580 | 99000 | 5 | 2 | 0 | 0 | 0 | 0 |
580 | 100000 | 2 | 2 | 0 | 0 | 0 | 0 |
560 | 100000 | 4 | 1 | 1 | 560 | 3.05 | 4 |
620 | 101000 | 2 | 2 | 0 | 0 | 0 | 0 |
620 | 103000 | 3 | 1 | 1 | 620 | 3.1 | 3 |
560 | 104000 | 4 | 1 | 1 | 560 | 3.23 | 4 |
680 | 105000 | 3 | 1 | 1 | 680 | 3.23 | 3 |
620 | 105000 | 3 | 1 | 1 | 620 | 3 | 3 |
550 | 105000 | 16 | 1 | 1 | 550 | 3 | 16 |
600 | 107000 | 2 | 1 | 1 | 600 | 3.3 | 2 |
670 | 112000 | 6 | 1 | 1 | 670 | 3.05 | 6 |
620 | 115000 | 1 | 1 | 1 | 620 | 3.13 | 1 |
630 | 115000 | 4 | 1 | 1 | 630 | 3.1 | 4 |
650 | 130000 | 4 | 1 | 1 | 650 | 3.23 | 4 |
620 | 145800 | 2 | 1 | 1 | 620 | 3.05 | 2 |
520 | 78256 | 1 | 2 | 0 | 0 | 0 | 0 |
620 | 88500 | 3 | 1 | 1 | 620 | 2.73 | 3 |
580 | 90000 | 2 | 1 | 1 | 580 | 3.08 | 2 |
630 | 90000 | 2 | 1 | 1 | 630 | 2.6 | 2 |
610 | 93000 | 4 | 1 | 1 | 610 | 2.73 | 4 |
560 | 95000 | 5 | 2 | 0 | 0 | 0 | 0 |
620 | 97000 | 4 | 1 | 1 | 620 | 2.83 | 4 |
580 | 97000 | 3 | 1 | 1 | 580 | 2.9 | 3 |
670 | 98000 | 2 | 2 | 0 | 0 | 0 | 0 |
560 | 98000 | 2 | 2 | 0 | 0 | 0 | 0 |
580 | 98000 | 2 | 2 | 0 | 0 | 0 | 0 |
680 | 98000 | 2 | 1 | 1 | 680 | 2.83 | 2 |
610 | 98000 | 4 | 1 | 1 | 610 | 2.85 | 4 |
710 | 98000 | 7 | 1 | 1 | 710 | 3.08 | 7 |
710 | 100000 | 3 | 1 | 1 | 710 | 2.95 | 3 |
630 | 100000 | 2 | 2 | 0 | 0 | 0 | 0 |
600 | 101000 | 2 | 2 | 0 | 0 | 0 | 0 |
660 | 101100 | 8 | 1 | 1 | 660 | 2.9 | 8 |
670 | 102500 | 6 | 1 | 1 | 670 | 2.78 | 6 |
580 | 105000 | 2 | 1 | 1 | 580 | 2.87 | 2 |
680 | 106000 | 6 | 1 | 1 | 680 | 2.95 | 6 |
660 | 107300 | 2 | 1 | 1 | 660 | 3.2 | 2 |
570 | 108000 | 4 | 1 | 1 | 570 | 2.95 | 4 |
680 | 112000 | 2 | 1 | 1 | 680 | 2.78 | 2 |
560 | 64000 | 2 | 2 | 0 | 0 | 0 | 0 |
660 | 77000 | 2 | 1 | 1 | 660 | 2.75 | 2 |
720 | 85000 | 3 | 2 | 0 | 0 | 0 | 0 |
620 | 85000 | 2 | 1 | 1 | 620 | 2.2 | 2 |
630 | 86000 | 3 | 2 | 0 | 0 | 0 | 0 |
650 | 90000 | 5 | 1 | 1 | 650 | 2.33 | 5 |
660 | 92000 | 2 | 1 | 1 | 660 | 3.33 | 2 |
610 | 95000 | 2 | 1 | 1 | 610 | 2.58 | 2 |
600 | 96000 | 2 | 1 | 1 | 600 | 2.5 | 2 |
570 | 98000 | 2 | 1 | 1 | 570 | 2.4 | 2 |
600 | 100000 | 2 | 2 | 0 | 0 | 0 | 0 |
650 | 100000 | 2 | 2 | 0 | 0 | 0 | 0 |
630 | 100400 | 3 | 1 | 1 | 630 | 2.55 | 3 |
630 | 101600 | 3 | 1 | 1 | 630 | 2.68 | 3 |
530 | 104000 | 4 | 1 | 1 | 530 | 2.58 | 4 |
580 | 105000 | 2 | 1 | 1 | 580 | 2.1 | 2 |
540 | 115000 | 3 | 1 | 1 | 540 | 2.55 | 3 |
550 | 126710 | 3 | 1 | 1 | 550 | 2.68 | 3 |
500 | 220000 | 15 | 2 | 0 | 0 | 0 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started