Random Numbers and Spreadsheets
Author: Mike May, S.J.

This looks at random numbers and spreadsheets

Once again we are showing some of the features of the prerelease version of GeoGebra.

Worth noting:
The coordinates of points 1-10 use random numbers and the value a in their definition.  Changing the value of a changes the definition.
L_1 was created by selecting cells from the spreadsheet and choosing make a list.
L_2 is L_1 sorted.
The values of L_2 were put back into the spreadsheet so that the points have names and labels.

C or E

a = 2 (slider from 1 to 2, step 1)
A2: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
A3: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
A4: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
A5: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
A6: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
A7: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
A8: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
A9: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
A10: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
B1: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
B2: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
B3: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
B4: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
B5: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
B6: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
B7: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
B8: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
B9: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
B10: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
A1: random() 10.00000000000000 - 5.000000000000000 + a 0.000000000000000
C1: (A1, B1)
C2: (A2, B2)
C3: (A3, B3)
C4: (A4, B4)
C5: (A5, B5)
C6: (A6, B6)
C7: (A7, B7)
C8: (A8, B8)
C9: (A9, B9)
C10: (A10, B10)
L_1: {C1, C2, C3, C4, C5, C6, C7, C8, C9, C10}
matrix_1: {{A1, A2, A3, A4, A5, A6, A7, A8, A9, A10}, {B1, B2, B3, B4, B5, B6, B7, B8, B9, B10}}
Line1 = FitLineY(L_1)
B12: random() 2.000000000000000 + 6.000000000000000
A12: random() 2.000000000000000 - 1.000000000000000
C12: (A12, B12)
B13: random() 2.000000000000000 + 6.000000000000000
B14: random() 2.000000000000000 + 6.000000000000000
B15: random() 2.000000000000000 + 6.000000000000000
B16: random() 2.000000000000000 + 6.000000000000000
B17: random() 2.000000000000000 + 6.000000000000000
B18: random() 2.000000000000000 + 6.000000000000000
B19: random() 2.000000000000000 + 6.000000000000000
B20: random() 2.000000000000000 + 6.000000000000000
B21: random() 2.000000000000000 + 6.000000000000000
A13: random() 2.000000000000000 - 1.000000000000000
C13: (A13, B13)
A14: random() 2.000000000000000 - 1.000000000000000
C14: (A14, B14)
A15: random() 2.000000000000000 - 1.000000000000000
C15: (A15, B15)
A16: random() 2.000000000000000 - 1.000000000000000
C16: (A16, B16)
A17: random() 2.000000000000000 - 1.000000000000000
C17: (A17, B17)
A18: random() 2.000000000000000 - 1.000000000000000
C18: (A18, B18)
A19: random() 2.000000000000000 - 1.000000000000000
C19: (A19, B19)
A20: random() 2.000000000000000 - 1.000000000000000
C20: (A20, B20)
A21: random() 2.000000000000000 - 1.000000000000000
C21: (A21, B21)
b = 1.3 (slider from -5 to 5, step 0.1)
L_2 = Sort(L_1)
D1 = 1
D2 = 2
D3: 2.000000000000000 D2 - D1
D4: 2.000000000000000 D3 - D2
D5: 2.000000000000000 D4 - D3
D6: 2.000000000000000 D5 - D4
D7: 2.000000000000000 D6 - D5
D8: 2.000000000000000 D7 - D6
D9: 2.000000000000000 D8 - D7
D10: 2.000000000000000 D9 - D8
E1 = Element(L_2, D1)
E2 = Element(L_2, D2)
E3 = Element(L_2, D3)
E4 = Element(L_2, D4)
E5 = Element(L_2, D5)
E6 = Element(L_2, D6)
E7 = Element(L_2, D7)
E8 = Element(L_2, D8)
E9 = Element(L_2, D9)
E10 = Element(L_2, D10)
c = true
Poly3 = FitPoly(L_2, 3.000000000000000)
Poly4 = FitPoly(L_2, 4.000000000000000)