Linear regression analysis

Assignment Help Accounting Basics
Reference no: EM13845783

The personnel director for a local manufacturing firm has received complaints from the employees in a certain shop regarding what they perceive to be inequities in the annual salary for employees who have similar performance ratings, years of service and relevant certifications.  The personnel director believes that an employee's pay in this particular shop should be positively correlated to their prior performance rating and years of service.  The personnel director has collected the data shown in the following table pertaining to the employees within the shop. 

Employee

Current Annual Salary (Thousands)

Average Performance Rating for Past 3 Years (5 point scale)

Years of Service

1

48.2

2.18

9

2

55.3

3.31

20

3

53.7

3.18

18

4

61.8

3.62

33

5

56.4

2.62

31

6

52.5

3.75

13

7

54.0

4.25

25

8

55.7

3.43

30

9

45.1

1.93

5

10

67.9

4.50

47

11

53.2

2.81

25

12

46.8

3.06

11

13

58.3

5.00

23

14

59.1

4.06

35

15

57.8

4.12

39

16

48.6

2.31

21

17

49.2

3.87

7

18

63.0

4.37

40

19

53.0

2.50

35

20

50.9

2.81

23

21

55.4

3.68

33

22

51.8

3.50

27

23

60.2

3.00

34

24

50.1

2.43

15

  1. Perform a simple linear regression analysis to predict an employee's annual salary based upon his or her average performance rating for the past 3 years using a 95% level of confidence.
    1. Does the regression model confirm a positive correlation between the dependent variable and the independent variable as hypothesized?
    2. Is the statistical significance of the model as a whole acceptable for a 95% level of confidence?
    3. Is the statistical significance of the linear relationship between the dependent and independent variable acceptable for a 95% level of confidence?
    4. What is the regression equation for the model?
    5. What is the predicted annual salary for employee number 13 based upon his or her average performance rating for the past 3 years, and what does the predicted salary value suggest regarding his or her current annual salary?
  2. Perform a simple linear regression analysis to predict an employee's annual salary based upon his or her years of service using a 95% level of confidence.
    1. Does the regression model confirm a positive correlation between the dependent variable and the independent variable as hypothesized?
    2. Is the statistical significance of the model as a whole acceptable for a 95% level of confidence?
    3. Is the statistical significance of the linear relationship between the dependent and independent variable acceptable for a 95% level of confidence?
    4. What is the regression equation for the model?
    5. What is the predicted annual salary for employee number 13 based upon his or her years of service, and what does the predicted salary value suggest regarding his or her current annual salary?
  3. Perform a multiple linear regression analysis to predict an employee's annual salary based upon his or her average performance rating for the past 3 years and his or her years of service using a 95% level of confidence.
    1. Is the statistical significance of the model as a whole acceptable for a 95% level of confidence?
    2. Is the statistical significance of the linear relationship between the dependent variable and each of the independent variables acceptable for a 95% level of confidence?
    3. What is the regression equation for the model?
    4. What is the predicted annual salary for employee number 13 based upon his or her average performance rating for the past 3 years and years of service, and what does the predicted salary value suggest regarding his or her current annual salary?
  4. Which of the two simple linear regression models is the preferred model, and why?
  5. Is the multiple regression model preferable to the preferred simple regression model, and why?

Hint: For the purposes of this homework assignment, the minimum difference between the R2 or Adjusted R2 values for two acceptable regression models that would favor selecting a model with a larger number of independent variables is 0.05.

Reference no: EM13845783

Questions Cloud

Amount of tamara long term capital gain : During the current year, Tamara sells the asset to Leon in exchange for $93,000 cash and a new automobile with a fair market value of $51,000 to be used by Tamara for personal use. Leon assumes the $74,000 liability. What is the amount of Tamara's..
Bulleted list of significant vocabulary words : Provide a bulleted list of significant vocabulary words (with definitions) encountered in the article. Must include the definition of each word in context. 5-6 words...
What is the source of the mercedes message : What is the source of the Mercedes message. Is it the right message source for a relatively inexpensive entry-level luxury automobile that the company hopes will attract younger consumers
Explain the foundation of your communication : What topic sentences will you use as the foundation of your communication? (If necessary, add more points.) What method of organization and development will you use to develop your paragraphs?
Linear regression analysis : Perform a simple linear regression analysis to predict an employee's annual salary based upon his or her average performance rating for the past 3 years using a 95% level of confidence.
Analyze coca-cola corporation and its economic performance : Your assignment is to analyze the Coca-Cola Corporation and its economic performance over the last five (5) years. You should begin with the last available reference year
Drosophila melanogaster and the common fruit fly : Since the turn of the 20th century, Drosophila melanogaster, the common fruit fly, has been a useful organism for the study of genetics. Its relatively short generation time (approximately 10 days at 25oC) yields a large amount of breeding data i..
Compute taxable income : The following information is available for Wenger Corporation for 2013.
The current issue of indian country today : What article or news program in the current issue of Indian Country Today , Indianz.com or Native America Calling or any other source did you find of most interest to you. Why

Reviews

Write a Review

Accounting Basics Questions & Answers

  Prepare adjusting entry and find balance in prepaid rent

Prepare the adjusting entry for December 31 st  to reflect the amount of rent expense consumed. What is balance in prepaid rent on December 31 st  after the adjusting entry has been made?

  Evaluate how the status of the pension fund affects

Recent events in the world of corporate finance have shown the importance of proper administration and funding of corporate pension plans. Evaluate the information in the Comparative Analysis Case of Coca-Cola and PepsiCo found in the book's compa..

  Abc company has the option to purchase additional equipment

potential investments to accelerate profit abc company has the option to purchase additional equipment that will cost

  Third national bank assesses a finance charge

On April 1, 2014, Rasheed Company assigns $400,000 of its accounts receivable to the Third National Bank as collateral for a $200,000 loan due July 1, 2014. The assignment agreement calls for Rasheed Company to continue to collect the receivab..

  Calculating wacc for a real firm

The Weighted Average Cost of Capital (WACC) for a firm can be calculated or found through research. Select two firms in the same industry.

  In the current year mikes agi is 50000 mike has no

in the current year mikes agi is 50000. mike has no miscellaneous itemized deductions other than the employment-related

  What is the actual dollar equivalent of 10000 constant

what is the actual dollar equivalent of 10000 constant dollars 20 years from now? inflation is 5 per year and the

  Calculate ending inventory cost of goods sold gross profit

you have the following information for mchugh inc. for the month ended october 31 2010. mchugh uses a periodic method

  Product of the accounting cycle

Financial statements are a product of the accounting cycle. Think about two different companies: a manufacturing company, and a retail company. Why would different companies have different accounting cycles?

  When using the time adjusted rate of return method to rank

when using the time adjusted rate of return method to rank investment decisions the general rule isa. the lower the

  Stine company purchased machinery with a list price of

stine company purchased machinery with a list price of 64000. they were given a 10 discount by the manufacturer. they

  Comprehensive income with example

Determine how the authoritative literature addresses comprehensive income and illustrate with an example.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd