← Back to List functions

List.Covariance

This function calculates the covariance value between two lists, numberList1 and numberList2. It is important to note that numberList1 and numberList2 should have an equal number of numerical values f...

Syntax

List.Covariance(numberList1 as list, numberList2 as list) as nullable number

About

This function calculates the covariance value between two lists, numberList1 and numberList2. It is important to note that numberList1 and numberList2 should have an equal number of numerical values for accurate computation.

Explanation

Determine the covariance between two sets by using the Power Query MList.Covariance function with the input lists ({1, 2, 3}, {1, 2, 3}). The resulting output is 0.66666666666666607.