Computing a Pearson r from Two Sets of Student Scores

After you have built your own Excel spreadsheet based on watching the video tutorial "Computing a Pearson Product Moment Correlation Coefficient: Excel Video Tutorial (22:24)," edit your spreadsheet to enter the following scores for the General Survey for all of the students:

Student	Scores
A	44
B	32
C	33
D	39
E	34
F	20
G	25
H	27
I	6
J	19

Note: These new scores are the same ones used in Evaluation 3. However, be careful to replace only the General Survey scores with these new scores. Do not change the scores for the Course Survey. Also note that a period is used to denote a decimal point (some participants may be accustomed to using a comma instead, but using a comma will result in the answer being scored as incorrect).

Suggestion: Choose to "save as" and give the spreadsheet a new name to show that it is the "quiz" version. The reason is that you will need the original spreadsheet (with the original scores) when you complete the next Excel video tutorial.

Answer the following question based on these new scores.