另一方面，利用Excel的CHIINV (函数可以生成卡方分布的概率值。 函数格式： CHIINV (概率，自由度) ) ) ) ) ) ) )。
注： NORMSDIST (标准正态分布表； NORMSINV )标准正态分布分位数表； TINV )t分布阈值表； FINV )f分布阈值表
二、在Excel中，在B2单元格中输入公式'=chiinv(b$1，$A2 ) '，从下到右复制即可得到卡方分布阈值表。 如下表所示(部分，df/a自行输入) :
卡方分布阈值表df/a 0.9950.990.9750.950.10.0250.010.00513.92704 e-050.00015710.0009820.0039320.0157912.8414595.023885 0506333 599.2103410.5966330.0717217750.11483180.2157950.3518460.584460 890930.29710950.4844190.7107231.0636237 0.55429810.8336714 716.749660.675726770.87209031.2373441.6353832.20413110.6446412.5915914.4493816.8111111818180 481.3444130871.646497312.7326373.48953913.3615715.5073117.534520.090273.3615715 815914.6836616.9189819. 9733.9402994.86518215.9871818.9871818 413.8157484.5748135.57778517.2750119.6751421.9200524.7249726.756818 5034584.10691555.0087515.8918647.04150519.8119322.3620324.735627.6882529.81947144.0746749574.660000574.8529 54675622.3071324.9957927.4883930.5779132.8007132 3.5418326.2962328.8453531.999334.26719175.6972171016 . 37 0469.39045510.8649425.9894228.869331.5263834.8053137.15645196.8439714457.63272968.90651610.111170111。 28.4119831.4104334.1696137.5662339.99685218.033653428.897197910 31741.40106228.6427164019.54242492310.98232310 3642.79565239.924836 35.1724638.0756341.638444.18128249.88623350210.85636112.4011513.8484315.6586833.1983 24840.6464744.314146.927892611.1602374112.19814713.843915.3791617.2918835.563335.87850414.5733816.1515141414112 812.4613359513.5647115.3078616.4449.461https://513 382913.1211488914.25645516.0470719.7677439.087474747449 46.9792450.8921853.6719633603359转载于www.cn blogs.com/syd nia/p/7284404.html