New assignment
Hello Learning Team, For your Week 5 – Practice Worksheet, you will create a Scatter Diagram. The following is an example practice problem: Create a Scatter Diagram using Excel - For example, in my line of work, we give the employees a Excel test before the seminar and another test after a seminar, hypothetically, the following scores: Column A - Test Scores before the seminar - insert the following numbers from row 1 to row 7 4 6 4 1 1 3 5 Column B - Test scores after the seminar scores - insert the following numbers from row 1 to row 7 5 6 4 2 3 4 5 Next, select both columns, and then select the Insert tab. Now in the Recommended Charts section - select the scatter chart - then select the first chart in that section of the scatter chart section. Now your scatter diagram will appear. Now add a trendline to show the strength of the correlation. Click one of the dots inside the scatter diagram, then select trendline. The trendline will appear inside of the scatter diagram. If the dots fall close to the line, it is a strong correlation. If the dots fall far away from the line, it is a weak correlation. Attached your Excel document to this response. With Warm Regards,? 3/15/21, 10:14 PM NEW Top of Form Hello Learning Team For your Week 5 – Practice Worksheet, you will figure the Correlation Coefficient. The following is an example practice problem. Using Excel to figure the Correlation Coefficient Person 1 - the score for X is 3; the score for Y is 4 2 - the score for X is 6; the score for Y is 7 3 - the score for X is 1; the score for Y is 2 4 - the score for X is 4; the score for Y is 6 Open Excel to a Blank page. 1st Step: Column A row 1 - the label for Column A is X (scores) 2nd Step: Column A rows 2 through 5 add the following scores: 3 6 1 4 3rd Step: Column B row 1 - the label for Column B is Y (scores) 4th Step: Column B rows 2 through 5 add the following scores: 4 7 2 6 5th Step: Select the Data tab 6th Step: Select Data analysis (far right corner of the ribbon) 7th Step: Select Correlation 8th Step: Select Input Range, Now Select - Column A - Row 1 to Column B to Row 5. 9th Step: Check Labels (because we have labels X and Y) 10th Step: Select Output Range, Now Select Column A - Row 7. 11th Step: Click OK. Your answer is 0.974913 With Warm Regards, ? 3/15/21, 10:11 PM NEW Top of Form Hello Learning Team, For your Week 5 – Practice Worksheet, you will provide three logically possible directions of causality for two variables: The following are example practice problems. In summary, "If two variables have a significant linear correlation, there are three possible directions of causality for these two variables: 1. X could be causing Y. 2. Y could be causing X. 3. Some third factor could be causing Both X and Y. For example, 1. X could be causing Y. Marital satisfaction could be causing exciting activities for the married couple. 2. Y could be causing X. Exciting activities could be causing marital satisfaction for the married couple. 3. Some third factor could be causing Both X and Y. Low stress at work could be causing both marital satisfaction and exciting activities for the married couple “ (Aron, Coups & Aron, 2013, p.463). For example, in my line of work, 1. X could be causing Y. Absenteeism could be causing job dissatisfaction. 2. Y could be causing X. Job dissatisfaction could be causing absenteeism. 3. Some third factor could be causing Both X and Y. New work hours could be causing both job dissatisfaction and absenteeism. With Warm Regards,? Reference Aron, A., Coups, E. & Aron E.N. (2013). Statistics for psychology (6th ed.). Retrieved from The University of Phoenix eBook Collection database. Bottom of Form