Topic: Correlation Calculations
Pages: 2, Double spaced
Order type: Essay
Language: English (U.S.)
steps and displays images of steps he has taken in Excel. When you come across such
escriptions Read Salkind, Chapter 15 carefully. As you are reading the textbook, you will find that the author describes, please stop and do the steps he has described. In order to learn how to use Excel for this course, it is necessary to do the steps yourself and not just read about them.
Your goal for this lab is to accomplish the following:
• Learn how to run correlations.
• Learn how to interpret results from correlations.
• Complete and submit the lab.
Submit the following question:
1. A researcher questioned six students regarding their attitudes toward the legalization of prostitution (X) and their attitudes toward the legalization of marijuana (Y). Students answered on a “1–7” scale with “1” being “least favorable attitude” and “7” being “most favorable attitude.” The data are below:
a. What are the null and research hypotheses?
b. Create a scatter plot of the two variables.
c. Calculate the correlation coefficient. (Do not worry about significance, as Excel does not easily calculate it.)
Show your calculations and answers in an Excel file.