Fortune magazine publishes an annual list of the best compan

Fortune magazine publishes an annual list of the  best companies to work for. The data in the file named FortuneBest shows a portion of the data for a random sample of  of the companies that made the top 100 list for 2012 (Fortune, February 6, 2012). The column labeled Rank shows the rank of the company in the Fortune 100 list; the column labeled Size indicates whether the company is a small, midsize, or large company; the column labeled Salaried (s) shows the average annual salary for salaried employees rounded to the nearest ; and the column labeled Hourly (s) shows the average annual salary for hourly employees rounded to the nearest . Fortune defines large companies as having more than  employees, midsize companies as having between  and employees, and small companies as having fewer than  employees.

A Use these data to develop an estimated regression equation that could be used to predict the average annual salary for salaried employees given the average annual salary for hourly employees.

B Use .05 to test for overall significance.

C. To incorporate the effect of size, a categorical variable with three levels, we used two dummy variables: Size-Midsize and Size-Small . The value of Size-Midsize =1  if the company is a midsize company and  otherwise. And, the value of Size-Small =1  if the company is a small company and  otherwise. Develop an estimated regression equation that could be used to predict the average annual salary for salaried employees given the average annual salary for hourly employees and the size of the company.

d. For the estimated regression equation developed in part (c), use the  test to determine the significance of the independent variables. Use .5 level

e. Based upon your findings in part (d), develop an estimated regression equation that can be used to predict the average annual salary for salaried employees given the average annual salary for hourly employees and the size of the company.

Solution