Exploring Linear Regression and Correlation in Excel

There is no relationship between the variables

Both variables increase together

One variable increases while the other decreases

Both variables decrease together

0 to 100

-0.5 to 0.5

-1 to 1

0 to 1

Strong positive correlation

Moderate correlation

Strong negative correlation

Little or no correlation

Correlation coefficient less than 0.3

Correlation coefficient between 0.3 and 0.75

Correlation coefficient greater than 0.75

Correlation coefficient equal to 1

Temperature and Sales

Time and Quantity

Degrees Fahrenheit and Number of Water Bottles Sold

X and Y

X Y Scatter

Line Graph

Bar Graph

Pie Chart

Double-click the y-axis

Use the 'Insert' menu

Double-click the x-axis

Right-click the chart

To change the color of the points

To visualize the relationship between variables

To add labels to the points

To create a pie chart

The change in water bottle sales per degree increase in temperature

The average temperature

The total number of water bottles sold

The maximum temperature recorded

Multiply r-squared by 2

Subtract r-squared from 1

Divide r-squared by 2

Take the square root of r-squared