文档介绍：Nominaldata列名数据(定类数据)Ordinaldata顺序数据(定序数据)Intervaldata间隔数据(定距数据)Ratiodata比率数据(定比数据)Descriptivestatistics描述统计学inferentialstatistics推断统计学Elementaryunits基本单位Population总体Qualitativevariable定性变量quantitativevariable定量变量Samplesurvey抽样调查Census(人口)普查Probabilitysample概率抽样nonprobabilitysample非概率抽样Outliers异常值Barchart柱状图Piechart饼图Scatterdiagram散点图Histogram直方图Classmark组内代表值classwidth组距Frequency频数Open-endedclass开口组PercapitaGDP人均GDPArithmeticmean算术平均数Geometricmean几何平均数Range极差,全距interquartilerange四分位差,内距Median中位数Mode众数Parameter参数Statistic统计量Variance方差standarddeviation标准差Meanabsolutedeviation平均差Skewness偏度Kurtosis峰度Coefficientofvariation离散系数stockpriceindexes股票价格指数consumerpriceindex(CPI)binedindex总指数Aggregativeindexnumber综合指数Averageindexnumber平均数指数intermediatefactor同度量因素(媒介因素)Laspeyresindexes拉氏指数Paascheindexes派氏指数Fisher’sidealindexes费雪理想指数SimpleLinearCorrelation简单线性相关Regression回归Residuals残差CoefficientofCorrelation相关系数OrdinaryLeastSquares最小二乘法Independentvariable自变量Dependentvariable因变量Slope斜率Intercept截距CoefficientofDetermination决定系数timeseries时间序列Long-termtrend长期趋势Seasonalfluctuation季节变动Movingaveragesmethod移动平均法seasonalindexes季节指数Functions:Countif(range,criteria)用来计算区域中满足给定条件的单元格的个数。Frequency(data-array,bins-array)以一列垂直数组返回一组数据的频率分布。Average(number1,number2,……)返回其参数的算术平均,参数可以是数值或者包含数值的名称,数组或引用。Sum(number1,number2,……)是对当前选定表的指定数值字段或全部数值字段进行求和。Geomean(number1,number2,……)返回一正数数组或数值