Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hey!
I´m having a little problem generating a few random numbers. The thing is this: I have a huge list of people and I need to assign a random number between 0.0 and 1.25 to each one. The problem is I need the following: 70% of people to have a number between 1 and 1.2 20% of people to have a number greater than 1.2 10% of people to have a number below 1 Do you know how to do this??? Thanks!! |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Why don't you stop posting this and look at the answers you already have
-- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''s razor (Abbrev) "John Pivot Table" wrote: Hey! I´m having a little problem generating a few random numbers. The thing is this: I have a huge list of people and I need to assign a random number between 0.0 and 1.25 to each one. The problem is I need the following: 70% of people to have a number between 1 and 1.2 20% of people to have a number greater than 1.2 10% of people to have a number below 1 Do you know how to do this??? Thanks!! |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Sorry for all the posts... the server kept telling me an error occured so I
thought it didnt work! "Mike H" wrote: Why don't you stop posting this and look at the answers you already have -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''s razor (Abbrev) "John Pivot Table" wrote: Hey! I´m having a little problem generating a few random numbers. The thing is this: I have a huge list of people and I need to assign a random number between 0.0 and 1.25 to each one. The problem is I need the following: 70% of people to have a number between 1 and 1.2 20% of people to have a number greater than 1.2 10% of people to have a number below 1 Do you know how to do this??? Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random Numbers excluding Previous Numbers | Excel Worksheet Functions | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) |