用EXCEL演示二项分布

,用EXCEL动态演示二项分布,,,

,输入起始最小例数,1,输入起始最小率,0.25

,输入结束最大例数,500,输入结束最大率,0.95

,渐变速度（秒）,3,渐变速度（秒）,0.01

点击此格确定设置完成,,,,

请输入欲抽样的例数,400,,阳性个数,380

请输入欲抽样总体阳性率,0.95,,阴性个数,20

抽到的阳性个数,抽到的阴性个数,可能的样本率,各样本率发生的概率,

0,400,0,0,

1,399,0.0025,0,

2,398,0.005,0,

3,397,0.0075,0,

4,396,0.01,0,

5,395,0.0125,0,

6,394,0.015,0,

7,393,0.0175,0,

8,392,0.02,0,

9,391,0.0225,0,

10,390,0.025,0,

11,389,0.0275,0,

12,388,0.03,0,

13,387,0.0325,0,

14,386,0.035,0,

15,385,0.0375,0,

16,384,0.04,0,

17,383,0.0425,0,

18,382,0.045,0,

19,381,0.0475,0,

20,380,0.05,0,

21,379,0.0525,0,

22,378,0.055,0,

23,377,0.0575,0,

24,376,0.06,0,

25,375,0.0625,0,

26,374,0.065,0,

27,373,0.0675,0,

28,372,0.07,0,

29,371,0.0725,0,

30,370,0.075,0,

31,369,0.0775,0,

32,368,0.08,0,

33,367,0.0825,0,

34,366,0.085,0,

35,365,0.0875,0,

36,364,0.09,0,

37,363,0.0925,0,

38,362,0.095,0,

39,361,0.0975,0,

40,360,0.1,0,

41,359,0.1025,0,

42,358,0.105,0,

43,357,0.1075,0,

44,356,0.11,0,

45,355,0.1125,0,

46,354,0.115,0,

47,353,0.1175,0,

48,352,0.12,0,

49,351,0.1225,0,

50,350,0.125,0,

51,349,0.1275,0,

52,348,0.13,0,

53,347,0.1325,0,

54,346,0.135,0,

55,345,0.1375,0,

56,344,0.14,0,

57,343,0.1425,0,

58,342,0.145,0,

59,341,0.1475,0,

60,340,0.15,0,

61,339,0.1525,0,

62,338,0.155,0,

63,337,0.1575,0,

64,336,0.16,0,

65,335,0.1625,0,

66,334,0.165,0,

67,333,0.1675,0,

68,332,0.17,0,

69,331,0.1725,0,

70,330,0.175,0,

71,329,0.1775,0,

72,328,0.18,0,

73,327,0.1825,0,

74,326,0.185,0,

75,325,0.1875,0,

76,324,0.19,0,

77,323,0.1925,0,

78,322,0.195,0,

79,321,0.1975,0,

80,320,0.2,0,

81,319,0.2025,0,

82,318,0.205,0,

83,317,0.2075,0,

84,316,0.21,0,

85,315,0.2125,0,0

86,314,0.215,0,

87,313,0.2175,0,

88,312,0.22,0,

89,311,0.2225,0,

90,310,0.225,0,

91,309,0.2275,0,

92,308,0.23,0,

93,307,0.2325,0,

94,306,0.235,0,

95,305,0.2375,0,

96,304,0.24,0,

97,303,0.2425,0,

98,302,0.245,0,

99,301,0.2475,0,

100,300,0.25,0,

101,299,0.2525,0,

102,298,0.255,0,

103,297,0.2575,0,

104,296,0.26,0,

105,295,0.2625,0,

106,294,0.265,0,

107,293,0.2675,0,

108,292,0.27,0,

109,291,0.2725,0,

110,290,0.275,0,

111,289,0.2775,0,

112,288,0.28,0,

113,287,0.2825,0,

114,286,0.285,0,

115,285,0.2875,0,

116,284,0.29,0,

117,283,0.2925,0,

118,282,0.295,0,

119,281,0.2975,0,

120,280,0.3,0,

121,279,0.3025,0,

122,278,0.305,0,

123,277,0.3075,0,

124,276,0.31,0,

125,275,0.3125,0,

126,274,0.315,0,

127,273,0.3175,0,

128,272,0.32,0,

129,271,0.3225,0,

130,270,0.325,0,

131,269,0.3275,0,

132,268,0.33,0,

133,267,0.3325,0,

134,266,0.335,0,

135,265,0.3375,0,

136,264,0.34,0,

137,263,0.3425,0,

138,262,0.345,0,

139,261,0.3475,0,

140,260,0.35,0,

141,259,0.3525,0,

142,258,0.355,0,

143,257,0.3575,0,

144,256,0.36,0,

145,255,0.3625,0,

146,254,0.365,0,

147,253,0.3675,0,

148,252,0.37,0,

149,251,0.3725,0,

150,250,0.375,0,

151,249,0.3775,0,

152,248,0.38,0,

153,247,0.3825,0,

154,246,0.385,0,

155,245,0.3875,0,

156,244,0.39,0,

157,243,0.3925,0,

158,242,0.395,0,

159,241,0.3975,0,

160,240,0.4,0,

161,239,0.4025,0,

162,238,0.405,0,

163,237,0.4075,0,

164,236,0.41,3.117E-195,

165,235,0.4125,8.4708E-194,

166,234,0.415,2.2784E-192,

167,233,0.4175,6.0658E-191,

168,232,0.42,1.5984E-189,

169,231,0.4225,4.1691E-188,

170,230,0.425,1.0764E-186,

171,229,0.4275,2.7507E-185,

172,228,0.43,6.9584E-184,

173,227,0.4325,1.7424E-182,

174,226,0.435,4.319E-181,

175,225,0.4375,1.0598E-179,

176,224,0.44,2.5741E-178,

177,223,0.4425,6.1895E-177,

178,222,0.445,1.4733E-175,

179,221,0.4475,3.4718E-174,

180,220,0.45,8.0988E-173,

181,219,0.4525,1.8703E-171,

182,218,0.455,4.2761E-170,

183,217,0.4575,9.6785E-169,

184,216,0.46,2.1687E-167,

185,215,0.4625,4.811E-166,

186,214,0.465,1.0566E-164,

187,213,0.4675,2.2974E-163,

188,212,0.47,4.9456E-162,

189,211,0.4725,1.054E-160,

190,210,0.475,2.224E-159,

191,209,0.4775,4.6459E-158,

192,208,0.48,9.6087E-157,

193,207,0.4825,1.9675E-155,

194,206,0.485,3.9888E-154,

195,205,0.4875,8.0063E-153,

196,204,0.49,1.5911E-151,

197,203,0.4925,3.1304E-150,

198,202,0.495,6.098E-149,

199,201,0.4975,1.1761E-147,

200,200,0.5,