Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

I HAVE THE REST OF THE FILE WITH THE DATA IF YOU CAN SOLVE THIS!!! This database

ID: 2986866 • Letter: I

Question

I HAVE THE REST OF THE FILE WITH THE DATA IF YOU CAN SOLVE THIS!!!


This database contains information of a sample of 935 sales associates.  You are trying to find out if years of education, years of experience, as well as age, gender and marital status has an effecton the weekly earnings of these employees. For instance, if an additional year of education affects salaries?  Is gender or marital status relevant to explain weekly earnings?

a) Estimate a multiple linear regression of Salary on the independent variables Education, Experience, Age, Married and Gender.   The regression equation is:

b) Write down the hypothesis that you are testing for the variables Education and Married and explain your conclusions (what does it mean to reject or not the null hypothesis, in plain english)

c) What portion of the variation in Weekly Salary is explained by the 5 independent variables?

d) Are the coefficients statistically significant at 95% confidence level? Interpret the coefficients of the variables Experience and Gender

e) Suppose that Matthew has 15 years of education, 10 years of experience, 35 years old, and he is married while Mary has 12 years of education, 5 years of experience, 30

f) What is the predicted difference in weekly salary between Matthew and Mary? What is your conclusion based on this difference?

variable

variable label

salary

weekly earnings

education

years of education

experience

years of work experience

age

age in years

married

1 if married

gender

1 if female

  

variable

     

variable label

     

salary

     

weekly earnings

     

education

     

years of education

     

experience

     

years of work experience

     

age

     

age in years

     

married

     

1 if married

     

gender

     

1 if female

  

Explanation / Answer

Here is the answer

https://docs.google.com/file/d/0ByGDC0zAeqvieDR3T205MXdEVHc/edit?usp=sharing

and please rate