2:17 PSY230-M6-Assignment-Spring2023.... Q2. Pearson's Correlation (15 points) (Round calculated results to the hundredth (2"d place to the right of the decimal) when result extends beyond that unless otherwise noted). It is generally believed that there is a relationship between a college's acceptance rate and its graduation rate. I wanted to know how strong this relationship is within the top universities in the country, so I collected the graduation rate and acceptance rate data of a randomly selected sample of universities from all the top U.S. universities (with an acceptance rate at or below 30%). The data set is in Tab Q2 of the Excel data file. Q2a. Create a scatter plot between the two variables using Excel. Paste the plot here and format it into an APA-styled "figure" (see Assignment Guides for APA format). Be sure to submit the Excel file that you used to create the scatter plot. [2 points] - 0.5 for correct scatter graph type - 0.5 for the two axis labels (deduct 0.5 even if only one label is missing) - 0.5 for APA (figure number and caption at bottom, figure number is italic) - 0.5 for correct data from the two variables on the X and Y axes Paste Table Here: Q2b. Calculate the mean and standard deviation for the two variables separately. [4 points total: 1 point for each mean and 1 point for each SD, deduct 0.5 if an answer is incorrect but the calculation process was correct] Q2c. Calculate the Z scores for all the scores of the two variables, separately. Tips: It may help to prevent error and to increase clarity if the process and/or the answers (z scores) are listed in a table format. [2 points total: 1 for Z scores for each variable] Q2d. Calculate Pearson's correlation coefficient r. [2 points total: 1 if the process is correct but the answer is wrong] Q2e. Explain the direction and strength of the relationship based on the r. [1 point total: 0.5 for strength, 0.5 for direction] Q2f. What is the proportion of variance shared between the two variables? (That is, how much of the variance in one variable can be predicted by the variance in the other variable?) (Do not round during the calculation, the final result as the percentage should be to the hundredth [2"d decimal]) [1 point total: -0.5 if the process is correct but the answer is wrong] OF n Dashboard Calendar To Do Notifications Inbox2:17 A PSY230-M6-Data-SpringA2023-1.xlsx Q1 Q2 College ID Accept rate (%) Grad rate (%) 5 96 5 97 W N 6 95 8 98 10 96 10 94 15 85 15 93 15 84 16 92 11 18 89 12 18 96 13 20 90 14 20 86 15 24 85 16 25 76 17 25 86 18 28 80 19 28 78 20 29 84 1 n Dashboard Calendar To Do Notifications Inbox2:17 PSY230-M6-Data-SpringA2023-1.xisx Q1 Q2 Subject ID education memory 14 112 N 13 117 12 98 14 114 110 89 94 106 86 14 107 18 113 12 84 12 102 14 16 90 15 18 119 16 14 86 17 10 97 18 12 106 19 15 114 20 13 110 1 n Dashboard Calendar To Do Notifications Inbox2:17 K PSY230-M6-Assignment-Spring2023.... separately. Tips: It may help to prevent error and to increase clarity if the process and/or the answers (z scores) are listed in a table format. [2 points total: 1 for Z scores for each variable] Q2d. Calculate Pearson's correlation coefficient r. [2 points total: 1 if the process is correct but the answer is wrong] Q2e. Explain the direction and strength of the relationship based on the r. [1 point total: 0.5 for strength, 0.5 for direction] Q2f. What is the proportion of variance shared between the two variables? (That is, how much of the variance in one variable can be predicted by the variance in the other variable?) (Do not round during the calculation, the final result as the percentage should be to the hundredth [2"d decimal]) [1 point total: -0.5 if the process is correct but the answer is wrong] Q2g. If the researcher wants to perform a two-tailed hypothesis test using this data set so that she can generalize the relationship between the two variables from the sample to the population, what would be the null and alternative hypothesis? Write the hypotheses in words and in symbol notation. [2 points total: 1 for each hypothesis, 0.5 for written, 0.5 for symbol notation] Symbolic Written Symbol bank for copy & pasting: 2=3 mr He: Null H,: Alternative Q2h. Using SPSS to analyze the same dataset yields a p value of 031. Based on a = .05, what would be the conclusion of the hypothesis test (use wording of "reject the null hypothesis" or "fail to reject the null hypothesis"? How do you know? [1 point total: 0.5 for conclusion, 0.5 for rationale] All course content and materials, including this assignment and all other items published within the Canvas course shell, are copyrighted materials and students may not share outside the class, upload to online websites not approved by the instructor, sell, or distribute course content or notes taken during the conduct of the course (see ACD 304 06, "Commercial Note Taking Services" and ABOR Policy 5-308 F.14 for more information). O= 1 O= Dashboard Calendar To Do Notifications Inbox