第六章 例子的Excel实现

例6.1.1DXe0.040.80.9375<-=1-DX/e2例6.2.1npq=1-p2600.040.96用“单变量求解”功能求解b，得b＝1.65bf(b)1.650.950528532≥95%x=15.61例6.2.20.0002000635<-=1-f(3.54)用正态分布近似二项分布例3.2.4（1）knpq=1-p40100000.0050.9950.0207（2）knpq=1-p70100000.0050.9950.997710.99774直接用2位小数例6.2.3n1n2np801001000.8P(80≤X≤100)0.460<-直接用二项分布函数，=BINOMDIST(100,100,0.8,1)-BINOMDIST(80,100,0.8,1)0.500<-用标准正态分布函数近似=NORMSDIST((C25-D25*E25)/SQRT(D25*E25*(1-E25)))-NORMSDIST((B25-D25*E25)/SQRT(D25*E25*(1-E25)))例6.2.4n1n2np68007200100000.7P(6800≤X≤7200)1.000<-直接用二项分布函数，=BINOMDIST(7200,10000,0.7,1)-BINOMDIST(6800,10000,0.7,1)1.000<-用标准正态分布函数近似=NORMSDIST((C31-D31*E31)/SQRT(D31*E31*(1-E31)))-NORMSDIST((B31-D31*E31)/SQRT(D31*E31*(1-E31)))例6.3.2合格率p0.8合格率下限p176%合格率上限p284%成功次数下限k1292.6<-=n×p1＝76％n成功次数上限k2323.4<-=n×p2＝84％nn385P(问题)0.9520261995<-=BINOMDIST(385*84%,385,0.8,1)-BINOMDIST(385*76%,385,0.8,1)≥95%