Spreadsheet with Statistics
Author: Russell Blyth

We demonstrated some features of the Spreadsheet panel and its statistics tools.

D1 = 2
A1 = 1
A2 = 2
A3: 2 * A2 - A1
A4: 2 * A3 - A2
A5: 2 * A4 - A3
A6: 2 * A5 - A4
A7: 2 * A6 - A5
A8: 2 * A7 - A6
A9: 2 * A8 - A7
A10: 2 * A9 - A8
A11: 2 * A10 - A9
A12: 2 * A11 - A10
A13: 2 * A12 - A11
A14: 2 * A13 - A12
A15: 2 * A14 - A13
A16: 2 * A15 - A14
A17: 2 * A16 - A15
A18: 2 * A17 - A16
A19: 2 * A18 - A17
A20: 2 * A19 - A18
A21: 2 * A20 - A19
A22: 2 * A21 - A20
A23: 2 * A22 - A21
A24: 2 * A23 - A22
A25: 2 * A24 - A23
A26: 2 * A25 - A24
A27: 2 * A26 - A25
A28: 2 * A27 - A26
A29: 2 * A28 - A27
A30: 2 * A29 - A28
B2: A2 + Random[0, 200] / 100 + 0 * D$1
B3: A3 + Random[0, 200] / 100 + 0 * D$1
B4: A4 + Random[0, 200] / 100 + 0 * D$1
B5: A5 + Random[0, 200] / 100 + 0 * D$1
B6: A6 + Random[0, 200] / 100 + 0 * D$1
B7: A7 + Random[0, 200] / 100 + 0 * D$1
B8: A8 + Random[0, 200] / 100 + 0 * D$1
B9: A9 + Random[0, 200] / 100 + 0 * D$1
B10: A10 + Random[0, 200] / 100 + 0 * D$1
B11: A11 + Random[0, 200] / 100 + 0 * D$1
B12: A12 + Random[0, 200] / 100 + 0 * D$1
B13: A13 + Random[0, 200] / 100 + 0 * D$1
B14: A14 + Random[0, 200] / 100 + 0 * D$1
B15: A15 + Random[0, 200] / 100 + 0 * D$1
B16: A16 + Random[0, 200] / 100 + 0 * D$1
B17: A17 + Random[0, 200] / 100 + 0 * D$1
B18: A18 + Random[0, 200] / 100 + 0 * D$1
B19: A19 + Random[0, 200] / 100 + 0 * D$1
B20: A20 + Random[0, 200] / 100 + 0 * D$1
B21: A21 + Random[0, 200] / 100 + 0 * D$1
B22: A22 + Random[0, 200] / 100 + 0 * D$1
B23: A23 + Random[0, 200] / 100 + 0 * D$1
B24: A24 + Random[0, 200] / 100 + 0 * D$1
B25: A25 + Random[0, 200] / 100 + 0 * D$1
B26: A26 + Random[0, 200] / 100 + 0 * D$1
B27: A27 + Random[0, 200] / 100 + 0 * D$1
B28: A28 + Random[0, 200] / 100 + 0 * D$1
B29: A29 + Random[0, 200] / 100 + 0 * D$1
B30: A30 + Random[0, 200] / 100 + 0 * D$1
B1: A1 + Random[0, 200] / 100 + 0 * D$1
C1: A1 + 4 + RandomNormal[0, 2]
C2: A2 + 4 + RandomNormal[0, 2]
C3: A3 + 4 + RandomNormal[0, 2]
C4: A4 + 4 + RandomNormal[0, 2]
C5: A5 + 4 + RandomNormal[0, 2]
C6: A6 + 4 + RandomNormal[0, 2]
C7: A7 + 4 + RandomNormal[0, 2]
C8: A8 + 4 + RandomNormal[0, 2]
C9: A9 + 4 + RandomNormal[0, 2]
C10: A10 + 4 + RandomNormal[0, 2]
C11: A11 + 4 + RandomNormal[0, 2]
C12: A12 + 4 + RandomNormal[0, 2]
C13: A13 + 4 + RandomNormal[0, 2]
C14: A14 + 4 + RandomNormal[0, 2]
C15: A15 + 4 + RandomNormal[0, 2]
C16: A16 + 4 + RandomNormal[0, 2]
C17: A17 + 4 + RandomNormal[0, 2]
C18: A18 + 4 + RandomNormal[0, 2]
C19: A19 + 4 + RandomNormal[0, 2]
C20: A20 + 4 + RandomNormal[0, 2]
C21: A21 + 4 + RandomNormal[0, 2]
C22: A22 + 4 + RandomNormal[0, 2]
C23: A23 + 4 + RandomNormal[0, 2]
C24: A24 + 4 + RandomNormal[0, 2]
C25: A25 + 4 + RandomNormal[0, 2]
C26: A26 + 4 + RandomNormal[0, 2]
C27: A27 + 4 + RandomNormal[0, 2]
C28: A28 + 4 + RandomNormal[0, 2]
C29: A29 + 4 + RandomNormal[0, 2]
C30: A30 + 4 + RandomNormal[0, 2]
list1: {B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, B22, B23, B24, B25, B26, B27, B28, B29, B30, C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11, C12, C13, C14, C15, C16, C17, C18, C19, C20, C21, C22, C23, C24, C25, C26, C27, C28, C29, C30}
list2: {(B1, C1), (B2, C2), (B3, C3), (B4, C4), (B5, C5), (B6, C6), (B7, C7), (B8, C8), (B9, C9), (B10, C10), (B11, C11), (B12, C12), (B13, C13), (B14, C14), (B15, C15), (B16, C16), (B17, C17), (B18, C18), (B19, C19), (B20, C20), (B21, C21), (B22, C22), (B23, C23), (B24, C24), (B25, C25), (B26, C26), (B27, C27), (B28, C28), (B29, C29), (B30, C30)}