SheetFX
≡
<< Go back to all functions

RSQ

The RSQ function in Google Sheets calculates the square of r, which is the Pearson product-moment correlation coefficient of a dataset. It is used to determine the strength and direction of the linear relationship between two sets of data.

Function Syntax and Parameters

Syntax: RSQ(data_y, data_x)

Parameters:

  • data_y: The range of dependent data points.
  • data_x: The range of independent data points.

Step-by-Step Tutorial

To calculate the square of r using the RSQ function, follow these steps:

  1. Select a cell where you want to display the result.
  2. Enter the formula =RSQ(data_y, data_x), replacing data_y and data_x with the actual ranges of your data points.

Use Cases and Scenarios

The RSQ function can be used in various scenarios including:

  1. Finance: Determine the correlation between two stocks' price movements.
  2. Health Sciences: Measure the relationship between a patient's age and blood pressure.
  3. Market Research: Analyze the correlation between advertising expenditure and sales revenue.

Related Functions

  • CORREL: Calculates the correlation coefficient between two dataset ranges.
  • SLOPE: Calculates the slope of the linear regression line for a dataset.

Related Articles