Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
Do you want the total or the average to be 80 (in the equation you have shown
the total as 80)? By the very nature of this problem, only 9 of those 10 numbers can be truly random (the 10th is constrained by the fact that the average of the 10 numbers has got to be 80). Generate 9 random numbers between 50 and 100, using =(rand()+1)*50, say in A1 thru A9. The 10th number (A10) is =800-sum(A1:A9). Due to the random nature of the first 9 numbers, the 10th may not necessarily fall in the required range, 50-100; hit F9 repeatedly till the 10th number also falls in that range (this may need several attempts). B.R.Ramachandran "Daniel Lugones" wrote: I have a number, lets say 80. I want to find other values, lets say 10 number values, between 50 and 100 such as that those numbers added have an average of 80. In other words: a + b + c + d + e + f + g +... = 80 How can I find random values between 50 and 100 (a, b, c, d, etc) whose average is 80. Is it possible in Excel 2000? thank you. Daniel Lugones |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |