You can test Excels algorithm for selecting random integers with a simple experiment. Enter =RANDBETWEEN(1,2) into cell

Question:

You can test Excel’s algorithm for selecting random integers with a simple experiment. Enter =RANDBETWEEN(1,2) into cell A1 and then copy it to cells A1:E20. This creates a data block of 100 cells containing either a one or a two. In cell G1 type =COUNTIF(A1:E20,“=1”) and in cell G2 type =COUNTIF(A1:E20,“=2”). Highlight cells G1 and G2 and create a column chart. Click on the vertical axis scale, and set the lower limit to 0 and upper limit to 100. Then hold down the F9 key and observe the chart. Are you convinced that, on average, you are getting about 50 ones and 50 twos? Ambitious Students: Generalize this experiment to integers 1 through 5.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: