Answered step by step
Verified Expert Solution
Link Copied!

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

  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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia Libby

5th edition

78025915, 978-1259115400, 1259115402, 978-0078025914

More Books

Students also viewed these Mathematics questions

Question

3. Im trying to point out what we need to do to make this happen

Answered: 1 week ago

Question

1. I try to create an image of the message

Answered: 1 week ago