Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

o Employee Salaries provides data for 35 employees, including their age, whether they hold an MBA and the salary they receive. o We would like

o Employee Salaries provides data for 35 employees, including their age, whether they hold an MBA and the salary they receive.

o We would like to understand how their age and whether they hold an MBA affects their salary

Create a dummy variable to represent whether the employee has an MBA or not

Regression 1: Conduct a regression predicting salary with MBA and age.

Create an interaction variable MBA_Age_interaction by multiplying Age and MBA dummy variable.

Regression 2: Conduct a regression predicting salary with MBA, Age and MBA_Age_interaction

For both regressions, drop any variables that are insignificant and rerun regression if needed.

Which regression has a better fit? Provide evidence.

Using the regression with better fit,

- Which of the following statements would you agree with? Provide evidence.

a) Doing an MBA has no effect on salary

b) An MBA degree significantly increases salary from day 1

c) Those with MBA degrees have a higher increase in their salary with age

- Provide a point estimate for an 35 year employee with an MBA, and the associated 95% interval.

EmployeeSalaryAgeMBA
12826025No
24339228Yes
35632237Yes
42608623No
53680732No
65711957No
74890745No
83430132No
93110425No
106005457No
114142042No
123650825Yes
134001538No
144832947No
153984938No
163198531No
175916054No
186033559No
193591132No
205781455No
214237736No
226243060No
234692849No
243440335No
254571432Yes
264224727Yes
275478952No
283170230No
293440633No
308487657Yes
312739924No
325578551No
333464930No
346423661No
355024145No

Step by Step Solution

3.52 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

EXPERT ANSWER Well be using excel Megastat to run the regression analysis First well build the data ... 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

Bank Management and Financial Services

Authors: Peter Rose, Sylvia Hudgins

9th edition

78034671, 978-0078034671

More Books

Students also viewed these Accounting questions

Question

How is the expected yield on most bonds determined?

Answered: 1 week ago