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
icon
Related questions
Question
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
Transcribed Image Text: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
Transcribed Image Text: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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman