Apple Numbers '08 - Manual (Page 224)

224 Chapter 12 Dictionary of Functions
COVAR
The COVAR function calculates the covariance of two data sets.
COVAR(range1, range2)
 range1: A reference to the cells containing the first data set.
 range2: A reference to the cells containing the second data set. The dimensions of
range1 and range2 must be the same.
Notes
If the two data sets are identical, the covariance is the same as the population variance.
DATE
The DATE function combines separate year, month, and day values into a single date.
DATE(year, month, day)
 year: A year number.
 month: A month number.
 day: A day number.
Notes
Year values aren’t converted. If you specify 10, the year 10 is evaluated, not the year 1910
or 2010.
Examples
If A1:A4 contain 2/1/2000, 1/1/2001, 4, 0:
COUPNUM(A1, A2, A3, A4) returns 4.
COUPNUM(DATE(2000,6,1), A2, A3, A4) returns 3.
COUPNUM(DATE(2000,9,1), A2, A3, A4) returns 2.
COUPNUM(DATE(2000,11,1), A2, A3, A4) returns 1.
Examples
If range1 (C3:H3) contains 3.4, 3.7, 4, 4.4, 5.1, 5.4 and range2 (C2:H2) contains 2.1, 3.3, 4.5, 5.5, 6.4, 7.2:
COVAR(C3:H3, C2:H2) returns 1.234.
Examples
DATE(1959,2,14) returns Feb 14, 1959, which is displayed according to the cell’s current format.