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 HR department is
evaluating this data to drive decision-making in regard to their hiring
process. The data for 8 executives is:
In a 3-5 page paper, 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
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
Make another logical argument for why divorce may be causing
Calculations conducted in Excel must be copied and pasted
into the Word doc. Clearly label all calculations.