CAJ | 학술논문

目的：：探讨对二项分布资料进行统计推断的 Excel 实现方法。方法：利用 Excel 函数 BINOMDIST、FINV、NORMS-INV 等,可得到在每次试验中阳性的概率为 p 的条件下,n 次独立试验中阳性次数为m 时至多m 次阳性的概率和刚好m 次阳性的概率以及正态分布、F 分布的分位数。将 p 、n、m 等原始数据与最终统计分析结论部署在同一界面,将其他中间计算数据隐藏,最终统计分析结论可随原始数据立即呈现。结果：建立“二项分布资料统计推断”的 Excel 工作表后,进行二项分布资料的统计推断时仅仅录入相关的 p 、n、m,不须再录入任何统计公式和命令,就能立即得到统计分析的结果。结论：利用 Excel 能直观快速进行常见二项分布资料的统计推断。
목적：：탐토대이항분포자료진행통계추단적 Excel 실현방법。방법：이용 Excel 함수 BINOMDIST、FINV、NORMS-INV 등,가득도재매차시험중양성적개솔위 p 적조건하,n 차독립시험중양성차수위m 시지다m 차양성적개솔화강호m 차양성적개솔이급정태분포、F 분포적분위수。장 p 、n、m 등원시수거여최종통계분석결론부서재동일계면,장기타중간계산수거은장,최종통계분석결론가수원시수거립즉정현。결과：건립“이항분포자료통계추단”적 Excel 공작표후,진행이항분포자료적통계추단시부부록입상관적 p 、n、m,불수재록입임하통계공식화명령,취능립즉득도통계분석적결과。결론：이용 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.