二项分布资料统计推断的 Excel 快速实现

摘要

Objective:To investigate the implementation method of statistical inference for binomial dis-tribution in Excel.Methods:With the application of Excel functions,such as BINOMDIST,FINV,NORMS-INV and otherwise,the probability that the the positive times was m ,no more than m and just m,the quan-tile of normal distribution and F distribution during n times of independent tests can be obtained under the condition that the positive probability was p in each times.Deploy p,n,m and other original data and the final conclusion of statistical analysis on the same interface,conceal the other intermediate computing data,final conclusion of statistical analysis can be presented immediately along with the original data.Results:When im-plementing the statistical inference for binomial distribution data,the statistical analysis can be obtained only through logging in relevant p,n and m instead of imputing any statistical formal and command if the Excel worksheet has been created.Conclusion:it is possible to conduct statistical inference for common binomial dis-tribution data visually and quickly with the application of Excel.%目的：：探讨对二项分布资料进行统计推断的 Excel 实现方法。方法：利用 Excel 函数 BINOMDIST、FINV、NORMS-INV 等,可得到在每次试验中阳性的概率为 p 的条件下,n 次独立试验中阳性次数为m 时至多m 次阳性的概率和刚好m 次阳性的概率以及正态分布、F 分布的分位数。将 p 、n、m 等原始数据与最终统计分析结论部署在同一界面,将其他中间计算数据隐藏,最终统计分析结论可随原始数据立即呈现。结果：建立“二项分布资料统计推断”的 Excel 工作表后,进行二项分布资料的统计推断时仅仅录入相关的 p 、n、m,不须再录入任何统计公式和命令,就能立即得到统计分析的结果。结论：利用 Excel 能直观快速进行常见二项分布资料的统计推断。