Annual performance review

A human resources (HR) manager wants to know if annual performance review scores can be predicted by the number of vacation days taken during the year and the number of dependents an employee claims. She randomly pulls the vacation, W-2, and performance review records of twenty employees. The data is presented in the attached document

Using the attached data, run a correlation matrix and then run a regression analysis in Microsoft Excel that will answer the human resources (HR) manager’s question. Examine the results and consider the implications. Write a 3- to 4-page paper based on the results and implications. Make sure to include your data printout and justify your responses. In your paper, address the following questions:

  • Identify the R-squared value for this data set, along with the R-value. Explain what each means.
  • Describe what the F-test and the p value tell us in general and name each for these data sets and analyses.
  • Explain what can be learned from the multiple regression that may not be known from the correlation matrix.
  • Justify whether performance review scores can be predicted by the number of days of vacation taken, dependents claimed, or vacation days taken in combination with the number of dependents. Support your position.
  • Describe any potential ethical or legal concerns related to this research. Provide a rationale backed by authoritative references to support your position.

Your final product should include your Microsoft Excel computations and a 3- to 4-page Microsoft Word document. Utilize a minimum of three scholarly sources.

Use the following headings and subheadings to organize your paper:

  • Defining and explaining concepts
    • Prediction
    • R-squared and R-value
    • F-test
    • p value
    • Correlation coefficient versus regression weight (beta value)
  • Results
  • Discussion and implications of results
  • References
  • Appendix (Microsoft Excel printout)


# of Vacation Days taken Number of dependents Overall performance rating (1 [lowest] to 4 [highest])
1 10 2 2.9
2 12 3 2.4
3 10 4 2
4 15 2 2.3
5 14 3 3.2
6 12 5 1.9
7 13 1 3.4
8 15 3 2.1
9 16 2 2.9
10 14 3 2.4
11 13 4 2
12 12 2 2.3
13 11 3 3.2
14 10 5 1.9
15 13 1 3.4
16 13 3 2.1
17 14 2 2.9
18 18 3 3.4
19 17 4 3
20 14 0 3.3

"Looking for a Similar Assignment? Order now and Get a Discount!

Frequently Asked Questions

A Page will cost you $12, however, this varies with your deadline. 

When you pay us, you are paying for a near perfect paper and the time convenience. 

Upon completion, we will send the paper to via email and in the format you prefer (word, pdf or ppt). 

Yes, we have an unlimited revision policy. If you need a comma removed, we will do that for you in less than 6 hours. 

As you Share your instructions with us, there’s a section that allows you to attach as any files. 

Yes, through email and messages, we will keep you updated on the progress of your paper. 

Start by filling this short order form 

And then follow the progressive flow. 

Having an issue, chat with us here


James from