# Question

The file P02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies.

a. Estimate a multiple regression equation to explain the variation in employee salaries at Beta Technologies using all of the potential explanatory variables.

b. Using the regression output, determine which of the explanatory variables, if any, should be excluded from the regression equation. Justify your choices.

c. Regardless of your answer to part b, exclude the least significant variable (not counting the constant) and estimate the resulting equation. Would you conclude that this equation and the one from part a are equally good? Explain.

a. Estimate a multiple regression equation to explain the variation in employee salaries at Beta Technologies using all of the potential explanatory variables.

b. Using the regression output, determine which of the explanatory variables, if any, should be excluded from the regression equation. Justify your choices.

c. Regardless of your answer to part b, exclude the least significant variable (not counting the constant) and estimate the resulting equation. Would you conclude that this equation and the one from part a are equally good? Explain.

## Answer to relevant Questions

Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence such a stock ...A regional express delivery service company recently conducted a study to investigate the relationship between the cost of shipping a package (Y), the package weight (X1), and the distance shipped (X2). Twenty packages were ...A company produces electric motors for use in home appliances. One of the company’s production managers is interested in examining the relationship between the dollars spent per month in inspecting finished motor products ...The file P11_45.xlsx contains monthly sales for a photography studio and the price charged per portrait during each month. Use regression to estimate an equation for predicting the current month’s sales from last month’s ...The file P11_54.xlsx contains monthly data on fatal automobile crashes in the U.S. in each of eight three-hour intervals. Suppose you didn’t have the data on the midnight to 3AM time interval. How well could multiple ...Post your question

0