Calculate the correlation coefficient for the given table of Sales and Expenses.

Check the final answer first, then review the worked steps.

Answer

0.94

Work

r = \frac{n\sum xy - (\sum x)(\sum y)}{\sqrt{[n\sum x^2 - (\sum x)^2][n\sum y^2 - (\sum y)^2]}} \approx 0.94

Step-by-step solution

  1. Enter the data into a calculator or spreadsheet: $x = \{55.6, 48, 62.7, 23.5, 23.7, 60.7, 20.3, 51.8, 23, 33\}$ and $y = \{44, 29.2, 74, 11.8, 9, 49.9, 20.1, 27.9, 19.2, 31.1\}$.
  2. Use the correlation coefficient function (often labeled $r$ or CORREL) to compute the value.
  3. The calculation yields $r \approx 0.9427...$.
  4. Round the result to two decimal places: $0.94$.