Spreadsheet: 37935d1236042264-linear-regression-scratch
Sheet: Sheet1

Frame | x | y | angle(degree) | Cumulative angle | [NAME]) | New X | New Y | New x^2 | New Y | time
1 | 8.97 | 6.99 | 102.995 | 103 | 1.796777777777778 | 1.36 | 6.69 | -1.849600000000001 | -6.69 | 0 | 1.796777777777778
1.5 | 8.99 | 6.66 | 184.185 | 184 | 3.209777777777778 | 1.38 | 6.36 | -1.9044 | -6.36 | 0.02 | 3.209777777777778
2 | 8.98 | 6.26 | 272 | 272 | 4.744888888888889 | 1.37 | 5.96 | -1.8769 | -5.96 | 0.04 | 4.744888888888889
2.5 | 8.98 | 5.35 | 4.574 | 365 | 6.367222222222223 | 1.37 | 5.05 | -1.8769 | -5.05 | 0.06 | 6.367222222222223
3 | 8.8 | 4.41 | 90 | 450 | 7.85 | 1.19 | 4.11 | -1.416100000000001 | -4.11 | 0.08 | 7.85
3.5 | 8.59 | 4.4 | 153.4 | 513 | 8.949000000000002 | 0.9799999999999995 | 4.100000000000001 | -0.9603999999999991 | -4.100000000000001 | 0.1 | 8.949000000000002
4 | 8.61 | 4.14 | 245.556 | 606 | 10.57133333333333 | 0.9999999999999991 | 3.84 | -0.9999999999999982 | -3.84 | 0.12 | 10.57133333333333
4.5 | 8.74 | 3.57 | 324.834 | 685 | 11.94944444444445 | 1.13 | 3.27 | -1.2769 | -3.27 | 0.14 | 11.94944444444445
5 | 8.53 | 3.06 | 55.814 | 776 | 13.53688888888889 | 0.919999999999999 | 2.76 | -0.8463999999999983 | -2.76 | 0.16 | 13.53688888888889
5.5 | 8.41 | 2.6 | 113 | 833 | 14.53122222222222 | 0.7999999999999998 | 2.3 | -0.6399999999999997 | -2.3 | 0.18 | 14.53122222222222
6 | 8.23 | 2.44 | 194.036 | 914 | 15.94422222222222 | 0.6200000000000001 | 2.14 | -0.3844000000000001 | -2.14 | 0.2 | 15.94422222222222
6.5 | 8.31 | 2.53 | 270 | 990 | 17.27 | 0.7000000000000002 | 2.23 | -0.4900000000000003 | -2.23 | 0.22 | 17.27
7 | 8.37 | 1.84 | 335.9 | 1056 | 18.42133333333333 | 0.7599999999999989 | 1.54 | -0.5775999999999983 | -1.54 | 0.24 | 18.42133333333333
7.5 | 8.29 | 1.45 | 44.119 | 1124 | 19.60755555555556 | 0.6799999999999988 | 1.15 | -0.4623999999999984 | -1.15 | 0.26 | 19.60755555555556
8 | 8.1 | 1.17 | 102.633 | 1183 | 20.63677777777778 | 0.4899999999999993 | 0.8699999999999999 | -0.2400999999999993 | -0.8699999999999999 | 0.28 | 20.63677777777778
8.5 | 8.1 | 1.11 | 178.877 | 1259 | 21.96255555555556 | 0.4899999999999993 | 0.81 | -0.2400999999999993 | -0.81 | 0.3 | 21.96255555555556
9 | 7.9 | 1.09 | 249 | 1329 | 23.18366666666667 | 0.29 | 0.79 | -0.08410000000000002 | -0.79 | 0.32 | 23.18366666666667
9.5 | 8 | 0.98 | 287.745 | 1368 | 23.864 | 0.3899999999999997 | 0.6799999999999999 | -0.1520999999999998 | -0.6799999999999999 | 0.34 | 23.864
10 | 8.16 | 0.73 | 349 | 1429 | 24.92811111111111 | 0.5499999999999998 | 0.43 | -0.3024999999999998 | -0.43 | 0.36 | 24.92811111111111
10.5 | 7.83 | 0.41 | 62.6 | 1503 | 26.219 | 0.2199999999999998 | 0.11 | -0.04839999999999989 | -0.11 | 0.3800000000000001 | 26.219
11 | 7.61 | 0.3 | 112.891 | 1553 | 27.09122222222222 | 0 | 0 | 0 |  | 0.4000000000000001 | 27.09122222222222
11.5 | 7.54 | 0.48 | 158.199 | 1598 | 27.87622222222222 | -0.07000000000000028 | 0.18 | 0.00490000000000004 | 0.18 | 0.4200000000000001 | 27.87622222222222
12 | 7.59 | 0.043 | 228.945 | 1669 | 29.11477777777778 | -0.02000000000000046 | -0.257 | 0.0004000000000000185 | -0.257 | 0.4400000000000001 | 29.11477777777778
12.5 | 7.52 | 0.66 | 278 | 1718 | 29.96955555555556 | -0.09000000000000075 | 0.36 | 0.008100000000000135 | 0.36 | 0.4600000000000001 | 29.96955555555556
13 | 7.53 | 0.56 | 337.38 | 1777 | 30.99877777777778 | -0.08000000000000007 | 0.2600000000000001 | 0.006400000000000012 | 0.2600000000000001 | 0.4800000000000001 | 30.99877777777778
13.5 | 7.7 | 0.35 | 29.3 | 1829 | 31.90588888888889 | 0.08999999999999986 | 0.04999999999999999 | 0.008099999999999975 | 0.04999999999999999 | 0.5000000000000001 | 31.90588888888889
14 | 7.3 | 0.44 | 84.1 | 1884 | 32.86533333333333 | -0.3100000000000005 | 0.14 | 0.09610000000000031 | 0.14 | 0.5200000000000001 | 32.86533333333333
14.5 | 7.12 | 0.68 | 133.315 | 1933 | 33.72011111111111 | -0.4900000000000002 | 0.3800000000000001 | 0.2401000000000002 | 0.3800000000000001 | 0.5400000000000001 | 33.72011111111111
15 | 7.02 | 0.98 | 200.556 | 2001 | 34.90633333333334 | -0.5900000000000007 | 0.6799999999999999 | 0.3481000000000009 | 0.6799999999999999 | 0.5600000000000002 | 34.90633333333334
15.5 | 7.12 | 1.07 | 240.255 | 2040 | 35.58666666666667 | -0.4900000000000002 | 0.77 | 0.2401000000000002 | 0.77 | 0.5800000000000002 | 35.58666666666667
16 | 7.09 | 1.47 | 281 | 2081 | 36.30188888888889 | -0.5200000000000005 | 1.17 | 0.2704000000000005 | 1.17 | 0.6000000000000002 | 36.30188888888889
16.5 | 7.08 | 1.57 | 326.89 | 2127 | 37.10433333333334 | -0.5300000000000002 | 1.27 | 0.2809000000000003 | 1.27 | 0.6200000000000002 | 37.10433333333334
17 | 7 | 1.68 | 30.6 | 2191 | 38.22077777777778 | -0.6100000000000003 | 1.38 | 0.3721000000000004 | 1.38 | 0.6400000000000002 | 38.22077777777778
17.5 | 6.86 | 1.86 | 79.5 | 2240 | 39.07555555555556 | -0.75 | 1.56 | 0.5625 | 1.56 | 0.6600000000000003 | 39.07555555555556
18 | 6.72 | 2.11 | 108.435 | 2268 | 39.564 | -0.8900000000000006 | 1.81 | 0.792100000000001 | 1.81 | 0.6800000000000003 | 39.564
18.5 | 6.54 | 2.46 | 143.531 | 2304 | 40.192 | -1.07 | 2.16 | 1.144900000000001 | 2.16 | 0.7000000000000003 | 40.192
19 | 6.61 | 2.79 | 191.976 | 2352 | 41.02933333333333 | -1 | 2.49 | 1 | 2.49 | 0.7200000000000003 | 41.02933333333333
19.5 | 6.42 | 3.2 | 228 | 2388 | 41.65733333333333 | -1.19 | 2.9 | 1.416100000000001 | 2.9 | 0.7400000000000003 | 41.65733333333333
20 | 6.45 | 3.43 | 235.008 | 2395 | 41.77944444444444 | -1.16 | 3.13 | 1.3456 | 3.13 | 0.7600000000000003 | 41.77944444444444
20.5 | 6.51 | 3.68 | 278.1 | 2438 | 42.52955555555556 | -1.100000000000001 | 3.38 | 1.210000000000001 | 3.38 | 0.7800000000000004 | 42.52955555555556
21 | 6.59 | 4 | 283 | 2443 | 42.61677777777778 | -1.02 | 3.7 | 1.040400000000001 | 3.7 | 0.8000000000000004 | 42.61677777777778
21.5 | 6.64 | 4.26 | 309.036 | 2469 | 43.07033333333333 | -0.9700000000000006 | 3.96 | 0.9409000000000013 | 3.96 | 0.8200000000000004 | 43.07033333333333
22 | 6.64 | 4.51 | 325.176 | 2485 | 43.34944444444444 | -0.9700000000000006 | 4.21 | 0.9409000000000013 | 4.21 | 0.8400000000000004 | 43.34944444444444
22.5 | 6.53 | 4.79 | 353.157 | 2513 | 43.83788888888889 | -1.08 | 4.49 | 1.1664 | 4.49 | 0.8600000000000004 | 43.83788888888889
23 | 6.66 | 5.17 | 172 | 2692 | 46.96044444444445 | -0.9500000000000002 | 4.87 | 0.9025000000000003 | 4.87 | 0.8800000000000004 | 46.96044444444445
23.5 | 6.6 | 5.51 | 25.408 | 2545 | 44.39611111111111 | -1.010000000000001 | 5.21 | 1.020100000000001 | 5.21 | 0.9000000000000005 | 44.39611111111111
24 | 6.54 | 5.84 | 45 | 2565 | 44.745 | -1.07 | 5.54 | 1.144900000000001 | 5.54 | 0.9200000000000005 | 44.745
24.5 | 6.49 | 6.25 | 65.4 | 2585 | 45.09388888888889 | -1.12 | 5.95 | 1.2544 | 5.95 | 0.9400000000000005 | 45.09388888888889
25 | 6.43 | 6.76 | 87.337 | 2607 | 45.47766666666667 | -1.180000000000001 | 6.46 | 1.392400000000001 | 6.46 | 0.9600000000000005 | 45.47766666666667
25.5 | 6.35 | 4.51 | 106.504 | 2627 | 45.82655555555556 | -1.260000000000001 | 4.21 | 1.587600000000002 | 4.21 | 0.9800000000000005 | 45.82655555555556
26 | 6.36 | 7.73 | 128.66 | 2649 | 46.21033333333334 | -1.25 | 7.430000000000001 | 1.5625 | 7.430000000000001 | 1 | 46.21033333333334
26.5 | 6.19 | 7.9 | 178 | 2698 | 47.06511111111111 | -1.42 | 7.600000000000001 | 2.0164 | 7.600000000000001 | 1.02 | 47.06511111111111
B4.18 |  |  | 160.498 | 160 | 2.791111111111111
B4.28 |  |  | 94.4 | -266 | -4.640222222222222
B5.08 |  |  | 65.638 | -654 | -11.40866666666667
B5.18 |  |  | 40 | -1040 | -18.14222222222222
B5.28 |  |  | 16.77 | -1423 | -24.82344444444444
B6.08 |  |  | 351.469 | -1449 | -25.277
B6.18 |  |  | 319.399 | -1841 | -32.11522222222222
B6.28 |  |  | 275.2 | -2245 | -39.16277777777778
B7.08 |  |  | 244.933 | -2635 | -45.96611111111111
B7.18 |  |  | 217 | -3023 | -52.73455555555556
B7.28 |  |  | 192.1 | -3408 | -59.45066666666667