SheetFX
≡
<< Go back to all functions

CORREL

The CORREL function in Google Sheets calculates the Pearson product-moment correlation coefficient (r) of a dataset. It is used to determine the strength and direction of the relationship between two sets of data.

Function Syntax and Parameters

Syntax: CORREL(data_y, data_x)

Parameters:

  • data_y: The range of cells representing the dependent variable data.
  • data_x: The range of cells representing the independent variable data.

Step-by-Step Tutorial

  1. Using CORREL to calculate the correlation coefficient:
    • Example: =CORREL(A1:A10, B1:B10)
    • Result: This formula will calculate the correlation coefficient (r) between the values in cells A1 to A10 and B1 to B10.

Use Cases and Scenarios

  1. Financial Analysis: Determine the correlation between two stock prices.
  2. Market Research: Measure the relationship between advertising expenditure and sales revenue.
  3. Scientific Research: Analyze the correlation between two variables in an experiment.

Related Functions

  • PEARSON: Calculates the Pearson correlation coefficient of a dataset.
  • SLOPE: Calculates the slope of a linear regression line.

Related Articles