Excel的“描述统计”工具虽能一次给出十几项数值,但要计算其中的某一项数值,还需使用统计函数。用于描述统计的函数是按未分组资料设计的,如遇分组资料则可使用公式直接计算。下面分别按数列的集中趋势和离散程度说明其操作方法。一、集中趋势的描述1. 描述数列集中趋势最常用 Although Excel’s Descriptive Statistics tool can give more than a dozen numerical values ​​at a time, it requires the use of statistical functions to calculate one of these values. The functions used to describe the statistics are designed on un-grouped data, and in the case of grouped data, the formulas are used to calculate directly. The following are listed according to the central tendency of the series and discrete degree of operation method. First, a description of the trend of concentration 1. Describe the trend of the most common series