Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Add dummy variables to the Excel Spreadsheet to include SEX (2) Perform a correlation of Increase, Work Quality, Experience, and Sex and copy and paste
- Add dummy variables to the Excel Spreadsheet to include SEX (2)
- Perform a correlation of Increase, Work Quality, Experience, and Sex and copy and paste the Excel output here (5)
Paste here:
- Perform regression analysis with Increase as the dependent variable and Sex, Work Quality and Experience as independent variables. Copy and paste the Regression Statistics here (5)
Paste here4.
- Discuss the outputs under the following headings
- Correlation (2)
Discuss:
- Coefficient of determination (3)
Discuss:
- Adjusted coefficient of determination (2)
Discuss:
- Standard Error (2)
Discuss:
- F-test: Is at least one of the independent variables significantly related to the dependent variable? Explain in detail. (4)
Explain:
- Add dummy variables for Division (2)
- . Perform a second regression analysis with Increase as the dependent variable and Sex, Work Quality, Experience and division as independent variables copy and paste the Excel regression output here (5)
Paste here:
- Discuss the changes in the outputs under the following headings
- Correlation (2)
Discuss:
- Coefficient of determination (3)
Discuss:
- Adjusted coefficient of determination (2)
Discuss:
- Standard Error (2)
Discuss:
- Look up the critical F-test value from the table (3)
Answer:
- For the F-test: should you accept or reject the Null Hypothesis? (2)
Discuss:
- For the t-test, look up the critical value from the tables (3)
Answer:
- Evaluate the coefficients according to the t-test (5)
Discuss:
- Evaluate the coefficients according to the p-values (5)
Discuss:
- Describe the coefficients associated with each of the independent variables (5)
Discuss:
- After looking at the coefficients, is there any change you would like to make to the model and why? (5)
Discuss:
- If you made a change, perform a new regression analysis.
Paste new regression output from Excel ONLY IF YOU MADE CHANGES)
- Discuss the Point Estimates for each of the independent variables (5)
Discuss:
- What will the calculated salary increase be for:
- Female, experience 5, work quality 50, production (2)
Answer:
- Male, experience 5, work quality 50, production (2)
Answer:
- Female, experience 5, work quality 50, research (2)
Answer:
- Male, experience 5, work quality 50, research (2)
Answer:
- What recommendation will you make to the law firm? (5)
Answer:
File | Increase | Division | Sex | Work Qual | Experience |
1 | 21.00 | Production | F | 10 | 9 |
2 | 96.00 | Production | F | 90 | 1 |
3 | 47.00 | Production | F | 20 | 4 |
4 | 128.00 | Production | F | 80 | 1 |
5 | 64.00 | Research | F | 30 | 4 |
6 | 52.00 | Research | F | 70 | 1 |
7 | 73.00 | Sales | F | 10 | 4 |
8 | 19.00 | Production | F | 15 | 7 |
9 | 200.00 | Sales | F | 80 | 5 |
10 | 128.00 | Research | M | 20 | 6 |
11 | 474.00 | Sales | M | 80 | 3 |
12 | 342.00 | Research | M | 50 | 3 |
13 | 330.00 | Sales | M | 70 | 2 |
14 | 185.00 | Sales | M | 30 | 7 |
15 | 331.00 | Sales | M | 70 | 7 |
16 | 267.00 | Sales | M | 40 | 1 |
17 | 517.00 | Production | M | 90 | 6 |
18 | 390.00 | Production | M | 50 | 8 |
19 | 269.00 | Research | M | 60 | 5 |
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