| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create a Graph with Random Number Generator
"Luke Williams" wrote in message
... "Tushar Mehta" wrote: In article , says... Hello, I'm trying to reproduce a graphic. It was made using the random generator number. Since, I am not very confortable with statistics I thought someone could help me with this. The X axis represents days. The Y axis a Flow volume that ranges from 0.4 to 32. The graphic represents a "possibility" model of a flow during a year. For example, Day 1 to Day 12, the flow is 23.5 litres. Day 62 to 100, the flow is 0.4 litres. There are only 3 possibilities: 0.4, 23.5 or 32.0. Please help, it's driving me nuts! Suppose your dates are in col. A starting with A2. Then, in B2 enter the formula =CHOOSE(INT(RAND()*3+1),0.4,23.5,32). Copy B2 as far down col. B as you have dates in col. A. Plot the data in A:B. I was able to translate your formula! Thanks! Is there a way also to make sure that the number does not appear more than twice? I get for example in cell b2, b3, b4 the same number I would like not more than 2 cells with the same number. If you're saying that instead of the random choice you don't want more than 2 consecutive rows with the same value, you could use a COUNTIF on the 2 rows above your current row, and if you've got 2 rows of the same number then do your new CHOOSE between just the 2 remaining values (and equivalently for 2 of each of your 3 options), otherwise choose between the 3 values as above. -- David Biddulph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random Number Generator | Excel Worksheet Functions | |||
| Random Number Generator | Excel Worksheet Functions | |||
| Excel random number | Excel Discussion (Misc queries) | |||
| How can I get Positive values only from the random number generat. | Excel Discussion (Misc queries) | |||
| Random number generator | Excel Worksheet Functions | |||
Threaded Mode
