Record to Spreadsheet from cell in a Spreadsheet

OLDen shared this question 4 years ago

Needs Answer

In Geogebra 5 I can write "RandomBetween(1,6)" in a cell, and afterwards select "Record to Spreadsheet".

And by that Method generate a column of random numbers by "Crtl+R".

How can I do that in Geogebra 6?

Regards

Olav Lyndrup

The same question

Comments (3)

Simona Riva ● 4 years ago

After you record to spreadsheet your number, you need to select the Recompute all objects item in the main menu (or select the row where you entered the command and press the Enter key to generate a new one).

But I guess that you can obtain the same desired result by defining your RandomBetween() number directly in an empty cell of the worksheet, then dragging the cell down.

Reply URL

OLDen ● 4 years ago

Yes, in such a simple case its the same.

In the attached file I have started a simulation where I throw 10 dices and count the number of ones.

Next step is that I would like to make 1000 simulations of this experiment, and thereby create a column of "numbers of numbers". This is possible in a spreadsheet in Geogebra 5 by selecting "Record to Spreadsheet" in the cell with command CountIf(...,...).

Second step is investigate the 1000 "numbers of ones".

Files: Simulate10Dices...

URL

OLDen ● 4 years ago

I have another example that I easily can do in Geogebra 5. But not in Geogebra 6.

Regards

Olav

Files: BootstrappingMe...

URL