Unit 3 Scatterplots and Correlation



Statistics are used all the time in the "Real World" If you watch TV, are interested in politics, Or watch sports you are innundated with statistics all the time. Generally statistics are used to support some point or convince you to buy, or buy in to, something or someone. It is easy to be swayed by an array of flashy, impressive looking, charts and graphs. Only by truly understanding statistics though can we insure we make intelligent decisions.

1. We will start out by creating a scatter plot with a line of best fit using data that we collected earlier in the project.

  • If you chose baseball you will use Team Salary and Number of Wins
  • If you choose movies you will use Production Budget and Percent of Positive reviews

2. Once you have created your scatterplot calculate the Correlation Coefficient

You may refer to the following links to help as necessary


What is Correlation?

Calculating Correlation in Excel

3. Now that we have a scatterplot and have calculated the correlation coefficient I want you to look at what you have created. Think about the x axis and what it represents as compared to the y axis and what it represents. Now I want to to give me some sort of conclusion that can be drawn from your data and explain where you came up with it. If no conclusion can be drawn explain that as well.

4. Explain in your own words correlation and causation. Are they the same? Provide an example of each.

5. Explain how the scatterplot you created can be used to make predictions on situations. For example, how many games could your team expect to win with a team salary of 120 million dollars? Based on your graph and calculations how accurate would these predictions be? Explain...

Upon completion of all the above click the link below to return to the main page and continue to the next section

Design Project: Using Real World Data to Teach Statistics and Probability