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 importati

dev.st. σ_a

dev.st. σ_b

(y_i - a x_i - b)^2

somma((y_i - a x_i -b)^2)

dev.st. σ_y

coeff. di correlazione

media(x_i)

media(y_i)

(x_i-media(x_i))*(y_i-media(y_i))

(y_i-media(y_i))^2

(x_i-media(x_i))^2

somma((x_i-media(x_i))*(y_i-media(y_i)))

somma((y_i-media(y_i))^2)

somma((x_i-media(x_i))^2)

A2: 1
B2: 7.252250217453121
A3: 2
B3: 2.0316978377080464
A4: 3
B4: 5.597237516856314
A5: 4
B5: 15.736490814102686
A6: 5
B6: 9.016517575419638
A7: 6
B7: 6.630190743361985
A8: 7
B8: 17.999736206441135
A9: 8
B9: 15.324329362713746
A10: 9
B10: 10.519412687769673
A11: 10
B11: 19.0070235584207
A12: 11
B12: 19.79188766579211
A13: 12
B13: 24.480258223550678
A14: 13
B14: 21.004657460591616
A15: 14
B15: 17.00206493837998
A16: 15
B16: 19.764898037485636
A17: 16
B17: 25.37372071961142
A18: 17
B18: 30.370540311866066
A19: 18
B19: 21.389130716436355
A20: 19
B20: 31.129504611656536
A21: 20
B21: 31.333053506304296
A22: 21
B22: 24.83938917740626
A23: 22
B23: 24.263137223262934
A24: 23
B24: 23.84590953487552
A25: 24
B25: 30.571620709826973
A26: 25
B26: 29.552264356466672
A27: 26
B27: 31.71771738566874
A28: 27
B28: 41.37802236490551
A29: 28
B29: 32.66924550837929
A30: 29
B30: 39.19994055488573
A31: 30
B31: 42.31737589718477
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)
H2 = Sum(A2:A31)
H3 = Sum(B2:B31)
H4 = Sum(D2:D31)
H5 = Sum(E2:E31)
H1 = Length(A2:A31)
K3: (H1 * H4) - (H2 * H3)
K4: (H1 * H5) - H2^(2)
K5: (H3 * H5) - (H4 * H2)
H7: K3 / K4
H8: K5 / K4
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)}
f: y = (H7 * x) + H8
testo2: "" + f + ""
g = FitLineY(l1)
h = FitPoly(l1, 1)
F2: (B2 - ($H$7 * A2) - $H$8)^(2)
F3: (B3 - ($H$7 * A3) - $H$8)^(2)
F4: (B4 - ($H$7 * A4) - $H$8)^(2)
F5: (B5 - ($H$7 * A5) - $H$8)^(2)
F6: (B6 - ($H$7 * A6) - $H$8)^(2)
F7: (B7 - ($H$7 * A7) - $H$8)^(2)
F8: (B8 - ($H$7 * A8) - $H$8)^(2)
F9: (B9 - ($H$7 * A9) - $H$8)^(2)
F10: (B10 - ($H$7 * A10) - $H$8)^(2)
F11: (B11 - ($H$7 * A11) - $H$8)^(2)
F12: (B12 - ($H$7 * A12) - $H$8)^(2)
F13: (B13 - ($H$7 * A13) - $H$8)^(2)
F14: (B14 - ($H$7 * A14) - $H$8)^(2)
F15: (B15 - ($H$7 * A15) - $H$8)^(2)
F16: (B16 - ($H$7 * A16) - $H$8)^(2)
F17: (B17 - ($H$7 * A17) - $H$8)^(2)
F18: (B18 - ($H$7 * A18) - $H$8)^(2)
F19: (B19 - ($H$7 * A19) - $H$8)^(2)
F20: (B20 - ($H$7 * A20) - $H$8)^(2)
F21: (B21 - ($H$7 * A21) - $H$8)^(2)
F22: (B22 - ($H$7 * A22) - $H$8)^(2)
F23: (B23 - ($H$7 * A23) - $H$8)^(2)
F24: (B24 - ($H$7 * A24) - $H$8)^(2)
F25: (B25 - ($H$7 * A25) - $H$8)^(2)
F26: (B26 - ($H$7 * A26) - $H$8)^(2)
F27: (B27 - ($H$7 * A27) - $H$8)^(2)
F28: (B28 - ($H$7 * A28) - $H$8)^(2)
F29: (B29 - ($H$7 * A29) - $H$8)^(2)
F30: (B30 - ($H$7 * A30) - $H$8)^(2)
M1: H2 / H1
M2: H3 / H1
O2: ((A2 - $M$1) * (B2 - $M$2))
P2: (B2 - $M$2)^(2)
P3: (B3 - $M$2)^(2)
P4: (B4 - $M$2)^(2)
P5: (B5 - $M$2)^(2)
P6: (B6 - $M$2)^(2)
P7: (B7 - $M$2)^(2)
P8: (B8 - $M$2)^(2)
P9: (B9 - $M$2)^(2)
P10: (B10 - $M$2)^(2)
P11: (B11 - $M$2)^(2)
P12: (B12 - $M$2)^(2)
P13: (B13 - $M$2)^(2)
P14: (B14 - $M$2)^(2)
P15: (B15 - $M$2)^(2)
P16: (B16 - $M$2)^(2)
P17: (B17 - $M$2)^(2)
P18: (B18 - $M$2)^(2)
P19: (B19 - $M$2)^(2)
P20: (B20 - $M$2)^(2)
P21: (B21 - $M$2)^(2)
P22: (B22 - $M$2)^(2)
P23: (B23 - $M$2)^(2)
P24: (B24 - $M$2)^(2)
P25: (B25 - $M$2)^(2)
P26: (B26 - $M$2)^(2)
P27: (B27 - $M$2)^(2)
P28: (B28 - $M$2)^(2)
P29: (B29 - $M$2)^(2)
P30: (B30 - $M$2)^(2)
P31: (B31 - $M$2)^(2)
P33 = Sum(P2:P31)
N2: (A2 - $M$1)^(2)
N3: (A3 - $M$1)^(2)
N4: (A4 - $M$1)^(2)
N5: (A5 - $M$1)^(2)
N6: (A6 - $M$1)^(2)
N7: (A7 - $M$1)^(2)
N8: (A8 - $M$1)^(2)
N9: (A9 - $M$1)^(2)
N10: (A10 - $M$1)^(2)
N11: (A11 - $M$1)^(2)
N12: (A12 - $M$1)^(2)
N13: (A13 - $M$1)^(2)
N14: (A14 - $M$1)^(2)
N15: (A15 - $M$1)^(2)
N16: (A16 - $M$1)^(2)
N17: (A17 - $M$1)^(2)
N18: (A18 - $M$1)^(2)
N19: (A19 - $M$1)^(2)
N20: (A20 - $M$1)^(2)
N21: (A21 - $M$1)^(2)
N22: (A22 - $M$1)^(2)
N23: (A23 - $M$1)^(2)
N24: (A24 - $M$1)^(2)
N25: (A25 - $M$1)^(2)
N26: (A26 - $M$1)^(2)
N27: (A27 - $M$1)^(2)
N28: (A28 - $M$1)^(2)
N29: (A29 - $M$1)^(2)
N30: (A30 - $M$1)^(2)
N31: (A31 - $M$1)^(2)
N33 = Sum(N2:N31)
O33 = Sum(O2:O31)
H13: O33 / sqrt((N33 * P33))
O3: ((A3 - $M$1) * (B3 - $M$2))
O4: ((A4 - $M$1) * (B4 - $M$2))
O5: ((A5 - $M$1) * (B5 - $M$2))
O6: ((A6 - $M$1) * (B6 - $M$2))
O7: ((A7 - $M$1) * (B7 - $M$2))
O8: ((A8 - $M$1) * (B8 - $M$2))
O9: ((A9 - $M$1) * (B9 - $M$2))
O10: ((A10 - $M$1) * (B10 - $M$2))
O11: ((A11 - $M$1) * (B11 - $M$2))
O12: ((A12 - $M$1) * (B12 - $M$2))
O13: ((A13 - $M$1) * (B13 - $M$2))
O14: ((A14 - $M$1) * (B14 - $M$2))
O15: ((A15 - $M$1) * (B15 - $M$2))
O16: ((A16 - $M$1) * (B16 - $M$2))
O17: ((A17 - $M$1) * (B17 - $M$2))
O18: ((A18 - $M$1) * (B18 - $M$2))
O19: ((A19 - $M$1) * (B19 - $M$2))
O20: ((A20 - $M$1) * (B20 - $M$2))
O21: ((A21 - $M$1) * (B21 - $M$2))
O22: ((A22 - $M$1) * (B22 - $M$2))
O23: ((A23 - $M$1) * (B23 - $M$2))
O24: ((A24 - $M$1) * (B24 - $M$2))
O25: ((A25 - $M$1) * (B25 - $M$2))
O26: ((A26 - $M$1) * (B26 - $M$2))
O27: ((A27 - $M$1) * (B27 - $M$2))
O28: ((A28 - $M$1) * (B28 - $M$2))
O29: ((A29 - $M$1) * (B29 - $M$2))
O30: ((A30 - $M$1) * (B30 - $M$2))
O31: ((A31 - $M$1) * (B31 - $M$2))
F31: (B31 - ($H$7 * A31) - $H$8)^(2)
a = Sum(F2:F31)
K10 = Sum(F2:F31)
K11: sqrt(K10 / (H1 - 2))