《EXCEL教程绝对实用.pptVIP

EXCEL教程绝对实用 二项分布 泊松分布 超几何分布 5.3.5 绘制泊松分布图 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 5.4 超几何分布 超几何分布（hypergeometric distribution） 用于无放回实验中成功的概率 超几何分布的特征： 离散分布 每个结果只有成功或失败 样本为无放回抽样 总体N是有限的并已知 总体中成功的数目A已知 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 超几何分布公式： N—总体大小 n —样本大小 A—总体中的成功次数 X—样本中的成功次数（无放回抽取样本法） 超几何分布假设样本空间中剩余的元素被选为样本的几率是一样的。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 出现以下情况，可以用二项分布代替超几何分布： 无放回抽取样本，并且n≥5%N Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 5.4.1 用Excel进行分析 使用Excel函数HYPGEOMDIST ( X, n, A, N ) 例 题 ： 假设美国主要的18家计算机公司中12家位于硅谷，从18家中随机抽取3家，其中至少有一家位于硅谷的概率是多少？ 解答： N=18， n=3，A=12，X≥1 本题包括3种情况：X=1，X=2，X=3。 无放回抽样，n/N=16.6%≥5%，用超几何分布解答 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2