1. Add dummy variables to the Excel Spreadsheet to include SEX (2)
2. Perform a correlation of Increase, Work Quality, Experience, and Sex and copy and paste the Excel output here (5)

Paste here:

1. 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.

1. Discuss the outputs under the following headings
   1. Correlation (2)

Discuss:

1. Coefficient of determination (3)

Discuss:

1. Adjusted coefficient of determination (2)

Discuss:

1. Standard Error (2)

Discuss:

1. F-test: Is at least one of the independent variables significantly related to the dependent variable? Explain in detail. (4)

Explain:

1. Add dummy variables for Division (2)
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:

1. Discuss the changes in the outputs under the following headings
   1. Correlation (2)

Discuss:

1. Coefficient of determination (3)

Discuss:

1. Adjusted coefficient of determination (2)

Discuss:

1. Standard Error (2)

Discuss:

1. Look up the critical F-test value from the table (3)

Answer:

1. For the F-test: should you accept or reject the Null Hypothesis? (2)

Discuss:

1. For the t-test, look up the critical value from the tables (3)

Answer:

1. Evaluate the coefficients according to the t-test (5)

Discuss:

1. Evaluate the coefficients according to the p-values (5)

Discuss:

1. Describe the coefficients associated with each of the independent variables (5)

Discuss:

1. After looking at the coefficients, is there any change you would like to make to the model and why? (5)

Discuss:

1. If you made a change, perform a new regression analysis.

Paste new regression output from Excel ONLY IF YOU MADE CHANGES)

1. Discuss the Point Estimates for each of the independent variables (5)

Discuss:

1. What will the calculated salary increase be for:
   1. Female, experience 5, work quality 50, production (2)

Answer:

1. Male, experience 5, work quality 50, production (2)

Answer:

1. Female, experience 5, work quality 50, research (2)

Answer:

1. Male, experience 5, work quality 50, research (2)

Answer:

1. 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