A1 = 1
A2: A1 + 1
A3: A2 + 1
A4: A3 + 1
A5: A4 + 1
A6: A5 + 1
A7: A6 + 1
A8: A7 + 1
A9: A8 + 1
A10: A9 + 1
A11: A10 + 1
A12: A11 + 1
B1 = 2
B2 = 1
B3 = 4
B4 = 6
B5 = 6
B6 = 10
B7 = 10
B8 = 14
B9 = 10
B10 = 13
B11 = 13
B12 = 17
A13 = Mean(A1:A12)
B13 = Mean(B1:B12)
A: (A1, B1)
B: (A2, B2)
C: (A3, B3)
D: (A4, B4)
E: (A5, B5)
F: (A6, B6)
G: (A13, B13)
H: (A8, B8)
I: (A9, B9)
J: (A10, B10)
K: (A11, B11)
L: (A12, B12)
liste1: {A, B, C, D, E, F, G, H, I, J, K, L}
a = 1.2 (slider from -10 to 10, step 0.01)
d: y = a * (x - A13) + B13
C1: (a * (A1 - $A$13) + $B$13 - B1)^(2)
(a (A1 - A13) + B1 - B13)²: (C1 * a * (A1 - A13) + B1 - B13)^(2)
C2: (a * (A2 - $A$13) + $B$13 - B2)^(2)
C3: (a * (A3 - $A$13) + $B$13 - B3)^(2)
C4: (a * (A4 - $A$13) + $B$13 - B4)^(2)
C5: (a * (A5 - $A$13) + $B$13 - B5)^(2)
C6: (a * (A6 - $A$13) + $B$13 - B6)^(2)
C7: (a * (A7 - $A$13) + $B$13 - B7)^(2)
C8: (a * (A8 - $A$13) + $B$13 - B8)^(2)
C9: (a * (A9 - $A$13) + $B$13 - B9)^(2)
C10: (a * (A10 - $A$13) + $B$13 - B10)^(2)
C11: (a * (A11 - $A$13) + $B$13 - B11)^(2)
C12: (a * (A12 - $A$13) + $B$13 - B12)^(2)
C13 = Sum(C1:C12)
b = -8.1 (slider from -15 to 15, step 0.01)
d': y = a * x + b
D1: (a * A1 + b - B1)^(2)
D2: (a * A2 + b - B2)^(2)
D3: (a * A3 + b - B3)^(2)
D4: (a * A4 + b - B4)^(2)
D5: (a * A5 + b - B5)^(2)
D6: (a * A6 + b - B6)^(2)
D7: (a * A7 + b - B7)^(2)
D8: (a * A8 + b - B8)^(2)
D9: (a * A9 + b - B9)^(2)
D10: (a * A10 + b - B10)^(2)
D11: (a * A11 + b - B11)^(2)
D12: (a * A12 + b - B12)^(2)
D13 = Sum(D1:D12)