Investigate the random-number generator in a spreadsheet


Question: Investigate the random-number generator in a spreadsheet program on a computer to which you have access. In many spreadsheets, random numbers are generated by a function called RAND or @RAND.

(a) Check the user's manual to see whether it describes how the random numbers are generated.

(b) Write macros to conduct each of the. tests described in this chapter. Generate 100 sets of random numbers, each set containing 100 random numbers. Perform each test on each set of random numbers. Draw conclusions.

Solution Preview :

Prepared by a verified Expert
Mathematics: Investigate the random-number generator in a spreadsheet
Reference No:- TGS02415930

Now Priced at $15 (50% Discount)

Recommended (98%)

Rated (4.3/5)