Reference no: EM13922687

Evaluation of Correlations.

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 to five 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 guidelines outlined in the Ashford Writing Center.

a. What's the most appropriate procedure for evaluating the relationship between tenure and divorce?
b. What is the correlation and how can it be interpreted in terms of magnitude, direction and practical importance?
c. 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?
d. Make a logical argument for why lengthy tenure may be causing divorce.
e. Make another logical argument for why divorce may be causing lengthy tenure.