Fortune magazine publishes an annual list of the 100 best companies to work for. The data in the WEBfile named FortuneBest show a portion of the data for a random sample of 30 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 ($1000s) shows the average annual salary for salaried employees rounded to the nearcst $1000; and the column labeled Hourly ($1000s) shows the average annual salary for hourly employces rounded to the nearest $1000. Fortune defines large companies as having more than 10,000 employecs, midsize companies as having between 2500 and 10,000 cmployees, and small companies as having fewer than 2500 employees. Salaried Hourly ($1000s) Eank Company Size ($1000s) 4 Wegmans Food Markets NetApp Camden Property Trust Recreational Equipment (REI) Quicken Loans Zappos.com Mercedes-Benz USA USAA Large Midsize 56 29 143 76 Small 71 37 Large Midsize 103 28 10 78 54 11 Midsize 48 25 12 Small 118 50 20 22 25 ell Large Midsize 96 47 The Container Store Ultimate Software Plante Moran Baptist Health South Florida World Wide Technology Methodist Hospital Perkins Coie 71 45 Small 166 56 37 Small 73 45 42 50 53 58 Large Small 126 80 129 31 Large Small 100 189 83 63 American Express TDIndustries 60 Large Small 114 35 54 93 47 American Express 60 Large Small Large Small 114 35 64 TDIndustries QuikTrip EOG Resources FactSet Research Systems Stryker SRC 93 47 44 66 69 72 189 81 75 Small 103 51 80 81 Large Small 71 43 33 84 Booz Allen Hamilton CarMax 84 91 93 94 Large Large Midsize 77 34 105 57 GoDaddy.com KPMG 105 79 77 71 Large Midsize Small Large Large 59 39 95 Navy Federal Credit Union Schweitzer Engineering Labs Darden Restaurants Intercontinental Hotels Group 97 99 99 28 57 24 100 63 26 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 a = .05 to test for overall significance. 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 the company is a midsize company and 0 otherwise. And the value of Size-Small = 1 if the company is a small company and 0 otherwise. Develop an estimated regression equation that could be uscd to predict the average annual salary for salaried employees given the average annual salary for hourly cmployees and the size of the company. d. For the estimated regression equation developed in part (c), usc the t test to determinc the significance of the independent variables. Use a = .05. a. c. 1 if
Fortune magazine publishes an annual list of the 100 best companies to work for. The data in the WEBfile named FortuneBest show a portion of the data for a random sample of 30 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 ($1000s) shows the average annual salary for salaried employees rounded to the nearcst $1000; and the column labeled Hourly ($1000s) shows the average annual salary for hourly employces rounded to the nearest $1000. Fortune defines large companies as having more than 10,000 employecs, midsize companies as having between 2500 and 10,000 cmployees, and small companies as having fewer than 2500 employees. Salaried Hourly ($1000s) Eank Company Size ($1000s) 4 Wegmans Food Markets NetApp Camden Property Trust Recreational Equipment (REI) Quicken Loans Zappos.com Mercedes-Benz USA USAA Large Midsize 56 29 143 76 Small 71 37 Large Midsize 103 28 10 78 54 11 Midsize 48 25 12 Small 118 50 20 22 25 ell Large Midsize 96 47 The Container Store Ultimate Software Plante Moran Baptist Health South Florida World Wide Technology Methodist Hospital Perkins Coie 71 45 Small 166 56 37 Small 73 45 42 50 53 58 Large Small 126 80 129 31 Large Small 100 189 83 63 American Express TDIndustries 60 Large Small 114 35 54 93 47 American Express 60 Large Small Large Small 114 35 64 TDIndustries QuikTrip EOG Resources FactSet Research Systems Stryker SRC 93 47 44 66 69 72 189 81 75 Small 103 51 80 81 Large Small 71 43 33 84 Booz Allen Hamilton CarMax 84 91 93 94 Large Large Midsize 77 34 105 57 GoDaddy.com KPMG 105 79 77 71 Large Midsize Small Large Large 59 39 95 Navy Federal Credit Union Schweitzer Engineering Labs Darden Restaurants Intercontinental Hotels Group 97 99 99 28 57 24 100 63 26 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 a = .05 to test for overall significance. 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 the company is a midsize company and 0 otherwise. And the value of Size-Small = 1 if the company is a small company and 0 otherwise. Develop an estimated regression equation that could be uscd to predict the average annual salary for salaried employees given the average annual salary for hourly cmployees and the size of the company. d. For the estimated regression equation developed in part (c), usc the t test to determinc the significance of the independent variables. Use a = .05. a. c. 1 if
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 3 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman