This function returns the population covariance, which is the average of the products of deviations for each data point pair in two sets of numbers.
COVARIANCE.P(array1,array2)
引数として指定する2つのデータ配列は、次の基準を満たす必要があります。
Use this covariance function to determine the relationship between two sets of data. For example, you can determine whether greater income accompanies greater levels of education in a population.
The covariance is calculated as follows, where n and y are the sample means, AVERAGE(array1) and AVERAGE(array2), and n is the sample size.
Accepts arrays of numeric data for both arguments. Returns numeric data.
COVARIANCE.P(J2:J5,L2:L5)
COVARIANCE.P(R2C12:R15C12,R2C14:R15C14)
COVARIANCE.P({7,5,6},{7,4,4}) gives the result 1
COVARIANCE.P({5,10,15,20,25},{4,8,16,32,64}) gives the result 144
製品バージョン 7.0 以降で使用できます。