在Excel中完成序贯检验的计算及其评价

目的在Excel中完成序贯检验程序的编制及其结果的评价。方法应用Excel中函数语句、计算和绘图功能，编写序贯检验的统计程序；结合实例比较和评价Excel程序的运算结果。结果在序贯检验的Excel程序中直接输入检验标准、检验水准和实验数据，即可提示统计结论和试验结束的样本例数，显示序贯检验图以及标准曲线的坐标方程；Excel程序的计算结果与文献的结果一致。结论在Excel中可准确、简便、直观地完成序贯检验的统计分析。

Accomplishing the sequential test in Excel

Objective To accomplish the sequential test in Excel and evaluate the calculating results. Methods The computer program of the sequential test was edited applying statistical and graphical function of Excel and the calculating results of examples was evaluated. Results The output of the sequential test chart and statistical conclusions were generated and pres- ented following the input of the sizes of the test and experimental data in Excel. The outcomes were agreed with those calculated by literatures and SPSS. Conclusion It turned out that the statistical method of sequential test could be operating using Excel with convenience, quickness, accuracy.