Spreadsheet: Statistical functions on variables

VAVEDEV

VAVEDEV(variable[,criterion]) returns the average of absolute deviations of a variable

VAVERAGE

VAVERAGE(variable[,criterion]) returns the average of a variable

VCOEFVAR

VCOEFVAR(variable[,criterion]) returns the coefficient of variation of a variable

VCOUNT

VCOUNT(variable[,criterion]) returns the number of numerical data of a variable

VCOUNTNEG

VCOUNTNEG(variable[,criterion]) counts the negative observations of a variable

VCOUNTPOS

VCOUNTPOS(variable[,criterion]) counts the positive observations of a variable

VGEOMEAN

VGEOMEAN(variable[,criterion]) returns the geometric mean of a variable

VMAX

VMAX(variable[,criterion]) returns the maximum value of a variable

VMEDIAN

VMEDIAN(variable[,criterion]) returns the median value of a variable

VMIN

VMIN(variable[,criterion]) returns the minimum value of a variable

VPERCENTILE

VPERCENTILE(centile,variable[,criterion]) returns a percentile value of a variable

VPERCRANK

VPERCRANK(value,variable[,criterion]) returns the percentile rank of a value

VPERCRANKR

VPERCRANKR(variable,group) returns the percentile rank of a value

VSEM

VSEM(variable[,criterion]) returns the standard error of the mean of a variable

VSTDEV

VSTDEV(variable[,criterion]) returns the standard deviation of a variable

VSUM

VSUM(variable[,criterion]) returns the sum of observations of a variable

VSUMNEG

VSUMNEG(variable[,criterion]) returns the sum of the negative observations of a variable

VSUMPOS

VSUMPOS(variable[,criterion]) returns the sum of the positive observations of a variable

VVAR

VVAR(variable[,criterion]) returns the variance of a variable

See also

• Spreadsheet: Introduction
• Operators
• Relative and absolute cell addresses
• Mathematical functions
• Statistical functions
• String functions
• Logical functions
• Date and time functions
• Miscellaneous functions