grandezza X

grandezza Y

x_i*y_i

(x_i)^2

n

somma(x_i)

somma(y_i)

somma(x_i*y_i)

somma(x_i^2)

a (pendenza)

b (intercetta)

numeratore1

denominatore Δ

numeratore2

Regressione lineare con valori casuali

A2: 1
A3: A2 + $A$2
A4: A3 + $A$2
A5: A4 + $A$2
A6: A5 + $A$2
A7: A6 + $A$2
A8: A7 + $A$2
A9: A8 + $A$2
A10: A9 + $A$2
A11: A10 + $A$2
A12: A11 + $A$2
A13: A12 + $A$2
A14: A13 + $A$2
A15: A14 + $A$2
A16: A15 + $A$2
A17: A16 + $A$2
A18: A17 + $A$2
A19: A18 + $A$2
A20: A19 + $A$2
A21: A20 + $A$2
A22: A21 + $A$2
A23: A22 + $A$2
A24: A23 + $A$2
A25: A24 + $A$2
A26: A25 + $A$2
A27: A26 + $A$2
A28: A27 + $A$2
A29: A28 + $A$2
A30: A29 + $A$2
A31: A30 + $A$2
B2: ((2 + RandomUniform[-0.1, 0.1]) * A2) + 10 + RandomUniform[-1, 1]
B3: ((2 + RandomUniform[-0.1, 0.1]) * A3) + 10 + RandomUniform[-1, 1]
B4: ((2 + RandomUniform[-0.1, 0.1]) * A4) + 10 + RandomUniform[-1, 1]
B5: ((2 + RandomUniform[-0.1, 0.1]) * A5) + 10 + RandomUniform[-1, 1]
B6: ((2 + RandomUniform[-0.1, 0.1]) * A6) + 10 + RandomUniform[-1, 1]
B7: ((2 + RandomUniform[-0.1, 0.1]) * A7) + 10 + RandomUniform[-1, 1]
B8: ((2 + RandomUniform[-0.1, 0.1]) * A8) + 10 + RandomUniform[-1, 1]
B9: ((2 + RandomUniform[-0.1, 0.1]) * A9) + 10 + RandomUniform[-1, 1]
B10: ((2 + RandomUniform[-0.1, 0.1]) * A10) + 10 + RandomUniform[-1, 1]
B11: ((2 + RandomUniform[-0.1, 0.1]) * A11) + 10 + RandomUniform[-1, 1]
B12: ((2 + RandomUniform[-0.1, 0.1]) * A12) + 10 + RandomUniform[-1, 1]
B13: ((2 + RandomUniform[-0.1, 0.1]) * A13) + 10 + RandomUniform[-1, 1]
B14: ((2 + RandomUniform[-0.1, 0.1]) * A14) + 10 + RandomUniform[-1, 1]
B15: ((2 + RandomUniform[-0.1, 0.1]) * A15) + 10 + RandomUniform[-1, 1]
B16: ((2 + RandomUniform[-0.1, 0.1]) * A16) + 10 + RandomUniform[-1, 1]
B17: ((2 + RandomUniform[-0.1, 0.1]) * A17) + 10 + RandomUniform[-1, 1]
B18: ((2 + RandomUniform[-0.1, 0.1]) * A18) + 10 + RandomUniform[-1, 1]
B19: ((2 + RandomUniform[-0.1, 0.1]) * A19) + 10 + RandomUniform[-1, 1]
B20: ((2 + RandomUniform[-0.1, 0.1]) * A20) + 10 + RandomUniform[-1, 1]
B21: ((2 + RandomUniform[-0.1, 0.1]) * A21) + 10 + RandomUniform[-1, 1]
B22: ((2 + RandomUniform[-0.1, 0.1]) * A22) + 10 + RandomUniform[-1, 1]
B23: ((2 + RandomUniform[-0.1, 0.1]) * A23) + 10 + RandomUniform[-1, 1]
B24: ((2 + RandomUniform[-0.1, 0.1]) * A24) + 10 + RandomUniform[-1, 1]
B25: ((2 + RandomUniform[-0.1, 0.1]) * A25) + 10 + RandomUniform[-1, 1]
B26: ((2 + RandomUniform[-0.1, 0.1]) * A26) + 10 + RandomUniform[-1, 1]
B27: ((2 + RandomUniform[-0.1, 0.1]) * A27) + 10 + RandomUniform[-1, 1]
B28: ((2 + RandomUniform[-0.1, 0.1]) * A28) + 10 + RandomUniform[-1, 1]
B29: ((2 + RandomUniform[-0.1, 0.1]) * A29) + 10 + RandomUniform[-1, 1]
B30: ((2 + RandomUniform[-0.1, 0.1]) * A30) + 10 + RandomUniform[-1, 1]
B31: ((2 + RandomUniform[-0.1, 0.1]) * A31) + 10 + RandomUniform[-1, 1]
l1: {(A2, B2), (A3, B3), (A4, B4), (A5, B5), (A6, B6), (A7, B7), (A8, B8), (A9, B9), (A10, B10), (A11, B11), (A12, B12), (A13, B13), (A14, B14), (A15, B15), (A16, B16), (A17, B17), (A18, B18), (A19, B19), (A20, B20), (A21, B21), (A22, B22), (A23, B23), (A24, B24), (A25, B25), (A26, B26), (A27, B27), (A28, B28), (A29, B29), (A30, B30), (A31, B31)}
D2: (A2 * B2)
E2: A2^(2)
D3: (A3 * B3)
E3: A3^(2)
D4: (A4 * B4)
E4: A4^(2)
D5: (A5 * B5)
E5: A5^(2)
D6: (A6 * B6)
E6: A6^(2)
D7: (A7 * B7)
E7: A7^(2)
D8: (A8 * B8)
E8: A8^(2)
D9: (A9 * B9)
E9: A9^(2)
D10: (A10 * B10)
E10: A10^(2)
D11: (A11 * B11)
E11: A11^(2)
D12: (A12 * B12)
E12: A12^(2)
D13: (A13 * B13)
E13: A13^(2)
D14: (A14 * B14)
E14: A14^(2)
D15: (A15 * B15)
E15: A15^(2)
D16: (A16 * B16)
E16: A16^(2)
D17: (A17 * B17)
E17: A17^(2)
D18: (A18 * B18)
E18: A18^(2)
D19: (A19 * B19)
E19: A19^(2)
D20: (A20 * B20)
E20: A20^(2)
D21: (A21 * B21)
E21: A21^(2)
D22: (A22 * B22)
E22: A22^(2)
D23: (A23 * B23)
E23: A23^(2)
D24: (A24 * B24)
E24: A24^(2)
D25: (A25 * B25)
E25: A25^(2)
D26: (A26 * B26)
E26: A26^(2)
D27: (A27 * B27)
E27: A27^(2)
D28: (A28 * B28)
E28: A28^(2)
D29: (A29 * B29)
E29: A29^(2)
D30: (A30 * B30)
E30: A30^(2)
D31: (A31 * B31)
E31: A31^(2)
H3 = Sum(B2:B31)
H4 = Sum(D2:D31)
H5 = Sum(E2:E31)
H1 = Length(A2:A31)
H2 = Sum(A2:A31)
K3: (H1 * H4) - (H2 * H3)
K4: (H1 * H5) - H2^(2)
H7: K3 / K4
K5: (H3 * H5) - (H4 * H2)
H8: K5 / K4
f: y = (H7 * x) + H8
testo2: "" + f + ""
g = FitLineY(l1)
h = FitPoly(l1, 1)