You can test Excel’s algorithm for selecting random integers with a simple experiment. Ent...

You can test Excel’s algorithm for selecting random integers with a simple experiment. Enter =RANDEBETWEEN(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 use excel’s chart wizard to create a bar chart. Click on the vertical axis scale and set the lower limit to 0 and upper limit to 100. You will see something like the example show below. 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? Ambitions Students: Generalize this to intergers1 through 5.