Instructions:In this assignment, you will create a scattergram and conduct the Pearson's r correlation analysis using the data from the Excel file created for Week 7's homework.You will then conduct the hypothesis test steps as listed in Abbott (2017) Chapter 11. Finally, students will calculate the effect size on the correlational analysis.

For your convenience, the two variables being compared for the correlation are listed below:

WELFARE - "Welfare social programs - Do you think we're spending too much, too little, or about the right amount?"

1 = Too little.

2 = About right.

3 = Too much.

WLTH.EQL - "Some people think that the government in Washington ought to reduce the income differences between the rich and the poor, perhaps by raising the taxes of wealthy families or by giving income assistance to the poor. Others think that the government should not concern itself with reducing this income difference between the rich and the poor. Imagine a scale from 1 to 7, where "1" means the government ought to reduce the income differences between rich and poor, and "7" means the government should not concern itself with reducing income differences. What score comes closest to the way you feel?"

Create a scattergram following instructions in Abbott (2017) Chapter 11.Once you have created it, rename the graph using the variable names.Next, you will need to label both the vertical y-axis, as well as the horizontal x-axis.You will need to "instruct" Excel to add the generic "Axis Titles" to the graph.This option is visible by clicking on the scattergram to select the graph.Click on the + symbol and select the box for "Axis Titles."Click inside the generic "Axis Title" to rename variable that is displayed on that axis.Tip - Excel automatically creates the scale, or possible values/answers that respondents gave for each variable.By comparing the scale for each axis against the possible answers, you will be able to discern which variable is on which axis so that you can appropriately label each axis with the correct variable name. Once you have created and labelled the scattergram in Excel, copy and paste it below:

Perform a correlational analysis for the variables Welfare and Wealth Equality as illustrated in Abbott (2017) Chapter 11.Please expand the output column so that each label that identifies the variable is fully visible. Copy and paste the results below:

Using Abbott (2017) Table C.5, what is the critical (exclusion) value for a two-tailed, p = 0.05 test? Note that there are 102 scores in the Week 7 Excel HW file.You will need to calculate the appropriate degrees of freedom to identify the correct critical exclusion value.

Answer:

Comparing the critical exclusion value against your calculated r correlation coefficient value, is there a correlation between the variables Welfare and Wealth Equality?

Answer:

Based on the intersecting paired scores between the variables as shown on the scattergram, do you believe there is a positive correlation, negative correlation, or a curvilinear/non-linear correlation?

Answer:

What is the effect size for the r correlation coefficient you calculated?Tip - remember that you have produced the r-value as listed in the Excel output; however, effect size is based on r².See p. 347 - 349.

What is the value of r²:

What is the effect size for correlation between Welfare and Wealth Equality?

Answer:

https://docs.google.com/document/d/1Z5zMkJX5jo-tXBzwgIe6VbQwZ7qXaoRuviMu0x6WZtM/edit?usp=sharing

https://drive.google.com/file/d/1yQRJr5TWhr_rLlGbJXrfOw8Su6N7j1S1/view?usp=sharing