Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I generate test data
I want to generate sample data - maybe 200 numbers from 1 to 7 but wieghted
towards one end - any ideas? |
#2
|
|||
|
|||
Hi
Bernd Plumhoff posted this formula recently for generating random numbers between two values (stored in A1 and B1) ... so select your 200 cells type this formula and use control & enter to enter it into all the selected cells at once. =MIN($A$1,$B$1)+INT(RAND()*(MAX($A$1,$B$1)-MIN($A$1,$B$1)+1)) This however, doesn't weight them in any way. Cheers JulieD "giles" wrote in message ... I want to generate sample data - maybe 200 numbers from 1 to 7 but wieghted towards one end - any ideas? |
#3
|
|||
|
|||
Weighted how?
Here's one way to get a distribution weighted toward 0. Select A1:A200, and array-enter (CTRL-SHIFT_ENTER or CMD-RETURN): =INT(RAND()*RAND()*7)+1 conversely, weighted toward 7 (also array-entered): =7-INT(RAND()*RAND()*8) You could also enter regularly each formula in cell A1 and copy down. In article , "giles" wrote: I want to generate sample data - maybe 200 numbers from 1 to 7 but wieghted towards one end - any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |