EXCEL在分布拟合中的应用

The Use of Excel in Distribution Fitting

结合实例分析,介绍了应用Excel软件进行描述统计、正态概率纸检验和线性回归的一般步骤,给出了应用Excel软件进行分布拟合的一般方法.Kolmogorov-Smirnov检验的p值证明了实例分析的正确性.

Combined with example analysis, the general steps of descriptive statistics, normal probability paper test and linear regression using Excel were introduced, and the general method of distribution fitting was given. The p value of Kolmogorov - Smimov test proved the correctness of the analysis in this paper.