LESSON 12 - Correlation and Regression

back to menu

-----------------------------------------------------------------------------------------------------------------------------------------

12.1 Lesson To Do List

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.

----------------------------------------------------------------------------------------------------------------

12.2 Reading: Opposites Don't Attract

Read the one-page news article entitled "Opposites Don't Attract".  Notice the use of correlation in the article.

Click here to download the article

----------------------------------------------------------------------------------------------------------------

12.3 Reading Assignments: Chapter 12 of the Textbook

Read Chapter 12 of the textbook

Caldwell, S.  (2010).  Statistics Unplugged.  (4th ed.) Thomson Wadsworth: Belmont, California.

----------------------------------------------------------------------------------------------------------------

12.4 Video: Correlation, part 1 (10:30)

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

x

----------------------------------------------------------------------------------------------------------------

12.5 Video: Correlation, part 2 (6:43)

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

x

----------------------------------------------------------------------------------------------------------------

12.6 Video: Correlation, part 3 (4:47)

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

x

----------------------------------------------------------------------------------------------------------------

12.7 Video: Correlation, part 4 (9:43)

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

x

----------------------------------------------------------------------------------------------------------------

12.8 Video: Using Excel's Data Analysis to Compute Correlation Coefficients (2:24)

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

x

----------------------------------------------------------------------------------------------------------------

12.9 Using Excel's CORREL Function to Determine Correlation

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.

----------------------------------------------------------------------------------------------------------------

12.10 Video: Using Excel to Create a Scatterplot (4:23)

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

x

----------------------------------------------------------------------------------------------------------------

12.11 Study Questions

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.

----------------------------------------------------------------------------------------------------------------

12.12 Solutions to Selected Study Questions (video explanations)

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)

----------------------------------------------------------------------------------------------------------------

back to menu