Statistical functions on variables

 

These functions calculate statistics on variables, without the need to specify a range. Be careful when you use these functions in cells of the columns that correspond to the variables, because this actually adds a value to the variable which can lead to unexpected and faulty results. You can exclude the cells to avoid this.

 

VAVEDEV(variable[,filter]) returns the average deviation of a variable

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

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

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

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

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

VCORREL(variable1,variable2[,filter]) returns the correlation between 2 variables

VCOVAR(variable1,variable2[,filter]) returns the covariance of 2 variables

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

VHARMEAN(variable[,filter]) returns the harmonic mean of a variable

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

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

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

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

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

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

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

VSLOPE(variable1,variable2[,filter]) returns the slope of the regression line between 2 variables

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

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

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

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

VSUMSQ(variable[,filter]) returns the sum of the squares of the observations of a variable

VTrimMean(k,variable[,filter]) returns the trimmed mean of a variable

VTrimMeanSEM(k,variable[,filter]) returns the standard error of a trimmed mean of a variable

VTrimMeanLOW(k,ci,variable[,filter]) returns the lower value of a confidence interval of a trimmed mean of a variable

VTrimMeanHIGH(k,ci,variable[,filter]) returns the higher value of a confidence interval of a trimmed mean of a variable

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

See also

This site uses cookies to store information on your computer. More info...