Exhibit 17.2.To examine the differences between salaries of male and female middle managers of a large bank,90 individuals were randomly selected and the following variables considered: Salary = the monthly salary (excluding fringe benefits and bonuses) ,
Educ = the number of years of education,
Exper = the number of months of experience,
Train = the number of weeks of training,
Gender = the gender of an individual;1 for males,and 0 for females.
Also,the following Excel partial outputs corresponding to the following models are available:
Model A: Salary = β₀ + β₁Educ + β₂Exper + β₃Train + β₄Gender + ε Model B: Salary = β₀ + β₁Educ + β₂Exper + β₃Gender + ε Refer to Exhibit 17.2.What is the regression equation found by Excel for Model A?

Question

Exhibit 17.2.To examine the differences between salaries of male and female middle managers of a large bank,90 individuals were randomly selected and the following variables considered: Salary = the monthly salary (excluding fringe benefits and bonuses) ,
Educ = the number of years of education,
Exper = the number of months of experience,
Train = the number of weeks of training,
Gender = the gender of an individual;1 for males,and 0 for females.
Also,the following Excel partial outputs corresponding to the following models are available:
Model A: Salary = β₀ + β₁Educ + β₂Exper + β₃Train + β₄Gender + ε

Model B: Salary = β₀ + β₁Educ + β₂Exper + β₃Gender + ε

Refer to Exhibit 17.2.What is the regression equation found by Excel for Model A?

Quizplus · Accepted Answer

The regression equation found by Excel for Model A is Salary = 4663.31 + 140.66Educ + 3.36Exper + 1.17Train + 615.15Gender, as indicated by the coefficients (β values) for each variable in the model output.