Question: You are asked to build a model to explain the factors which determine university faculty salaries. The Excel sheet with this assessment includes the data

You are asked to build a model to explain the
You are asked to build a model to explain the
You are asked to build a model to explain the factors which determine university faculty salaries. The Excel sheet with this assessment includes the data for the study. Models, similar to the following, are used to guide decisions on faculty salaries and salaries in other industries, which include court. The data include the following: Salary = the annual salary of the faculty. Performance = as measure by dean and faculty evaluations. Age = age of the faculty member. Student Approval = as measured by student assessment surveys. Gender = a dummy variable to measure the faculty members gender (female =1 and Male =0). School = a dummy variable to measure the school (general discipline) the faculty member teaches (Business =1 and Arts and Science =0 ). You are asked to estimate four regression equations: 1. Salary =b0+b1 Performance +b2Age+b3 Student Approval +b4DGender 2. Salary =b0+b1 Performance +b2Age+b3 Student Approval +b5Dschool 3. Salary =b0+b1 Performance +b2Age+b3 Student Approval +b4DGender+b5Dsehool a. Which equation explains the variation in faculty salary best? Why/Explain. b. Reviewing all 3 equations which estimated coefficients consistently significant different from 0 at the 5%(=0.05) level? Which coefficients are consistently insignificant at the 5% level? Assume a 2-tailed hypothesis test. c. Given the results in totality does it appear female faculty are paid more or less than male faculty? Why/Explain. d. Given the results in totality does it appear faculty in schools of business are paid more or less than faculty in the Arts \& Sciences. e. Using estimated equation 3, what would you expect a faculty salary to be given the following information: Performance =15;Age=40; Student Approval =86; and the faculty member is a female teaching in the school of business. f. Using estimated equation 3, what would you expect a faculty salary to be given the following information: Performance =15; Age =40; Student Approval =86; and the faculty member is a male teaching in the school of business. g. Given the results of the 3rd equation statistical results are female faculty being discriminated against

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!