Question

In: Statistics and Probability

To determine whether the cash bonuses paid by Johnson Financial Group are related to annual pay,...

To determine whether the cash bonuses paid by Johnson Financial Group are related to annual pay, data were gathered for 10 account executives who received such bonuses in 2007.

The data, scatterplot and summary statistics are shown below.

ANNUAL PAY CASH BONUS
$70,723 $11,262
$58,612 $6,313
$104,706 $14,252
$44,025 $4,235
$82,786 $11,884
$116,342 $23,731
$76,861 $7,826
$68,639 $20,818
$137,069 $55,012
$94,524 $34,426

1) Comment on whether each of the following conditions for correlation / linear regression is met
- Quantitative Variables Condition
- Linearity Condition
- Outlier Condition

2) Estimate the linear regression model that relates the response variable (Cash Bonus) to the predictor variable (Annual Pay)
Find the slope of the regression line.  

Find the intercept of the regression line.  

Write the equation of the linear model.

3) Find the value of R2. Interpret its meaning in this context

4) Using the regression equation, estimate the cash bonus for an executive at Johnson Financial earning $82,786 a year.
What is the residual for this estimate? What does it mean?

Solutions

Expert Solution

1. Checking for conditions with scatter plot

Conditions met: Quantitative Variables Condition and Linearity Condition

2. Using Excel, go to Data, select Data Analysis, choose Regression. Put Annual Pay in X input range and Cash Bonus in Y input range.

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.812
R Square 0.659
Adjusted R Square 0.616
Standard Error 9677.023
Observations 10
ANOVA
df SS MS F Significance F
Regression 1 1448230160.971 1448230160.971 15.465 0.004
Residual 8 749158209.929 93644776.241
Total 9 2197388370.900
Coefficients Standard Error t Stat P-value
Intercept -19637.790 10284.742 -1.909 0.093
Annual pay 0.452 0.115 3.933 0.004

Slope = 0.452

Intercept = -19637.79

y = -19637.79 + 0.452x

Cash bonus = -19637.79 + 0.452*Annual pay

3. R-square = 0.659

Thihs means that 65.9% variation in cash bonus is explained by annual pay.

4. Annual pay = $82,786

Estimated Cash bonus = -19637.79 + 0.452*82786 = $17,781.482

Actual cash bonus = $11,884

Residual = 11884-17781.482 = -5897.482

This means estimated value is $5897 more than actual value of cash bonus.


Related Solutions

To determine whether the cash bonuses paid by Johnson Financial Group are related to annual pay,...
To determine whether the cash bonuses paid by Johnson Financial Group are related to annual pay, data were gathered for 10 account executives who received such bonuses in 2007. The data, scatterplot and summary statistics are shown below. ANNUAL PAY CASH BONUS $70,769 $11,935 $58,707 $15,946 $104,779 $15,956 $44,064 $17,147 $82,834 $12,519 $116,440 $23,799 $76,888 $13,312 $68,654 $21,360 $137,092 $48,880 $94,536 $34,983 1) Comment on whether each of the following conditions for correlation / linear regression is met. (2 points)...
organizations link pay to performance, determine cash bonuses, recognize employees and determine equity-based rewards. An organization...
organizations link pay to performance, determine cash bonuses, recognize employees and determine equity-based rewards. An organization must determine what they are able to provide to employees according to their strategic plan, mission and values. Research to find a company that has thought through these different types of performance incentives, how they came to their conclusions, and if they are working. How do their incentives tie to their mission, values, strategic goals?
corporate annual report assignment evaluate a annual report for johnson & johnson financial and operational standing...
corporate annual report assignment evaluate a annual report for johnson & johnson financial and operational standing for the most recent fiscal year
Determine the amount of cash paid for merchandise.
The cost of merchandise sold reported on the income statement was $770,000. The accounts payable balance decreased $44,000, and the inventory balance decreased by $66,000 over the year. Determine the amount of cash paid for merchandise.
determine the deductibility of employee and employment related expenses. What are the criteria that determine whether...
determine the deductibility of employee and employment related expenses. What are the criteria that determine whether you are an employee or an independent contractor? Why is this important from a tax perspective? How does this affect what can be deducted or not? Does this limit the deductibility of certain business related expenses? Provide examples.
A university official wishes to determine whether the degree of the instructor is related to the...
A university official wishes to determine whether the degree of the instructor is related to the students’ opinion of the quality of instruction received. A sample of students’ evaluations of various instructors is selected, and the data in the table below are obtained. At a = 0.10, can the officials conclude that the degree of the instructor is related to the opinions of the students about the instructor’s effectiveness in the class? Degree of instructor Opinion Rating B.S. M.S. Ph.D....
A university official wishes to determine whether the degree of the instructor is related to the...
A university official wishes to determine whether the degree of the instructor is related to the students’ opinion of the quality of instruction received. A sample of students’ evaluations of various instructors is selected, and the data in the table below are obtained. At a = 0.10, can the officials conclude that the degree of the instructor is related to the opinions of the students about the instructor’s effectiveness in the class? Degree of instructor Opinion Rating B.S. M.S. Ph.D....
Johnson company’s financial year ended on December 31, 2010. All the transactions related to the company’s...
Johnson company’s financial year ended on December 31, 2010. All the transactions related to the company’s uncollectible accounts are can be found below: January 15 Wrote of $440 account of Miller Company as uncollectible April 2nd Re-establish the account of Louisa Teller and record the collection of $1,050 as payment in full for her account which had been written off earlier July 31 Received 40% of the $700 balance owed by William John and wrote off the remainder as uncollectible...
CEPS Group is going to pay an annual dividend of OMR 4.01 a share on its...
CEPS Group is going to pay an annual dividend of OMR 4.01 a share on its common stock next year. This year, the company paid a dividend of OMR 3.75 a share. The company adheres to a constant rate of growth dividend policy. What will one share of this common stock be worth five years from now if the applicable discount rate is 9.25 percent?
A group of engineers perform an experiment to determine whether the fuel efficiency for a new...
A group of engineers perform an experiment to determine whether the fuel efficiency for a new type of engine for an oilfield drill is better than the most commonly used type of engine in existing oilfields. The engineers perform a 2–sample t–test and obtain a p-value of 0.04. (i) Briefly explain what a p–value of 0.04 means (i.e. what does the p–value actually represent). (ii) Explain what a Type II error would mean in the context of this problem.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT