Calculates the average value of a set of
numbers.
|
Function |
Group |
Execution |
Windows |
Embedded |
Thin Client |
| Avg
|
Statistical |
Synchronous |
Supported |
Supported |
Supported |
Syntax
Avg( numValue1, numValue2, … , numValueN )
Avg( "tagArray", numSample, optNumIgnore )
Note: This
function has two formats:
- If the first parameter is a numeric tag or value,
you must use the Avg( numValue1, numValue2,
… , numValueN ) format.
- If the first parameter is an array tag in
double-quotes or a string tag, you must use the Avg( "tagArray", numSample, optNumIgnore )
format.
- numValue (1…N)
- Integer or Real tags containing the numbers to be
averaged together.
- tagArray
- Name of array tag (Real or Integer) containing the
values to be averaged.
- numSample
- The number of array elements to be averaged.
- optNumIgnore
- Optional Integer or Real tag containing the value to
be ignored in calculating the average.
Returned value
Returns the average of the values.
Examples
|
Tag Name |
Expression |
|
Tag |
Avg( 1, 2.34, 5, 7, 4, 8, 9.4 ) //
Returned value = 5.248571 |
|
Tag |
Avg( 1, 5, -9, 0, 5, 3 ) // Returned
value = 0.833333 |
|
Tag Name |
Expression |
|
Tag |
Avg( "tagArray[1]", 3 ) // If
tagArray[1]=10, tagArray[2]=20 and tagArray[3]=60, then the
Returned Value = 30 |
|
Tag |
Avg( "tagArray[1]", 3, 10 ) // If
tagArray[1]=10, tagArray[2]=20 and tagArray[3]=60, then the
Returned Value = 40 |