Assignment 10: Correlational Analysis

1. Watch the Demonstration Video: Correlational Analysis.

2. See the rubric at the end of this webpage.

3. Complete the correlation table provided in this excel file. Compute and place the Pearson correlation coefficients in the cells highlighted in yellow. You just have to use the “=PEARSON ()” excel function and choose the correct variables. 

4. Generate two scatterplots to display the correlation of at least two pairs of variables in the dataset. You are free to choose any pair of variables from which to create the scatterplots. In the two scatterplots, you need to demonstrate your ability to adjust titles and axis and add trend lines as demonstrated in the video to make graphs easy to be understood by the audience.

5. Write a data commentary to explain and interpret your correlation findings. Make sure you review the correlation section. In your commentary, report the Pearson correlation coefficients and discuss the findings in terms of the strength and directions of the correlations. You can also develop some hypotheses or propositions to infer some insight about the variables' relationships. 

5. Submit your excel file including your visual analysis and your word document with data commentary.