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

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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