谁有SPSS 中的函数表

谁有SPSS 中的函数表
谁有SPSS 中的函数表

谁有SPSS 中的函数表
全份SPSS函数表(SPSS Functions),可以到下面的网址下载.
http://www.edb.utexas.edu/faculty/fouladi/e384lec7f.pdf
全文是英文来的,目前只找到这一份,资料有点旧,但胜在全面.
这资料是美国德克萨斯州大学奥斯汀分校(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 Functions
ANY(test,value[,value,...]) Logical. Returns 1 or true if the value of test
matches any of the subsequent values; returns 0 or false otherwise. This
function requires two or more arguments.
RANGE(test,lo,hi[,lo,hi,...]) Logical. Returns 1 or true if test is within any of the
inclusive range(s) defined by the lo, hi pairs. Arguments must be all numeric
or all strings of the same length, and each of the lo, hi pairs must be ordered
with lo <= hi.
2. Missing Value Functions
NMISS(variable[,...]) Numeric. Returns a count of the arguments that have
missing values. This function requires one or more arguments, which should
be 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 in
the working data file.
VALUE(variable) Numeric or string. Returns the value of variable, ignoring
user-missing value definitions for variable, which must be a variable name in
the working data file.
3. Arithmetic Functions
ABS(numexpr) Numeric. Returns the absolute value of numexpr, which must
be 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, of
numexpr, which must be numeric.
COS(radians) Numeric. Returns the cosine of radians, which must be a
numeric value, measured in radians.
EXP(numexpr) Numeric. Returns e raised to the power numexpr, where e is
the base of the natural logarithms and numexpr is numeric. Large values of
numexpr may produce results that exceed the capacity of the machine.
LN(numexpr) Numeric. Returns the base-e logarithm of numexpr, which must
be numeric and greater than 0.
LG10(numexpr) Numeric. Returns the base-10 logarithm of numexpr, which
must be numeric and greater than 0.
MOD(numexpr,modulus) Numeric. Returns the remainder when numexpr is
divided by modulus. Both arguments must be numeric, and modulus must
not be 0.
RND(numexpr) Numeric. Returns the integer that results from rounding
numexpr, which must be numeric. Numbers ending in .5 exactly are rounded
away from 0.
SIN(radians) Numeric. Returns the sine of radians, which must be a numeric
value, measured in radians.
SQRT(numexpr) Numeric. Returns the positive square root of numexpr, which
must be numeric and not negative.
TRUNC(numexpr) Numeric. Returns the value of numexpr truncated to an
integer (toward 0).
4. Statistical Functions
CFVAR(numexpr,numexpr[,...]) Numeric. Returns the coefficient of variation
(the standard deviation divided by the mean) of its arguments that have valid
values. This function requires two or more arguments, which must be
numeric. You can specify a minimum number of valid arguments for this
function to be evaluated.
LAG(variable) Numeric or string. Returns the value of variable for the previous
case 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 the
case that is ncases earlier in the file. Returns system-missing (numeric
variables) or blank (string variables) for the first ncases cases.
MAX(value,value[,...]) Numeric or string. Returns the maximum value of its
arguments that have valid values. This function requires two or more
arguments. You can specify a minimum number of valid arguments for this
function to be evaluated.
MEAN(numexpr,numexpr[,...]) Numeric. Returns the arithmetic mean of its
arguments that have valid values. This function requires two or more
arguments, which must be numeric. You can specify a minimum number of
valid arguments for this function to be evaluated.
MIN(value,value[,...]) Numeric or string. Returns the minimum value of its
arguments that have valid values. This function requires two or more
arguments. You can specify a minimum number of valid arguments for this
function to be evaluated.
NVALID(variable[,...]) Numeric. Returns a count of the arguments that have
valid, 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 its
arguments that have valid values. This function requires two or more
arguments, which must be numeric. You can specify a minimum number of
valid arguments for this function to be evaluated.
SUM(numexpr,numexpr[,...]) Numeric. Returns the sum of its arguments that
have valid values. This function requires two or more arguments, which must
be numeric. You can specify a minimum number of valid arguments for this
function to be evaluated.
VARIANCE(numexpr,numexpr[,...]) Numeric. Returns the variance of its
arguments that have valid values. This function requires two or more
arguments, which must be numeric. You can specify a minimum number of
valid arguments for this function to be evaluated.
5. Random Variable Functions
NORMAL(stddev) Numeric. Returns a normally distributed pseudo-random
number from a distribution with mean 0 and standard deviation stddev, which
must be a positive number. You can repeat the sequence of pseudo-random
numbers by setting a seed in the Preferences dialog box before each
sequence.
RV.BERNOULLI(prob) Numeric. Returns a random value from a Bernoulli
distribution with the specified probability parameter prob.
RV.BETA(shape1, shape2) Numeric. Returns a random value from a beta
distribution with the specified shape parameters.
RV.BINOM(n, prob) Numeric. Returns a random value from a binomial
distribution with the specified number of trials and probability parameter.
RV.CAUCHY(loc, scale) Numeric. Returns a random value from a Cauchy
distribution with the specified location and scale parameters.
RV.CHISQ(df) Numeric. Returns a random value from a chi-square distribution
with the specified degrees of freedom df.
RV.EXP(shape) Numeric. Returns a random value from an exponential
distribution with the specified shape parameter.
RV.F(df1, df2) Numeric. Returns a random value from an F distribution with the
specified degrees of freedom df1 and df2.
RV.GAMMA(shape, scale) Numeric. Returns a random value from a gamma
distribution with the specified shape and scale parameters.
RV.GEOM(prob) Numeric. Returns a random value from a geometric
distribution with the specified probability parameter.
RV.HYPER(total, sample, hits) Numeric. Returns a random value from a
hypergeometric distribution with the specified parameters.
RV.LAPLACE(mean, scale) Numeric. Returns a random value from a Laplace
distribution with the specified mean and scale parameters.
RV.LOGISTIC(mean, scale) Numeric. Returns a random value from a logistic
distribution with the specified mean and scale parameters.
RV.LNORMAL(a, b) Numeric. Returns a random value from a log-normal
distribution with the specified parameters.
RV.NEGBIN(threshold, prob) Numeric. Returns a random value from a
negative binomial distribution with the specified threshold and probability
parameters.
RV.NORMAL(mean, stddev) Numeric. Returns a random value from a normal
distribution with the specified mean and standard deviation.
RV.PARETO(threshold, shape) Numeric. Returns a random value from a
Pareto distribution with the specified threshold and shape parameters.
RV.POISSON(mean) Numeric. Returns a random value from a Poisson
distribution with the specified mean or rate parameter.
RV.T(df) Numeric. Returns a random value from a Student’s t distribution with
the specified degrees of freedom df.
RV.UNIFORM(min, max) Numeric. Returns a random value from a uniform
distribution with the specified minimum and maximum. See also the
UNIFORM function.
RV.WEIBULL(a, b) Numeric. Returns a random value from a Weibull
distribution with the specified parameters.
UNIFORM(max) Numeric. Returns a uniformly distributed pseudo-random
number between 0 and the argument max, which must be numeric (but can
be negative). You can repeat the sequence of pseudo-random numbers by
setting the same random number seed (available on the Transform menu)
before each sequence.
除此之外,还有：
6.Distribution functions (cumulative & inverse cumulative)
7.Conversion functions
8.String functions
9.Date and time functions
详请看资料原文.http://www.edb.utexas.edu/faculty/fouladi/e384lec7f.pdf