怎么用EXCEL生成不定概率的随机数0 0.1% 1 0.3% 2 0.6% 3 1.0% 4 1.5% 5 2.1% 6 2.8% 7 3.6% 8 4.5% 9 5.5% 10 6.3% 11 6.9% 12 7.3% 13 7.5% 14 7.5% 15 7.3% 16 6.9% 17 6.3% 18 5.5% 19 4.5% 20 3.6% 21 2.8% 22 2.1% 23 1.5% 24 1.0% 25 0.6% 26 0.3%

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/05 15:38:23
怎么用EXCEL生成不定概率的随机数0 0.1% 1 0.3% 2 0.6% 3 1.0% 4 1.5% 5 2.1% 6 2.8% 7 3.6% 8 4.5% 9 5.5% 10 6.3% 11 6.9% 12 7.3% 13 7.5% 14 7.5% 15 7.3% 16 6.9% 17 6.3% 18 5.5% 19 4.5% 20 3.6% 21 2.8% 22 2.1% 23 1.5% 24 1.0% 25 0.6% 26 0.3%

怎么用EXCEL生成不定概率的随机数0 0.1% 1 0.3% 2 0.6% 3 1.0% 4 1.5% 5 2.1% 6 2.8% 7 3.6% 8 4.5% 9 5.5% 10 6.3% 11 6.9% 12 7.3% 13 7.5% 14 7.5% 15 7.3% 16 6.9% 17 6.3% 18 5.5% 19 4.5% 20 3.6% 21 2.8% 22 2.1% 23 1.5% 24 1.0% 25 0.6% 26 0.3%
怎么用EXCEL生成不定概率的随机数
0 0.1%
1 0.3%
2 0.6%
3 1.0%
4 1.5%
5 2.1%
6 2.8%
7 3.6%
8 4.5%
9 5.5%
10 6.3%
11 6.9%
12 7.3%
13 7.5%
14 7.5%
15 7.3%
16 6.9%
17 6.3%
18 5.5%
19 4.5%
20 3.6%
21 2.8%
22 2.1%
23 1.5%
24 1.0%
25 0.6%
26 0.3%
27 0.1%
按照上面的概率生成随机数,

怎么用EXCEL生成不定概率的随机数0 0.1% 1 0.3% 2 0.6% 3 1.0% 4 1.5% 5 2.1% 6 2.8% 7 3.6% 8 4.5% 9 5.5% 10 6.3% 11 6.9% 12 7.3% 13 7.5% 14 7.5% 15 7.3% 16 6.9% 17 6.3% 18 5.5% 19 4.5% 20 3.6% 21 2.8% 22 2.1% 23 1.5% 24 1.0% 25 0.6% 26 0.3%
vba代码实现