Nevron .NET Vision
Chart for .NET / User's Guide / Data Manipulation / Functions / Statistical Functions / Average

In This Topic
    In This Topic
    AVERAGE(arg1 [; ByEveryN])
    The 'arg1' argument must be an array.
    ByEveryN is an optional argument - an integer constant, greater or equal to 1.
    Returns a scalar value, which is the average value of the elements in the array 'arg1'.
    If the 'ByEveryN' parameter is supplied, then the function calculates the average value for each group of N successive elements and the result is an array.

    Calculates the average of the elements in the input array, or the average of every N successive elements in the input array.

    Example 1:

    Expression: AVERAGE( arg1 )

    arg1 11 7 3 5 6 1

    Result: 5.5

    Example 2:

    (average by every 2 elements)

    Expression: AVERAGE( arg1; 2 )

    arg1 11 7 3 5 6 1
    result 9 4 3.5
     Related Examples
    Windows Forms: All Examples\Data Manipulation\Functions\Average, Median, Min, Max