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