# 3.5.2.2 Averageif

## Description

This function is used to calculate the mean of values that satisfies a specified condition.

 double Averageif(vector vd, string con$) ## Parameters vd is a vector within which you want to calculate the mean of values that satisfy the condition. con$

is the condition you use to filter vector vd (i.e. a string that contains some conditional expression). Double quotation ("") must be used for literal conditions.

## Return

Return the mean of values that satisfy the condition vcon.

## Example

newbook;
col(A) = data(1,15);
// Based on the literal condition "col(A) > 5 && col(A) < 10"
// this should return the average of {6,7,8,9} or 7.5
averageif(col(A),"col(A) > 5 && col(A) < 10")=;
// We can also pass the condition as a string variable
string strCond$= "col(A) < 6 || col(A) > 9"; AveVal = averageif(col(A),strCond$);
ty \$(AveVal);