Keithley 4200A-SCS - VARP Calc Worksheet Function; YEAR Calc Worksheet Function

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
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)
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
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)