统计函数的英文

全份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详请看资料原文。

countif=count+if。count的音标：[kaʊnt]；if的音标：[ɪf]，所以countif的音标是[kaʊnt][if]。

countif函数是Microsoft Excel中对指定区域中符合指定条件的单元格计数的一个函数，在WPS，Excel2003和Excel2007等版本中均可使用。

该函数的语法规则如下：

countif（range，criteria）

参数1：range 要计算其中非空单元格数目的区域；

参数2：criteria 以数字、表达式或文本形式定义的条件。

扩展资料：

与countif相同类型的函数还有countifs，是Excel2007中新增函数，为countif函数的扩展。用法与countif类似，但countif针对单一条件，而countifs可以实现多个条件同时求结果。

该函数的语法规则如下：

countifs(criteria_range1,criteria1,criteria_range2,criteria2,…)

参数1：criteria_range1为第一个需要计算其中满足某个条件的单元格数目的单元格区域（简称条件区域）；

参数2：criteria1为第一个区域中将被计算在内的条件（简称条件），其形式可以为数字、表达式或文本。例如，条件可以表示为 48、"48"、">48" 、 "广州" 或 A3；

同理，criteria_range2为第二个条件区域，criteria2为第二个条件，依次类推。最终结果为多个区域中满足所有条件的单元格个数。

示例：

求产地为广州且单价大于等于3，库存量大于20的品种个数，公式为=COUNTIFS(B2:B10,"广州",C2:C10,">=3",D2:D10,">20")

参考资料来源：百度翻译-count

参考资料来源：百度翻译-if

参考资料来源：百度百科-countif函数

参考资料来源：百度百科-COUNTIFS

COUNT 函数用于计算包含数字的单元格及参数列表中数字的个数，可使用该函数获取数字区域或数组中的数字字段中的项目数。 COUNT函数功能 返回包含数字以及包含参数列表中的数字的单元格的个数.利用函数COUNT可以计算单元格区域或数字数组中数字字段的输入项个数 COUNT函数语法 翻译白话格式： COUNT(目标单元格1,目标单元格2,...)  COUNT(目标单元格区域) 参数说明 Value：为包含或引用各种类型数据的参数(1到30个),但只有数字类型的数据才被计算 注意事项： 函数COUNT在计数时,将把数字、日期、或以文本代表的数字计算在内；但是错误值或其他无法转换成数字的文字将被忽略 COUNT函数使用方法实例 你学会了吗？ 谢谢大家的观看，我们下一期再见，如果有什么问题欢迎评论区留言或私信我们 想学习更多的函数知识，欢迎关注转发

countif是个计算机函数，这个具体意义就不赘述了。countif事实上不是一个单词，而是countifcount英[kaʊnt]美[kaʊnt]n.总数;数数;罪状;论点;v.数数;计算总数;把…算入;重要;合起来，countif就是“一个总数中……如果……“的一个函数意义仅此答复，愿可帮助您。谢谢！