Question
Add dummy variables to the Excel Spreadsheet to include SEX Perform a correlation of Increase, Work Quality, Experience, and Sex and copy and paste the
Add dummy variables to the Excel Spreadsheet to include SEX Perform a correlation of Increase, Work Quality, Experience, and Sex and copy and paste the Excel output her 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
Discuss the outputs under the following headings
Correlation Coefficient of determination Adjusted coefficient of determination Standard Error F-test: Is at least one of the independent variables significantly related to the dependent variable? Explain in detail. Explain:
Add dummy variables for Division . 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
Discuss the changes in the outputs under the following headings
Correlation Coefficient of determination Adjusted coefficient of determination Standard Error Look up the critical F-test value from the table Answer:
For the F-test: should you accept or reject the Null Hypothesis? Discuss:
For the t-test, look up the critical value from the tables. Answer:
Evaluate the coefficients according to the t-test Discuss:
Evaluate the coefficients according to the p-values Describe the coefficients associated with each of the independent variables After looking at the coefficients, is there any change you would like to make to the model and why? 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 Discuss:
What will the calculated salary increase be for:
Female, experience 5, work quality 50, production Male, experience 5, work quality 50, production Female, experience 5, work quality 50, research Male, experience 5, work quality 50, research What recommendation will you make to the law firm?
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 with AI-Powered 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