6: Clarius Model 4200A-SCS Parameter Analyzer
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)
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)
Also see
STDEVP (on page 6-293)
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)
The date as a serial number or as text (for example,
or
)
Details
Extracts the year from the serial number created by the NOW function.
Example
=YEAR("06/21/16")
Returns 2.0160E+3.
Returns the present year.
Also see
DAY (on page 6-278)
HOUR (on page 6-280)
MINUTE (on page 6-287)
MONTH (on page 6-288)
NOW (on page 6-289)
SECOND (on page 6-291)