COVAR (PQL - xl)

This function returns the confidence interval for a population mean

Syntax

COVAR(array1, array2)

Function Arguments

Name

Description

Type

Optional

array1

Contain numbers, names, arrays, or references that are numeric. If some cells do not contain numeric data, they are ignored, sets should be the same size, with the same number of data points, sets should not be empty, nor should the standard deviation of their values equal zero

StringOrNumber

array2

Contain numbers, names, arrays, or references that are numeric. If some cells do not contain numeric data, they are ignored, sets should be the same size, with the same number of data points, sets should not be empty, nor should the standard deviation of their values equal zero

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'COVAR' function - using the same inputs, logic and outputs.