Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
B. R.Ramachandran
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What function would let me find Batting Averages? pertimesco Excel Worksheet Functions 2 March 1st 05 01:38 PM
What function would let me find Batting Averages? pertimesco Excel Worksheet Functions 1 March 1st 05 01:03 PM
What function would let me find Batting Averages? pertimesco Excel Worksheet Functions 0 March 1st 05 10:21 AM
What function would let me find Batting Averages? pertimesco Excel Worksheet Functions 0 March 1st 05 10:11 AM
Excel has a "Find Next" command but no "Find Previous" command. Michael Fitzpatrick Excel Discussion (Misc queries) 2 January 10th 05 11:45 PM


All times are GMT +1. The time now is 04:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"