Section 6: Clarius
Model 4200A-SCS Parameter Analyzer Reference Manual
6-296
4200A-901-01 Rev. C / February 2017
VARP Calc worksheet function
This command returns the variance of a population based on an entire population of values.
Usage
VARP(
Value_list
)
Value_list
A list of as many as 30 numbers, separated by commas
Details
Value_list
can contain numbers or a reference to a range that contains numbers.
Example
=VARP(4.0, 3.0, 3.0, 3.5, 2.5, 4.0, 3.5)
Returns
265.3061E-3
.
Also see
YEAR Calc worksheet function
This command returns the year component of the supplied date and time serial number or text-formatted date.
Usage
YEAR(
Serial_number
)
Serial_number
The date as a serial number or as text (for example,
06-21-15
or
21-Jun-15
)
Details
Extracts the year from the serial number created by the
NOW
function.
Example
=YEAR(39328)
=YEAR("06/21/16")
=YEAR(NOW())
Returns
2.0070E+3
.
Returns
2.0160E+3
.
Returns the present year.
Also see
(on page 6-278)
(on page 6-280)
(on page 6-287)
(on page 6-289)
(on page 6-291)
