Random Number Generator in Microsoft Excel

Learn how to generate random numbers and integers in Microsoft Excel. http://www.influxity.com

---

Closed Caption:

hi well to my video today we'll talk
about
had to generated numbers in Mike's of
itself so start with
let's generate random number between 0&1
to do this you can use a rain function
sense to equals
grand in this is gonna give me
Iranian number between 01 its uniformly
distributed
of now if I copy paste this number
commits to things one is he
number in the original cell changed and
that is because
the rate function any kind there's a new
number valujet's
input into anything in the spreadsheet
everything is changing the spreadsheet
that range from for generating new
number
working no in in the second game is
that the the number it was in this so
that we copied is not the same number it
was pasted in this because we didn't
copy that number we actually happy the
value in this cell which is there and
function
so we pasted bP said the rand function
if you all the cells city to the cells
generator in your number by itself
alright
now let's say they want to generate a
random number between 0 and some other
number
let's just say in to keep orient
in whatever number 12 12
go up to it's multiplied by that so this
case will do
rand times 10 finance because
as since ranges between 0 and one is
really gets closer
20 this value to multiply by zero
will be 0 it is renewed Scotia Warren on
it'll be
evaluate which would push to one time
state which is closer and closer to 10
equals 10 20 40
so as we can see get every new never
between
through in 10 alright
and then let's say they would %uh
don't wanna start is your local or start
something else this is fun
to just
add that number to hear civil war
started five the words to plus five
in this will give us a random between
5&6 I
K let's say we were no longer interval
sit between five and ten that's fine too
giddy was renamed them
plus five turn sleepy
as five re:
and then what it do is at
downloaded fine the value that is a
difference between
the two numbers and so if you take the
upper bound which is he its attract
the lower bowel which is five that is in
a remote
I'm so in this case all the five yet
can remember between 5 yen in
K and get the reasoning behind this is
it
as rate it's closer to zero this rain
times 5 goes to 0 °c just had the plus
five
so starts at five it is raining it's
close to one have three times five which
is close to five
plus 5 again which equals 10 civil
that is how you do that and there were
things I'll go over
is headed hey did you random
integers so this case we've been getting
doubles flutes
Dom numbers with decimals but in certain
situations with my wife just a whole
numbers
edgers so this case there's a function
called re and
between he takes two trainers
the lower value in the a fair value so
if I Q one comic TN
so gimme rated integer between the 20
he K you can see
called I can do this for any
never values psyche equals re and
between City
to the mean 20 this would be me reading
teacher between
team in 20 sorry