COVARIANCE.S

The COVARIANCE.S function in Google Sheets calculates the covariance of a dataset, where the dataset is treated as a sample of the total population. It measures how two variables change together, which is a core building block of statistical and financial analysis. Dive into our comprehensive guide to master its application.

Parameters

• data_y: The range representing the dependent dataset.
• data_x: The range representing the independent dataset.

Step-by-Step Tutorial

1. Using COVARIANCE.S with two datasets:
   • Example: If A1:A3 is 2, 4, 6 and B1:B3 is 1, 2, 3, then =COVARIANCE.S(A1:A3, B1:B3) will return 2.

Use Cases and Scenarios

1. Financial Analysis: Calculate the covariance between the returns of two stocks to gauge how they move together.
2. Market Research: Determine the covariance between two variables collected from a sample survey.
3. Scientific Research: Analyze the covariance between two sets of experimental sample data.

Related Functions

• COVARIANCE.P: Calculates the covariance of a dataset, where the dataset represents the entire population.
• COVAR: Calculates the covariance of a dataset (legacy version of the covariance functions).
• CORREL: Calculates the correlation coefficient of a dataset.

Related Articles

• Understanding Statistical Functions in Google Sheets