生成"n"个a和b之间的随机数以在m行中达到期望的平均值 [英] Generate "n" random numbers between a and b to reach desired average in m rows

问题描述

假设在Z列中有200行是我的最佳平均值.

Suppose in column Z with 200 rows, are my optimal averages.

现在，我想要一个宏，该宏在a和b(含)之间生成n随机整数(n <= 20)，以便使用最佳平均值生成的数字平均值之间的差在(-0.15,+0.15)中.

Now I want a macro that generates n random integers between a and b inclusive (n <= 20) so that difference between the average of numbers generated with optimal average is in (-0.15,+0.15).

示例:

Z1:optimal average1=5.5
Z2:optimal average2=5.3

Z200:optimal average200=6.3
n=8
a=1; b=10
numbers of generated:
A1:H1)5-9-4-3-7-4-9-3
A2:H2)10-7-3-2-5-4-3-9
.
.
.
A200:H200)4-8-9-6-6-6-10-2

推荐答案

在此处输入图像说明

两个均值之差不在(0.15+，0.15-)范围内

The difference between two means is not within range (0.15+, 0.15-)

这篇关于生成"n"个a和b之间的随机数以在m行中达到期望的平均值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！