Data are gathered regarding the length of tenure top executives have at a major corporation and whether those executives have been divorced. The Human Resources department is evaluating this data to...

1 answer below »
Data are gathered regarding the length of tenure top executives have at a major corporation and whether those executives have been divorced. The Human Resources department is evaluating this data to drive decision-making in regard to their hiring process. The data for eight executives is as follows:


Document Preview:

Evaluation of Correlation Data are gathered regarding the length of tenure top executives have at a major corporation and whether those executives have been divorced. The Human Resources department is evaluating this data to drive decision-making in regard to their hiring process. The data for eight executives is as follows: In a three page paper, excluding title page and reference page(s), answer the following questions to analyze the data. Include clearly labeled calculations, if applicable. Calculations conducted in Excel must be copied and pasted into the Word document. This paper should be formatted according to APA style. What’s the most appropriate procedure for evaluating the relationship between tenure and divorce? What is the correlation and how can it be interpreted in terms of magnitude, direction and practical importance? How much of whether executives have been divorced can be accounted for by their length of tenure with the organization? How much of tenure can be explained by whether there has been a divorce? Make a logical argument for why lengthy tenure may be causing divorce. Make another logical argument for why divorce may be causing lengthy tenure. Make sure to support your arguments with at least two articles from scholarly sources from JSTOR and PROQUEST. All calculations conducted in Excel must be copied and pasted into the Word document before submission. Be sure to clearly label all calculations.



Answered Same DayDec 23, 2021

Answer To: Data are gathered regarding the length of tenure top executives have at a major corporation and...

David answered on Dec 23 2021
125 Votes
Studying Relationship between Tenure of an Executive and status of Divorce
using Correlation and Regression Techniques
Aim
To anal
yze the given data on tenure of major executives at major corporations and whether
those executives have been divorced to help Human Resource Department in making
hiring decisions.
Analysis
Eta Squared
The most appropriate measure to evaluate the relationship between tenure and divorce is
Eta Squared. Since in this case, tenure is of interval scale and divorce is a nominal
variable, Pearson’s correlation coefficient cannot be used. Eta square tells us the
percentage of variance of tenure explained by the Divorce. It can vary between 0 to1.
Since the variable Divorce is a nominal variable, correlation coefficient cannot be
calculated, thus we use Eta Squared.
To calculate Eta Squared, we conduct a One Way ANOVA with Tenure as the dependent
variable. Table 1 gives the result of ANOVA
Df SS MS F
Significance
F
Between
Groups 1 2.53 2.53 7.71 0.03
Within
Group 6 1.97 0.33
Total 7 4.5
Table 1: ANOVA with Tenure as Dependent Variable.
56.0
5.4
53.22 
Total
Between
SS
SS

Thus 0.56 or 56% of the variance of tenure is explained by the Divorce. This can be used
as a correlation between two variables. The direction of the relationship...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here