# Question: The human resources manager of DataCom Inc wants to predict

The human resources manager of DataCom, Inc., wants to predict the annual salaries of given employees using the potential explanatory variables in the file P10_05.xlsx.

a. Estimate an appropriate multiple regression equation to predict the annual salary of a given DataCom employee using all of the data in columns C–H.

b. Interpret the estimated regression coefficients.

c. According to the estimated regression model, is there a difference between the mean salaries earned by male and female employees at DataCom? If so, how large is the difference? According to your equation, does this difference depend on the values of the other explanatory variables? Explain.

d. According to the estimated regression model, is there a difference between the mean salaries earned by employees in the sales department and those in the advertising department at DataCom? If so, how large is the difference? According to your equation, does this difference depend on the values of the other explanatory variables? Explain.

e. According to the estimated regression model, in which department is DataCom employees paid the highest mean salary? In which department are DataCom employees paid the lowest mean salary?

f. Given the estimated regression model, predict the annual salary of a female employee who served in a similar department at another company for 10 years prior to coming to work at DataCom. This woman, a graduate of a four-year collegiate business program, has been supervising 12 subordinates in the purchasing department since joining the organization five years ago.

a. Estimate an appropriate multiple regression equation to predict the annual salary of a given DataCom employee using all of the data in columns C–H.

b. Interpret the estimated regression coefficients.

c. According to the estimated regression model, is there a difference between the mean salaries earned by male and female employees at DataCom? If so, how large is the difference? According to your equation, does this difference depend on the values of the other explanatory variables? Explain.

d. According to the estimated regression model, is there a difference between the mean salaries earned by employees in the sales department and those in the advertising department at DataCom? If so, how large is the difference? According to your equation, does this difference depend on the values of the other explanatory variables? Explain.

e. According to the estimated regression model, in which department is DataCom employees paid the highest mean salary? In which department are DataCom employees paid the lowest mean salary?

f. Given the estimated regression model, predict the annual salary of a female employee who served in a similar department at another company for 10 years prior to coming to work at DataCom. This woman, a graduate of a four-year collegiate business program, has been supervising 12 subordinates in the purchasing department since joining the organization five years ago.

## Relevant Questions

Does the rate of violent crime acts vary across different regions of the United States? Answer this with the (somewhat old), 1999 data in the file P10_34.xlsx as requested below.a. Estimate an appropriate regression model to ...Many companies manufacture products that are at least partially produced using chemicals (e.g., paint, gasoline, and steel). In many cases, the quality of the finished product is a function of the temperature and pressure at ...Continuing the previous problem, explore whether the beta for these companies changes through time. For example, are the betas based on 1990s data different from those based on 2000s data? Or are data based on only five ...The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced are the better measure of activity for ...Do increased taxes increase or decrease economic growth? The file P10_63.xlsx lists tax revenues as a percentage of gross domestic products (GDP) and the average annual percentage growth in GDP per capita for nine countries ...Post your question