-----------------------------------------------------------------------------------------------------------------------------------------
During the Lesson, the learner will:
1: Review the lesson instructions.
2: Read the article entitled "Opposites Don't Attract".
3: Read chapter 12, Correlation and Regression, in the textbook.
4: View the video: Correlation, part 1 (10:30). Notes are provided.
5: View the video: Correlation, part 2 (6:43).
6: View the video: Correlation, part 3 (4:47).
7: View the video: Correlation, part 4 (9:43).
8: View the video: Using Excel for Correlation (2:24).
9: Download the document: Using Excel’s CORREL Function to Determine Correlation.
10: View the video: Using Excel for Scatterplots (4:23).
11: Review the study questions.
12: Review the video solutions to select study questions.
----------------------------------------------------------------------------------------------------------------
Read the one-page news article entitled "Opposites Don't Attract". Notice the use of correlation in the article.
----------------------------------------------------------------------------------------------------------------
Read Chapter 12 of the textbook
Caldwell, S. (2010). Statistics Unplugged. (4th ed.) Thomson Wadsworth: Belmont, California.
----------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will give an introduction to the subject of correlation . (Video notes are available for download. Click here to download them.)
Click on the television or use this link to view this episode of the Lecture Series
----------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will continue to give an introduction to the topic of correlation.
Click on the television or use this link to view this episode of the Lecture Series
----------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will continue the discussion of correlation.
Click on the television or use this link to view this episode of the Lecture Series
----------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will conclude the discussion of correlation and will introduce the coefficient of determination.
Click on the television or use this link to view this episode of the Lecture Series
----------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will demonstrate how to use Excel to compute Pearson's R using the Data Analysis add-in.
Click on the television or use this link to view this episode of the Lecture Series
----------------------------------------------------------------------------------------------------------------
Excel has a function (CORREL) that computes Pearson's r. It is especially useful for Mac users who do not have the Data Analysis add-in. Download the document here for instructions on how to use it.
----------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will demonstrate how to create a scatterplot graph in Excel.
Click on the television or use this link to view this episode of the Lecture Series
----------------------------------------------------------------------------------------------------------------
The attached Study Questions are for review only. They do not have to be completed and submitted as an assignment. Answers to selected questions may be given.
----------------------------------------------------------------------------------------------------------------
Below are links to video explanations of selected study questions from this lesson. Click on the Study Question to view the video.
Study Question 7 ..... (1:32)
Study Question 8 ..... (1:38)
Study Question 9 ..... (1:29)
Study Question 10 ..... (1:54)
Study Question 11 ..... (1:29)
----------------------------------------------------------------------------------------------------------------