MCL Reference > Statistics in a Race

The RunnersAvg( ) function returns the average of a datum about a runner in a particular race.

Syntax

RunnersAvg('nValueExpr',cRaceID,'fCondition')

Argument

Description

Example

'nValueExpr'

•	Datum the average of which is to be found.

•	Data type of expression: Numeric

'HrBodyweight( )'

cRaceID

Race ID (default to underlying race). Normally, this is a string returned by the functions HrRaceID( ), JrRaceID( ) and SrRaceID( ).

'17222'

'fCondition'

Logical expression to filter out a particular set of runners in the race.

'HrFP( )<=3'

Returns

The function returns a numeric value.

Examples

RunnersAvg('Bodyweight( )')

Returns the average Body Weight of the underlying race.

RunnerAvg('Bodyweight( )','17222')

Returns the average Body Weight of the race of ID '17222', i.e., the 222nd race of season 97-98.

RunnerAvg('Bodyweight( )',,'HrFP( )<=3')

Returns the average Body Weight amount the 3 fastest horses in the underlying race.

RunnerAvg('Bodyweight( )','17222','HrFP( )<=3')

Returns the average Body Weight amount the 3 fastest horses of the race of ID '17222', i.e., the 222 nd race of season 97-98.