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

Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)
6th Edition
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Bruce Crauder, Benny Evans, Alan Noell
Chapter3: Straight Lines And Linear Functions
Section3.4: Linear Regression
Problem 12SBE: Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4
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.
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt