Scribd
Upload
14 views6 pages

Chapter1 Lecture Examples

Uploaded by

sibonginkosimagudulela
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
14 views6 pages

Chapter1 Lecture Examples

Uploaded by

sibonginkosimagudulela
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Implementation of the Random

Function

= RAND ()
Generates a random real number between 0
and 1

= RANDBETWEEN (bottom; top)


Returns a random number between the
numbers you specify (inclusive).
m
RANDOM NUMBERS
Generate 10 random numbers

=RAND() =RAND()*10 generates


generates numbers =RANDBETWEEN(1,5)
numbers between 0 generates numbers bet
between 0 and 1 and 9 1 and 5
Generate 10 random
numbers between 1 and 5

=RANDBETWEEN(1,5)
generates numbers between
1 and 5 To fill cells:
1. Activate a cell
2. Point curser in corner
of cell
3. When you see a '+',
hold down and drag to fill
remaining numbers
Example 3: Using EXCEL ,select the 6 winning lotto numbers (fro
=RANDBETWEEN(1;49)

Point in corner of cell


A2 till you see a '+',
hold down and drag
to fill remaining 5
numbers
to numbers (from 1- 49)

You might also like