Identify the r-squared value for this data set

Assignment Help Other Subject
Reference no: EM132047372 , Length: 3

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 documen.

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

Attachment:- Data Set.rar

Reference no: EM132047372

Questions Cloud

What is predicted maintenance cost : The Park Co. has estimated a function that uses machine hours to predict factory maintenance costs. What is predicted maintenance cost
American put option on stock-what is put value : There is an American put option on a stock that expires in two months. What is the price of the option? What is Put value?
The price of the put option today using one-month steps : What is the price of the put option today using one-month steps? Use a two-state model with one-month steps.
Distinct unit produces corvettes : General Motors Corporation structures its company based upon the Model (type) of vehicle that is produced. For example, one unit produces pickup trucks
Identify the r-squared value for this data set : Describe what the F-test and the p value tell us in general and name each for these data sets and analyses.
Use the two-state model to value real option : If the risk-free rate is 5.5 percent per year, what is the value of this option? Use the two-state model to value the real option.
Compute the total tax rate : Assume that the United States corporate tax rate is 35%, Compute the total tax rate (United States plus foreign) on Sproutco's profits
Decline in business because of competition : A company is experiencing decline in business because of competition. The manager thinks they may be able to turn the company
What did you feel or what emotions did you experience : What did you feel or what emotions did you experience? Did you express your anger, either privately or to an individual?

Reviews

Write a Review

Other Subject Questions & Answers

  Social inequality-agrarian societies

In terms of social inequality, agrarian societies generally:

  Why professionalism of procurement officers is essential

Why professionalism of procurement officers is essential.

  Determining presidential powers

Presidential power and influence are often thought to be greater in the foreign policy arena than in the domestic policy arena. Why? Besides the power to pass legislation, what other powers does congress have to influence the policy-making process..

  Creatinine clearance using the cockcroft/gault method

What is her estimated creatinine clearance using the Cockcroft/Gault method? GFR using the MDRD method

  Differences between american and european values

Similarities and Differences between American and European Values- Different cultures have different values and reconciling these values is one of the most frustrating elements of foreign policy

  Problems basede on reliable internet resources

Examine the impact you have on creating renewed resources from these recycled items.

  What is accomplice liability and criminal liability

What is accomplice liability and criminal liability? How does it relate to the case? What interested you about this case? Do not use the first person

  Explain the relational turbulence model

Explain the Relational Turbulence Model. Be sure to discuss the role "unwelcome surprises" and "unrealistic expectations" play in this model

  How cognitive and effective aspects inform comprehension

Explain how cognitive and effective aspects inform comprehension. Support your position with the Learning Resources and your research.

  Describe the participant sampling and treatment protocols

Describe the participant sampling, treatment protocols, assessment strategies and potential difficulties in researching the benefits of social support and existing mental health resources.

  Instructionsnbsp this quiz is to be completed without the

instructionsnbsp this quiz is to be completed without the assistance of others. this is not a group project. type your

  Calaculate average calibration

Students shall weigh 10 PVC filters and record the post weight of each filter. The student shall then use the following data to identify the TWA for Employee A and Employee B. Calaculate Average calibration.

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