Question

In: Math

The board of directors at a large corporation wants to base their division managers' pay raises...

The board of directors at a large corporation wants to base their division managers' pay raises on the profit performance of their respective divisions. They have asked you to evaluate the performance and raises at other companies and propose a formula for calculating the percentage increase in base pay based on the percentage change in the division's profit. You collected information from 50 divisions at similar companies and performed a linear regression on the percentage change in the division profits vs. the percentage change in the manager’s salary.


Use what you have learned about linear regression to answer the following questions. Click here to download the output from the Excel ToolPak, Regression Tool.


Response Parameters


What is the regression equation from the Summary Output? Is this a useful model? How do you know?


Are the assumptions of regression satisfied? How did you verify them?


Does change in division profit appear to be a good predictor for the manager’s pay raise? Why do you think that?


One of your company’s divisions had a –0.51 percent change in profits last year, while another had a 20 percent increase. What is the predicted percentage change in salary for these two division managers?


Solutions

Expert Solution

Answers,

1)

General simple linear regression equation is,

,

b0 = intercept parameter and b1 = Slope parameter.

Then regression equation is,

managers salary =2.289 + 0.9513 * Increase in profits.

Yes, is this model is useful because the given R-Square value is 0.9321.

That means the calculated regression model explain the 93% variation and its predict good model.

2)

First assumption (linearity), linear regression needs the relationship between the independent and dependent variables to be linear.

This assumption can check by residual vs increase in profits plot, and this are scattered, then this model is linear.

Second assumption (Normality), the linear regression analysis requires all variables to be normal.

This assumption can check by Normal probability plot, and this are look line linear, then the data are normal.

3)

From all above the R square is good it explain 93% variation and assumptions also meat.

Then division profit appear to be a good predictor for the manager’s pay raise.

4)

One of company’s division had a –0.51 percent change in profits last year then percentage change in salary for managers is,

Calculate from above equation,

managers salary = 2.289 + 0.9513 * Increase in profits.

= 2.289 + 0.9513 * (-0.51)

= 1.8038%.

another divisions had a 20 percent increase

then percentage change in salary for managers is,

managers salary = 2.289 + 0.9513 * Increase in profits.

= 2.289 + 0.9513 * (20)

= 21.315%.


Related Solutions

The client is the Chairman of the Board of Directors of an KENTUCKY corporation. The Board...
The client is the Chairman of the Board of Directors of an KENTUCKY corporation. The Board of Directors has decided to merge the corporation with another KENTUCKY corporation. The client wants to know if shareholder approval is required for the merger. Identify the KENTUCKY statute that governs this question, and what that statute provides concerning shareholder approval.
The client is the Chairman of the Board of Directors of an Ohio corporation. The Board...
The client is the Chairman of the Board of Directors of an Ohio corporation. The Board of Directors has decided to merge the corporation with another Ohio corporation. The client wants to know if shareholder approval is required for the merger. Identify the Ohio statute that governs this question, and what that statute provides concerning shareholder approval.
When does a corporation need a board of directors?
When does a corporation need a board of directors?
What is the role of a board of directors of a corporation and why is there...
What is the role of a board of directors of a corporation and why is there often criticism of boards of directors? What is at least one recommendation made by the critics to improve the situation?
The stockholders control a corporation by electing a board of directors.
The stockholders control a corporation by electing a board of directors.
Explain the division of power between the Board of directors and General Meeting of Shareholders.
Explain the division of power between the Board of directors and General Meeting of Shareholders.
You are the chairman of the board of directors at Epson Information Systems, Corporation. The board...
You are the chairman of the board of directors at Epson Information Systems, Corporation. The board has decided to encourage employees to take college courses by reimbursing each eligible employee a maximum of $3,500 in tuition during any one calendar year. Anyone who wants to participate in the program must apply before the first class meeting and the application must be signed by the employee’s immediate supervisor. The only courses employees may choose are those either related to the employee’s...
Discuss the role and powers of shareholders and the board of directors in a corporation.
Discuss the role and powers of shareholders and the board of directors in a corporation.
The Station A Division of Sunshine Company is losing $150,000 per month. The Board of Directors...
The Station A Division of Sunshine Company is losing $150,000 per month. The Board of Directors decides to dispose of the Station A on June 30, 2013. The carrying value of the Station A net asset on June 30, 2013 is $3,000,000, and its fair value is appraised to $2,800,000 and disposal cost is estimated to $500,000. The Station A hasn’t continued to sustain same loss until Dec 31 2014. In the meantime, the Station A Division has continued losing...
Explain the division of power between the Board of directors and General Meeting of Shareholders. Discuss...
Explain the division of power between the Board of directors and General Meeting of Shareholders. Discuss who is bound by the Constitution and replaceable rules. With respect to the different parties briefly outline the rights that may be enforced under the Constitution and replaceable rules Detail the conditions that must be satisfied for a small scale offering to be exempt from the disclosure requirements. List the benefits of voluntary administration as a process that gives business an opportunity to recover?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT