1. Review the powerpoint material for how to calculate 2. Do the calculations/analysis for...

Question

1. Review the powerpoint material for how to calculate									2. Do the calculations/analysis for the 4 questions in the excel document (show your work)									3. Answer the 4 questions based on the analysis in a separate document											Please show work so that I can compare your answers to my answers																										PowerPoint Presentation Chapter 1  Excel Extension: Now You Try! Computing Correlations Bauer, Fundamentals of Human Resource Management, 1e. © SAGE Publishing, 2021 1 1 Background In this Excel Extension tutorial, you will learn how to compute a (Pearson product-moment) correlation between two continuous variables using Microsoft Excel.  For the purposes of this exercise, imagine that the engagement and job satisfaction data for each employee were collected using an annual employee survey, and each employee’s unique ID was used to merge their survey data with their average annual customer satisfaction ratings, their supervisor-rated performance evaluation score, and the amount of annual sales revenue they generated. For the purposes of this introductory exercise, we will ignore statistical significance, and instead practice interpreting the sign (positive or negative) and magnitude (size) of each correlation.  Bauer, Fundamentals of Human Resource Management, 1e. © SAGE Publishing, 2021 2 Open the Excel workbook titled “Chapter 1--Excel Extension.xlsx”. Note that the sheet includes six columns, where each column represents unique field/variable: Unique employee ID (Employee ID) Engagement (1 = low, 5 = high) Job Satisfaction (1 = low, 5 = high) Customer Satisfaction (1 = low, 7 = high) Performance Evaluation Rating (1 = low, 10 = high) Sales Revenue (U.S. dollars) Note that each row below the column names represents a unique employee, where the total number of employees is 59. Step 1 Bauer, Fundamentals of Human Resource Management, 1e. © SAGE Publishing, 2021 3 To practice, let’s compute the correlation between Job Satisfaction and Performance Evaluation Rating. Scroll down below the data to find empty cells. Step 2 Bauer, Fundamentals of Human Resource Management, 1e. © SAGE Publishing, 2021 4 In a blank cell, enter the equal symbol (=) followed by the CORREL function, followed by a beginning parenthesis. Enter the range of cell values that corresponds to the array of numeric values that fall below the Job Satisfaction variable name, which in this case is C2:C60. Note that you can enter the cell range manually by entering the first cell in the array (C2), followed by a colon (:), and followed by the last cell in the array (C60); alternatively, you can select the array of cells by clicking and dragging your mouse. Enter a comma (,). Enter the range of cell values that corresponds to the array of numeric values that fall below the Performance Evaluation Rating variable name, which in this case is E2:E60. Enter an ending parenthesis, and click ENTER. Step 3 Bauer, Fundamentals of Human Resource Management, 1e. © SAGE Publishing, 2021 5 Remember, correlation coefficients can range from –1.00 to 1.00, where –1.00 indicates a perfect negative (inverse) linear association, 1.00 indicates a perfect positive linear association, and .00 indicates no association. Note that the correlation coefficient is approximately .015 (after rounding). Regarding the sign, the correlation coefficient is positive, which indicates a positive, linear association. With that said, the magnitude of the correlation coefficient is virtually zero. For our purposes, we describe the magnitude of a correlation coefficient as follows:   Assignments > HR Analytics Assignment) and answer the following four questions (a through d). Be sure to interpret the sign and magnitude of the correlations.  *If you are not sure on how to calculate correlations, look at How to Calculate Correlations Using Excel (posted on Canvas) for an example.  *If you did not attend Session 3, please read the section on Correlation Does Not Equal Causation on page 28 in your textbook.  a. What is the correlation between Employee Engagement and Sales Revenue? (5 points) b. Consider the sign and the magnitude of the correlation. How would you describe the nature of the relation between Engagement and Sales Revenue to a manager who does not know what a correlation coefficient means? (5 points) c. What is the correlation between Job Satisfaction and Customer Satisfaction? (5 points) d. Consider the sign and the magnitude of the correlation. How would you describe the nature of the relation between Job Satisfaction and Customer Satisfaction? (5 points) 2. Submit your answers to the four questions in one WORD document and upload it on Canvas.

Komalavalli · Accepted Answer

a.
The correlation between Employee Engagement and Sales Revenue is 0.05
b.
Firstly, let's discuss the sign of the correlation coefficient. A positive correlation would suggest that as one variable (in this case, Engagement) increases, the other variable (Sales Revenue) tends to increase as well. Conversely, a negative correlation would mean that as one variable increases, the other tends to decrease. However, in this case, with a correlation coefficient of 0.05, it means that there is a very slight tendency for Engagement and Sales Revenue to move together in some way, but it's not a strong or noticeable pattern.
Imagine a scatter plot, which is a graphical representation of the data points for Engagement and Sales Revenue. In this case, the data points would be spread out in a way that doesn't show a clear trend or pattern. They don't form a tight cluster,

Sun	Mon	Tue	Wed	Thu	Fri	Sat
30	31	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	1	2	3

1. Review the powerpoint material for how to calculate2. Do the calculations/analysis for the 4 questions in the excel document (show your work)3. Answer the 4 questions based on the analysis...

Answer To: 1. Review the powerpoint material for how to calculate2. Do the calculations/analysis for the 4...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment