Stats 4.4 Correlation coefficient r in Google Sheets app
Channel: Dana Lee Ling
Date: 2020-05-01

An introduction to using Google Sheets app CORREL function to calculate the Karl Pearson Product-Moment Correlation Coefficient known better as r. Note the in video correction that the slope of "no relationship" is close to zero, not one. 

Textbook: http://www.comfsm.fm/~dleeling/statistics/text6.html#page-044
Stats 4.4 Correlation pre-content advanced organizer: https://www.youtube.com/watch?v=31YFhMxEWAU
Stats 4.3 Qualitative nature and strength of the relationship between two variables: https://www.youtube.com/watch?v=YpzzPrRjMAc
Spreadsheet (includes subsequent coefficient of determination calculations):
https://docs.google.com/spreadsheets/d/1oYtC8f8mb5rEW0kAvIRcaj7KlWD661_kj-gUrifYq2I/edit?usp=sharing
See also: https://www.youtube.com/playlist?list=PL1cKZPBHOgjHWd4-csnDSDm-YUYNgBkm5