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
Essential Statistics In Business And Economics
ISBN: 9781260239508
3rd Edition
Authors: David Doane, Lori Seward
Question Posted: