Question

1. What are the inputs to Excel’s RAND function?

a.There is one argument to put into the function – the distribution from which to generate random numbers.

b.There are two arguments to put into the function – the number of random values to generate, followed by the number of decimal places.

c.The RAND function has no arguments, just parentheses with nothing in between.

2. What do you actually type into a spreadsheet cell to use the RAND function?

a. =RAND() to generate a single random decimal number

b.=RAND(Uniform) to generate random numbers from a Uniform distribution

c. =RAND(100, 5) to generate 100 random 5-decimal numbers

3.

Does the RANDBETWEEN function generate decimal or integer values?

a.Integer values

b.Decimal values

4.

What output would =RANDBETWEEN(0,1) generate?

a.This would randomly generate decimal numbers between 0 and 1.

b.This would randomly generate 0’s and 1’s with equal probability, like flipping a coin.

Answer 1

1. What are the inputs to Excel’s RAND function?

c.The RAND function has no arguments, just parentheses with nothing in between.

(as rand() generates random numbers between 0 and 1)

2. What do you actually type into a spreadsheet cell to use the RAND function?

a. =RAND() to generate a single random decimal number

3.

Does the RANDBETWEEN function generate decimal or integer values?

a.Integer values

(always gives integer numbered between two specified numbers)

4.

What output would =RANDBETWEEN(0,1) generate?

b.This would randomly generate 0’s and 1’s with equal probability, like flipping a coin.

its generates 0 and 1 only with equal probability