Round function VBA EXCEL
alf.cz
I need simulate classic play cube (values 1-6) by Rnd function. My solution is Round(5 * Rnd() + 1, 0) , but when I generate 1 milion values, I have not good results (by picture). 
I think, that problem is in bad use of ROUND function, but I do not know where. Thank you for your answers...
bobajob
Let's look at this piece-by-piece.
Rnd() gives a number between 0 and 1.
So 5 * Rnd() + 1 gives a number between 1 and 6.
We can think of this number as being equally likely to be in one of 10 half-integer areas: [1,1.5], [1.5,2]...[5.5,6].
One of these will round to 1 - [1,1.5].
Two of these will round to 2 - [1.5,2] and [2,2.5].
3, 4 and 5 similarly have two of these which will round to them.
One of these will round to 6 - [5.5,6]
This explains the distribution you're seeing.
Therefore Round(6 * Rnd() + 0.5, 0) should give you what you're looking for as it extends the area by half in both directions, so gives 1 and 6 the correct weightings.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Three.js skybox not loading
- Next: Complexity of nested for loops starting from the last iteration
Related
Related Related
- 1
Equivalent of Excel Round function
- 2
Excel VBA method ROUND is incorrect
- 3
Excel VBA function to solve impossible round-robin tournament roster with venue constraint
- 4
Excel function to VBA
- 5
Excel not finding VBA Function
- 6
Excel VBA and Group function
- 7
Sub or Function in VBA Excel
- 8
VBA Excel If statement with AND/OR function
- 9
Find Function in Excel VBA
- 10
Automate a Excel VBA Function
- 11
Excel VBA hlookup function
- 12
Excel VBA and Group function
- 13
Make VBA DateDif behave and round down like Excel DATEDIFF
- 14
VBA Excel - Variable "Double" as function
- 15
Searching for function usage in Excel VBA
- 16
#NAME? error in Excel for VBA Function
- 17
excel VBA return result of function
- 18
excel VBA - function to parse data
- 19
Excel Vba sumif function array
- 20
Dynamic Function Calls in Excel VBA
- 21
Call excel function in access vba
- 22
#VALUE error with Excel VBA Function
- 23
Excel VBA Like Function not working
- 24
VBA function in Excel ADODB query
- 25
Excel VBA Sentence Case Function
- 26
Excel VBA XLDialogSaveAs function not working
- 27
VBA Excel 2010, isError function
- 28
#NAME? error in Excel for VBA Function
- 29
Excel VBA Right Function Error
Comments