Linear regression & correlation worksheet with answers

Free printable Linear regression & correlation worksheet: 6 problems from easy to exam level, with an answer key. Print it or save it as a PDF.

For teachers: free to print, copy and use in class. Every new worksheet has new values and its own answer key. A link to ExamProblems on your course page is appreciated.

Name: ____________________   Date: ____________

1.Easy
xy245357459565668769xy246506070

The table gives 6 paired observations of x = advertising spend in k€ and y = sales in k€. Use the least-squares line ŷ = a + b·x. Find the slope b.

n = 6
b =
2.Easy
xy181122012122138241372616228166xy2025120140160

The table gives 6 paired observations of x = temperature in °C and y = ice creams sold. Use the least-squares line ŷ = a + b·x. Find the intercept a.

n = 6
a =
3.Medium
xy3545597769821110213114xy5106080100120

The table gives 6 paired observations of x = advertising spend in k€ and y = sales in k€. Their sums are given. Find Pearson's correlation coefficient r from these sums.

n = 6Σx = 48Σy = 487Σx² = 454Σy² = 42297Σxy = 4331
r =
4.Medium
xy157317881993211032311225128xy15202580100120

The table gives 6 paired observations of x = temperature in °C and y = ice creams sold. Their sums are given. Find Pearson's correlation coefficient r from these sums.

n = 6Σx = 120Σy = 597Σx² = 2470Σy² = 61259Σxy = 12297
r =
5.Hard
xy178620103231212612429148xy202530100120140ŷ = 109

The table gives 5 paired observations of x = temperature in °C and y = ice creams sold. Use the least-squares line ŷ = a + b·x. For which value x does the line predict ŷ = 109?

n = 5ŷ = 109
x =
6.Hard
xy1413495537659761185xy510406080x = 8

The table gives 6 paired observations of x = advertising spend in k€ and y = sales in k€. Use the least-squares line ŷ = a + b·x. Predict ŷ for x = 8.

n = 6x = 8
ŷ =

Answer key

  1. 1. b = 4.543
  2. 2. a = 10.53
  3. 3. r = 0.9881
  4. 4. r = 0.99
  5. 5. x = 21.47
  6. 6. ŷ = 70.44

Full step-by-step solutions: practise this topic on examproblems.com.