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

  Ramirez corporation sells two types of computer chips the

1.woolfords cvp income statement included sales of 3000 units a selling price of 50 variable expenses of 30 per unit

  Mississippi company has two decentralized divisions

mississippi company has two decentralized divisions illinois and iowa. illinois always has purchased certain units from

  Compute the payback period for the proposed

Bach's Clothing Store is considering a new product line: umbrellas and rain gear. The new product line would require an investment of $20,000 in equipment and fixtures and $40,000 in working capital. Store managers expect the following pattern of ..

  Beverage products llc manufactures metal beverage

beverage products llc manufactures metal beverage containers. the division that manufactures soft-drink beverage cans

  Estimate the cost of the receivables loan

Estimate the cost of the receivables loan to Johnson when the firm borrows the $300,000. The prime rate is currently 11 percent.

  Picture pretty manufactures picture frames sales for august

picture pretty manufactures picture frames. sales for august are expected to be 10000 units of various sizes.

  Find correct balance for ending inventory on december

The ending inventory balance of $412,000 included $43,000 ofconsigned inventory for which Gotham was the consignee. Based on this information, the correct balance for ending inventory on December 31 is:

  Measure of the value of the machine

Consider the decision usefulness of accounting information produced when using each of the above figures as a measure of the value of the machine. In particular, consider usefulness from the perspective of the following stakeholders:

  How many sets of clubs must be sold for tee times

Tee Times, Inc. produces and sells the finest quality golf clubs in all of Clay County. The company expects the following revenues and costs in 2009 for its Elite Quality golf club sets.

  Current federal income tax liability

What amount should Munoz report as its current federal income tax liability on its December 31, 2011 balance sheet?

  Alfred was divorced from sarah old in march 2010 under the

alfred e. old and beulah a. crane each age 42 married on september 7 2011. alfred and beulah will file a joint return

  Determine the interest rate of the loan

Write an excel fomula to determine the interest rate of the loan.

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