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: Tenure Divorce 1 9.0 No 2 9.5 No 3 11.0 Yes 4 11.5 Yes 5 10.0 Yes 6 9.8 No 7 10.0 No 8 10.3 Yes 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. 1. What s the most appropriate procedure for evaluating the relationship between tenure and divorce? 2. What is the correlation and how can it be interpreted in terms of magnitude, direction and practical importance? 3. 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? 4. Make a logical argument for why lengthy tenure may be causing divorce. 5. Make another logical argument for why divorce may be causing lengthy tenure. Make sure to support your arguments with at least two articles from the Ashford Library or other scholarly sources. All calculations conducted in Excel must be copied and pasted into the Word document before submission. Be sure to clearly label all calculations.
8459633/8459633 (Analysis).xlsx? 1 9 0 2 9.5 0 3 11 1 4 11.5 1 5 10 1 6 9.75 0 7 10 0 8 10.25 1 0 9 1 0 9.5 0.75 1 1 11 1 11.5 1 10 0 9.75 0.5625 0 10 1 10.25 Tenure Divorce 8459633/8459633 (Solution).docx? 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 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. What’s the most appropriate procedure for evaluating the relationship between tenure and divorce? The characteristics of these two variables require a procedure called a point-biserial correlation. The “point” in the title refers to the continuous variable, the length of tenure top executives have at a major corporation. The “biserial” refers to the other variable in the relationship, which can have only two options. In the example they are those executives have been divorced. The point-biserial correlation is a procedure for relating an interval/ratio variable with a nominal variable that has two categories. The dichotomous variable that is “Divorce” is dummy-coded where 1 represent that the executives have been divorced and 0 represent that the executives have not been divorced. What is the correlation and how can it be interpreted in terms of magnitude, direction and practical importance? To complete the point-biserial correlation in Excel, the data can be arranged in columns or rows. For this example, we will use Column A for the…
Attachments:
8459633.zip