基于Excel函数及图表工具的泊松分布卡方检验法应用

Poisson Distribution Chi-Square Test Method Based on Excel Function and Chart Tools

根据泊松分布检验计算原理,利用Excel函数,计算出了各统计数据的参数及卡方值,以自动查找临界值,并可以利用图表工具绘制统计数据直方图。该模板适合泊松分布卡方检验,具有界面直观、操作简单、速度快捷的特点。

According to poisson distribution test calculation principle,Excel function is used to calculateeach parameter and chi-square statistics values,and automatically find the critical value.And chart tools can be used to draw the statistics histogram.This template is suitable for poisson distribution chi-square test with intuitive interface,simple operation and fast speed.