统计函数的英文

全份SPSS函数表(SPSS Functions)，可以到下面的网址下载。全文是英文来的，目前只找到这一份，资料有点旧，但胜在全面。这资料是美国德克萨斯州大学奥斯汀分校(University of Texas at Austin)教育心理学系助理教授(Assistant Professor of the Department of Educational Psychology) Rachel Tanya Fouladi (Ph.D., University of British Columbia, 1996)在2000年秋季课程「SPSS数据分析」(EDP 384: Data Analysis Using SPSS)课堂上所发放的讲义。由於至今已过了6年，SPSS版本不断更新，提供更多功能；这份资料所引的函数数目「可能」会有所遗漏，(「可能」未能把最新版本SPSS新增的函数纳入其中)，请读者注意。由於篇幅所限，在这边只贴出上述资料中最常用的几大类：1.Logical functions逻辑函数2.Missing value functions缺失值函数3.Arithmetic functions算术函数4.Statistical functions统计函数5.Random variable functions随机变量函数1. Logical FunctionsANY(test,value[,value,...]) Logical. Returns 1 or true if the value of testmatches any of the subsequent values; returns 0 or false otherwise. Thisfunction requires two or more arguments.RANGE(test,lo,hi[,lo,hi,...]) Logical. Returns 1 or true if test is within any of theinclusive range(s) defined by the lo, hi pairs. Arguments must be all numericor all strings of the same length, and each of the lo, hi pairs must be orderedwith lo <= hi.2. Missing Value FunctionsNMISS(variable[,...]) Numeric. Returns a count of the arguments that havemissing values. This function requires one or more arguments, which shouldbe variable names in the working data file.MISSING(variable) Logical. Returns 1 or true if variable has a missing value.The argument should be a variable name in the working data file.SYSMIS(numvar) Logical. Returns 1 or true if the value of numvar is systemmissing.The argument numvar must be the name of a numeric variable inthe working data file.VALUE(variable) Numeric or string. Returns the value of variable, ignoringuser-missing value definitions for variable, which must be a variable name inthe working data file.3. Arithmetic FunctionsABS(numexpr) Numeric. Returns the absolute value of numexpr, which mustbe numeric.ARSIN(numexpr) Numeric. Returns the inverse sine, in radians, of numexpr,which must evaluate to a numeric value between -1 and +1.ARTAN(numexpr) Numeric. Returns the inverse tangent, in radians, ofnumexpr, which must be numeric.COS(radians) Numeric. Returns the cosine of radians, which must be anumeric value, measured in radians.EXP(numexpr) Numeric. Returns e raised to the power numexpr, where e isthe base of the natural logarithms and numexpr is numeric. Large values ofnumexpr may produce results that exceed the capacity of the machine.LN(numexpr) Numeric. Returns the base-e logarithm of numexpr, which mustbe numeric and greater than 0.LG10(numexpr) Numeric. Returns the base-10 logarithm of numexpr, whichmust be numeric and greater than 0.MOD(numexpr,modulus) Numeric. Returns the remainder when numexpr isdivided by modulus. Both arguments must be numeric, and modulus mustnot be 0.RND(numexpr) Numeric. Returns the integer that results from roundingnumexpr, which must be numeric. Numbers ending in .5 exactly are roundedaway from 0.SIN(radians) Numeric. Returns the sine of radians, which must be a numericvalue, measured in radians.SQRT(numexpr) Numeric. Returns the positive square root of numexpr, whichmust be numeric and not negative.TRUNC(numexpr) Numeric. Returns the value of numexpr truncated to aninteger (toward 0).4. Statistical FunctionsCFVAR(numexpr,numexpr[,...]) Numeric. Returns the coefficient of variation(the standard deviation divided by the mean) of its arguments that have validvalues. This function requires two or more arguments, which must benumeric. You can specify a minimum number of valid arguments for thisfunction to be evaluated.LAG(variable) Numeric or string. Returns the value of variable for the previouscase in the data file. Returns system-missing (numeric variables) or blank(string variables) for the first case.LAG(variable,ncases) Numeric or string. Returns the value of variable for thecase that is ncases earlier in the file. Returns system-missing (numericvariables) or blank (string variables) for the first ncases cases.MAX(value,value[,...]) Numeric or string. Returns the maximum value of itsarguments that have valid values. This function requires two or morearguments. You can specify a minimum number of valid arguments for thisfunction to be evaluated.MEAN(numexpr,numexpr[,...]) Numeric. Returns the arithmetic mean of itsarguments that have valid values. This function requires two or morearguments, which must be numeric. You can specify a minimum number ofvalid arguments for this function to be evaluated.MIN(value,value[,...]) Numeric or string. Returns the minimum value of itsarguments that have valid values. This function requires two or morearguments. You can specify a minimum number of valid arguments for thisfunction to be evaluated.NVALID(variable[,...]) Numeric. Returns a count of the arguments that havevalid, nonmissing values. This function requires one or more arguments,which should be variable names in the working data file.SD(numexpr,numexpr[,...]) Numeric. Returns the standard deviation of itsarguments that have valid values. This function requires two or morearguments, which must be numeric. You can specify a minimum number ofvalid arguments for this function to be evaluated.SUM(numexpr,numexpr[,...]) Numeric. Returns the sum of its arguments thathave valid values. This function requires two or more arguments, which mustbe numeric. You can specify a minimum number of valid arguments for thisfunction to be evaluated.VARIANCE(numexpr,numexpr[,...]) Numeric. Returns the variance of itsarguments that have valid values. This function requires two or morearguments, which must be numeric. You can specify a minimum number ofvalid arguments for this function to be evaluated.5. Random Variable FunctionsNORMAL(stddev) Numeric. Returns a normally distributed pseudo-randomnumber from a distribution with mean 0 and standard deviation stddev, whichmust be a positive number. You can repeat the sequence of pseudo-randomnumbers by setting a seed in the Preferences dialog box before eachsequence.RV.BERNOULLI(prob) Numeric. Returns a random value from a Bernoullidistribution with the specified probability parameter prob.RV.BETA(shape1, shape2) Numeric. Returns a random value from a betadistribution with the specified shape parameters.RV.BINOM(n, prob) Numeric. Returns a random value from a binomialdistribution with the specified number of trials and probability parameter.RV.CAUCHY(loc, scale) Numeric. Returns a random value from a Cauchydistribution with the specified location and scale parameters.RV.CHISQ(df) Numeric. Returns a random value from a chi-square distributionwith the specified degrees of freedom df.RV.EXP(shape) Numeric. Returns a random value from an exponentialdistribution with the specified shape parameter.RV.F(df1, df2) Numeric. Returns a random value from an F distribution with thespecified degrees of freedom df1 and df2.RV.GAMMA(shape, scale) Numeric. Returns a random value from a gammadistribution with the specified shape and scale parameters.RV.GEOM(prob) Numeric. Returns a random value from a geometricdistribution with the specified probability parameter.RV.HYPER(total, sample, hits) Numeric. Returns a random value from ahypergeometric distribution with the specified parameters.RV.LAPLACE(mean, scale) Numeric. Returns a random value from a Laplacedistribution with the specified mean and scale parameters.RV.LOGISTIC(mean, scale) Numeric. Returns a random value from a logisticdistribution with the specified mean and scale parameters.RV.LNORMAL(a, b) Numeric. Returns a random value from a log-normaldistribution with the specified parameters.RV.NEGBIN(threshold, prob) Numeric. Returns a random value from anegative binomial distribution with the specified threshold and probabilityparameters.RV.NORMAL(mean, stddev) Numeric. Returns a random value from a normaldistribution with the specified mean and standard deviation.RV.PARETO(threshold, shape) Numeric. Returns a random value from aPareto distribution with the specified threshold and shape parameters.RV.POISSON(mean) Numeric. Returns a random value from a Poissondistribution with the specified mean or rate parameter.RV.T(df) Numeric. Returns a random value from a Student’s t distribution withthe specified degrees of freedom df.RV.UNIFORM(min, max) Numeric. Returns a random value from a uniformdistribution with the specified minimum and maximum. See also theUNIFORM function.RV.WEIBULL(a, b) Numeric. Returns a random value from a Weibulldistribution with the specified parameters.UNIFORM(max) Numeric. Returns a uniformly distributed pseudo-randomnumber between 0 and the argument max, which must be numeric (but canbe negative). You can repeat the sequence of pseudo-random numbers bysetting the same random number seed (available on the Transform menu)before each sequence.除此之外，还有：6.Distribution functions (cumulative & inverse cumulative)7.Conversion functions8.String functions9.Date and time functions详请看资料原文。