Regresión lineal

i mi qi mi.qi mi2 q2
1 0 0.0109 0 0 0.00011881
2 0 0.0272 0 0 0.00073984
3 0 0.034 0 0 0.001156
4 0 -0.0129 0 0 0.00016641
5 0 -0.214 0 0 0.045796
6 0 0.0207 0 0 0.00042849
7 0 0.031 0 0 0.000961
8 0 -0.0294 0 0 0.00086436
9 0 0.0273 0 0 0.00074529
10 0 -0.0247 0 0 0.00061009
11 0.2 0.1207 0.02414 0.04 0.01456849
12 0.4 0.2971 0.11884 0.16 0.08826841
13 0.6 0.4072 0.24432 0.36 0.16581184
14 0.8 0.5789 0.46312 0.64 0.33512521
15 1 0.7137 0.7137 1 0.50936769
16 1.2 0.8797 1.05564 1.44 0.77387209
17 1.4 1.0602 1.48428 1.96 1.12402404
18 1.6 1.2252 1.96032 2.56 1.50111504
19 1.8 1.4272 2.56896 3.24 2.03689984
20 2 1.5707 3.1414 4 2.46709849
21 2.2 1.7951 3.94922 4.84 3.22238401
22 2.4 1.9978 4.79472 5.76 3.99120484
23 2.6 2.1901 5.69426 6.76 4.79653801
24 2.8 2.3128 6.47584 7.84 5.34904384
25 3 2.5988 7.7964 9 6.75376144
26 3.2 2.7082 8.66624 10.24 7.33434724
27 3.4 2.9505 10.0317 11.56 8.70545025
28 3.6 3.1636 11.38896 12.96 10.00836496
29 3.8 3.4027 12.93026 14.44 11.57836729
30 4 3.5659 14.2636 16 12.71564281
31 4.1 3.7353 15.31473 16.81 13.95246609
32 4.2 3.7752 15.85584 17.64 14.25213504
33 4.3 3.9559 17.01037 18.49 15.64914481
34 4.4 4.0379 17.76676 19.36 16.30463641
35 4.5 4.1743 18.78435 20.25 17.42478049
36 4.6 4.2612 19.60152 21.16 18.15782544
37 4.7 4.4222 20.78434 22.09 19.55585284
38 4.8 4.525 21.72 23.04 20.475625
39 4.9 4.654 22.8046 24.01 21.659716
 40 5 4.7533 23.7665 25 22.59386089
Total 87.5 77.1305 291.17493 322.65 263.54888513
 a 0.9330
b -0.1127

q = 0.933 m - 0.1127

Coeficiente de correlación:
R 0.9975
 N°
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
Total
0.99795991
 m q mi.qi mi² q²
0 2.616 0 0 6.843456
0 0.653 0 0 0.426409
0 8.160 0 0 66.585600
0 3.096 0 0 9.585216
0 5.136 0 0 26.378496
0 4.968 0 0 24.681024
0 7.440 0 0 55.353600
0 -7.056 0 0 49.787136
0 6.552 0 0 42.928704
0 -5.928 0 0 35.141184
72 76.968 5541.696 5184 5924.073024
96 95.304 9149.184 9216 9082.852416
144 121.728 17528.832 20736 14817.705984
192 186.936 35891.712 36864 34945.068096
240 219.288 52629.12 57600 48087.226944
288 235.128 67716.864 82944 55285.176384
336 278.448 93558.528 112896 77533.288704
384 318.048 122130.432 147456 101154.530304
432 342.528 147972.096 186624 117325.430784
480 424.968 203984.64 230400 180597.801024
528 478.824 252819.072 278784 229272.422976
576 479.472 276175.872 331776 229893.398784
624 549.624 342965.376 389376 302086.541376
672 555.072 373008.384 451584 308104.925184
720 647.712 466352.64 518400 419530.834944
768 697.968 536039.424 589824 487159.329024
816 708.120 577825.92 665856 501433.934400
888 855.264 759474.432 788544 731476.509696
912 816.648 744782.976 831744 666913.955904
960 855.816 821583.36 921600 732421.025856
1008 954.048 961680.384 1016064 910207.586304
1056 969.096 1023365.38 1115136 939147.057216
1104 1022.688 1129047.55 1218816 1045890.745344
1152 1086.000 1251072 1327104 1179396.000000
1200 1140.792 1368950.4 1440000 1301406.387264
15648 14142.125 11641246.3 12774528 10629411.518761

a 0.9203904
b -7.43268458
R 0.87227421