Agree aggregation functions to implement

[jim-smith]

spss list: https://www.ibm.com/support/pages/how-do-i-aggregate-spss

Aggregate functions include:

• SUM(varlist) Sum across cases.

• MEAN(varlist) Mean across cases.

• MEDIAN(varlist) Median across cases.

• SD(varlist) Standard deviation across cases.

• MAX(varlist) Maximum value across cases.

• MIN(varlist) Minimum value across cases.

• PGT(varlist,value) Percentage of cases greater than the specified value.

• PLT(varlist,value) Percentage of cases less than the specified value.

• PIN(varlist,value1,value2) Percentage of cases between value1 and value2, inclusive.

• POUT(varlist,value1,value2) Percentage of cases not between value1 and value2. Cases where the source variable equals value1 or value2 are not counted.

• FGT(varlist,value) Fraction of cases greater than the specified value.

• FLT(varlist,value) Fraction of cases less than the specified value.

• FIN(varlist,value1,value2) Fraction of cases between value1 and value2, inclusive.

• FOUT(varlist,value1,value2) Fraction of cases not between value1 and value2. Cases where the source variable equals value1 or value2 are not counted.

• N(varlist) Weighted number of cases in break group.

• NU(varlist) Unweighted number of cases in break group.

• NMISS(varlist) Weighted number of missing cases.

• NUMISS(varlist) Unweighted number of missing cases.

• FIRST(varlist) First nonmissing observed value in break group.

• LAST(varlist) Last nonmissing observed value in break group.

[jim-smith]

TODO find out what stata, spas and sas do then consult

[jim-smith]

this is what state provides

mean semean sebinomial sepoisson variance sd skewness kurtosis cv svycv count median p# q1 q2 q3 iqr min max range first last firstnm lastnm total rawtotal fvfrequency fvrawfrequency fvproportion fvrawproportion fvpercent fvrawpercent

Definitions mean error of the mean error of the mean, binomial error of the mean, Poisson standard standard standard variance standard skewness kurtosis coefficient of variation coefficient of variation (svy) number of nonmissing values median

th percentile

first quartile second quartile third quartile interquartile range minimum value maximum value range first value last value first nonmissing value last nonmissing value total unweighted total frequency of each factor-variable level unweighted frequency of each factor-variable level proportion within each factor-variable level unweighted proportion within each factor-variable level percentage within each factor-variable level unweighted percentage within each factor-variable level

[jim-smith]

We have basics agreed and implemented. Closing, in favour of adding separate issues for each additional aggregation feature as identified by workpackage1 ( or doing them in batches)