Training Dept. of Nimrod Inc wants to develop a regression-based compensation model (compensation in $ per year, Comp) for its mid-level managers to encourage performance, loyalty, and continuing education based on three variables. ▪ Business unit-profitability (Profit per year in $). ▪ Working experiences in Nimrod Inc (Years). ▪ Whether or not a manager has a graduate degree (Grads). If a manager has a graduate degree equals 1, 0 otherwise. Table Attached Question: At the 5% significance level, is the overall regression model significant

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
icon
Concept explainers
Question

Training Dept. of Nimrod Inc wants to develop a regression-based compensation model (compensation in $ per year, Comp) for its mid-level managers to encourage performance, loyalty, and continuing education based on three variables.

▪ Business unit-profitability (Profit per year in $).

▪ Working experiences in Nimrod Inc (Years).

▪ Whether or not a manager has a graduate degree (Grads). If a manager has a graduate degree equals 1, 0 otherwise.

Table Attached

Question:

At the 5% significance level, is the overall regression model significant

Table 1. Data Collected for 36 Managers
Comp
Profit
Years
Grad
236.200
9.000.000
37
181.600
10.800.000
1
170.000
8.400.000
29
The following Table 2 shows the regression result.
Table 2. Regression Results.
Regression Statistics
Multiple R
0,916759383
R Square
0,840447766
Adjusted R Square
0,813855727
Standard Error
16888,68274
Observations
36
ANOVA
df
SS
MS
Significance F
Regression
5
4,5073E+10 9014686817 31,6052397
4,271E-11
Residual
30
8556828138
285227605
Total
35
5,363E+10
Coefficients
Standard Error
t Stat
P-value
Intercept
5354,378366
20815,993
0,25722426
0,798762
Profit
0,010315404
0,00183083
5,63427742
0,000004
Years
2455,373172
554,351395 4,42927211
0,000116
Grad
73310,27264
24595,2312
2,9806702
0,005658
Profit*grad
-0,000522662
0,00245843
-0,2126004
0,833077
Transcribed Image Text:Table 1. Data Collected for 36 Managers Comp Profit Years Grad 236.200 9.000.000 37 181.600 10.800.000 1 170.000 8.400.000 29 The following Table 2 shows the regression result. Table 2. Regression Results. Regression Statistics Multiple R 0,916759383 R Square 0,840447766 Adjusted R Square 0,813855727 Standard Error 16888,68274 Observations 36 ANOVA df SS MS Significance F Regression 5 4,5073E+10 9014686817 31,6052397 4,271E-11 Residual 30 8556828138 285227605 Total 35 5,363E+10 Coefficients Standard Error t Stat P-value Intercept 5354,378366 20815,993 0,25722426 0,798762 Profit 0,010315404 0,00183083 5,63427742 0,000004 Years 2455,373172 554,351395 4,42927211 0,000116 Grad 73310,27264 24595,2312 2,9806702 0,005658 Profit*grad -0,000522662 0,00245843 -0,2126004 0,833077
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE 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