regresion por minimos cuadrados
i
1
2
3
4
5
6
7
8
9
SUM
A0
A1
Y media
X media
x
1
2
3
4
5
6
7
8
9
y
1
1.5
2
3
4
5
8
10
13
45
47.5
1.458333333
-2.013888889
5.277777778
5
Y estimada 1.458333333 -2.013888889 x
St
Sr
Sy/x
R2
R
139.55555
11.95138889
1.306652697
0.914361067
0.956222289
xy
1
3
6
12
20
30
56
80
117
325
x2
1
4
9
16
25
36
49
64
81
285
(y-y^)2
2.41975309
0.35667438
0.13040123
0.6714892
1.63271605
3.01408179
0.03780864
0.12056327
3.56790123
11.951389
14
(y-y-)2
18.2993827
14.2716049
10.7438272
5.1882716
1.63271605
0.07716049
7.41049383
22.2993827
59.632716
139.55556
12
10
8
6
4
2
0
0
14
12
10
8
Column C
6
Linear (Column C)
4
2
0
0
10
Ejercicio 17.6 b)
i
1
2
3
4
5
6
7
8
9
Suma
a0
a1
a2
Formula
N
St
Sr
Sy/x
R2
x
1
2
3
4
5
6
7
8
9
45
1.4880952381
-0.4518398268
0.191017316
1.4880952381
9
139.5555555556
0.7132034632
0.3447712921
0.9948894656
y
1
1.5
2
3
4
5
8
10
13
47.5
x^2
1
4
9
16
25
36
49
64
81
285
-0.45 x
x^3
1
8
27
64
125
216
343
512
729
2025
x^4
1
16
81
256
625
1296
2401
4096
6561
15333
xy
1
3
6
12
20
30
56
80
117
325
0.191
Matriz
x^2y
1
6
18
48
100
180
392
640
1053
2438
x^2
(y-y^)2
(y-y-)2
0.052 18.299382716
0.023 14.271604938
0.022 10.74382716
0.069 5.1882716049
### 1.6327160494
0.427 0.0771604938
0.099 7.4104938272
0.01 22.299382716
0.011 59.632716049
0.713 139.55555556
a0
9
45
285
a1
45
285
2025
Determinante
166320
14
f(x) = 0.191017316x^2 - 0.4518398268x + 1.4880952
R = 0.9948894656
12
10
8
6
4
2
0
0
10
a2
285
2025
15333
b
47.5
325
2438
Column C
Polynomial (Column C)
10
a1
47.5
325
2438
a0
18398268x + 1.4880952381
a2
45
285
2025
247500
285
2025
15333
a0
b
9
45
285
a1
a2
47.5
325
2438
-75150
a0
285
2025
15333
9
45
285
a2
a1
a2
45
285
2025
31770
47.5
325
2438
SATURACION
i
1
2
3
4
5
6
7
x
0.75
2
3
4
6
8
8.5
A1
A0
Y prom
X prom
Y estimada
0.3693200573
0.341540242
0.4906389906
0.4037114846
0.341540242
32.25
y
1.2
1.95
2
2.4
2.4
2.7
2.6
1/x
1.33333333
0.5
0.33333333
0.25
0.16666667
0.125
0.11764706
15.25 2.82598039
0.36932006 x
2.9279126645
1.0813368732
POTENCIA
i
1
2
3
4
5
6
7
x
0.75
2
3
4
6
8
8.5
y
1.2
1.95
2
2.4
2.4
2.7
2.6
logx
-0.12493874
0.30103
0.47712125
0.60205999
0.77815125
0.90308999
0.92941893
A1
A0
0.3114220111
0.1532955603
1.4232970864
0.3114220111
y=
0.3114220111 x^
32.25
15.25 3.86593267
1.42329709
Parabola
i
1
2
3
4
5
6
7
Formula
x
0.75
2
3
4
6
8
8.5
y
1.2
1.95
2
2.4
2.4
2.7
2.6
32.25
32.25
15.25
x2
0.5625
4
9
16
36
64
72.25
201.8125
0.44990062
0.9
1/y
0.83333333
0.51282051
0.5
0.41666667
0.41666667
0.37037037
0.38461538
(1/x*1/y)
1.11111111
0.25641026
0.16666667
0.10416667
0.06944444
0.0462963
0.04524887
(1/x)2
1.777777778
0.25
0.111111111
0.0625
0.027777778
0.015625
0.01384083
0.8
Y
1.199088235
1.900417114
2.152171768
2.304836493
2.480813482
2.579278981
2.597472355
f(x) = 0
R = 0.9
0.7
0.6
0.5
0.4
0.3
0.2
3.43447293 1.79934431 2.258632497
0.1
0
0
logy
0.07918125
0.29003461
0.30103
0.38021124
0.38021124
0.43136376
0.41497335
log x*log y
-0.0098928
0.08730912
0.14362781
0.22890998
0.29586185
0.3895603
0.38568408
(log x)2
0.015609688
0.090619058
0.227644692
0.362476233
0.605519368
0.815571525
0.863819539
Y
1.30132834
1.76621239
2.003925727
2.191746358
2.486732027
2.719804326
2.771641601
3
2.5
2
1.5
1
0.2
3
2.5
2
2.27700545 1.52106033 2.981260104
1.5
1
0.5
0
0
3
2.5
x3
x4
0.421875 0.31640625
8
16
27
81
64
256
216
1296
512
4096
614.125 5220.0625
1441.54688 10965.3789
xy
0.9
3.9
6
9.6
14.4
21.6
22.1
78.5
-0.0306938 x^2
1.5
1
0.5
0
0
0.9
0.8
f(x) = 0.3693200573x + 0.341540242
R = 0.9857107912
0.7
0.6
0.5
Column F
0.4
Linear (Column F)
0.3
0.2
0.1
0
0
0.2
0.4
0.6
0.8
1.2
1.4
Column D
Power (Column D)
2
Column D
Power (Column D)
Matriz
Column D
Polynomial (Column D)
a0
a1
7
32.25
32.25
201.8125
201.8125 1441.54688
a2
201.8125
1441.54688
10965.3789
b
15.25
78.5
511.925
i
1
2
3
4
5
6
7
8
9
10
x
2.5
3.5
5
6
7.5
10
12.5
15
17.5
20
y
13
11
8.5
8.2
7
6.2
5.2
4.8
4.6
4.3
logx
0.39794001
0.54406804
0.69897
0.77815125
0.87506126
1
1.09691001
1.17609126
1.24303805
1.30103
logy
1.1139433523
1.0413926852
0.9294189257
0.9138138524
0.84509804
0.7923916895
0.7160033436
0.6812412374
0.6627578317
0.6334684556
99.5
72.8
9.11125989
8.3295294133
-0.54028958
1.32522482
0.91112599
0.130103
21.145834
-0.54028958
21.145834
x^
-0.54028958
A1
A0
Y prom
X prom
Y=
Y(9)=
6.45145295
logx*logy
0.44328263
0.56658848
0.64963595
0.71108539
0.73951256
0.79239169
0.78539124
0.80120186
0.8238332
0.82416146
(log x)2
0.15835625
0.29601004
0.48855907
0.60551937
0.76573221
1
1.20321158
1.38319065
1.54514359
1.69267905
7.13708446 9.1384018
14
f(x) = 21.1458339855 x^-0.5402895791
R = 0.9951404159
12
10
8
6
4
2
0
0
10
15
20
25
-0.5402895791
15
Column C
Power (Column C)
20
25
x
0
1
2
3
4
5
suma
y
0.4
0.8
1.2
1.6
2
2.3
8.3
lny
xlny
800 6.68461173 2.67384469
975 6.88243747 5.50594998
1500 7.31322039 8.77586446
1950 7.57558465 12.1209354
2900 7.97246602 15.944932
3600 8.18868912 18.833985
11725 44.6170094 63.8555116
a1
a0
alfa
beta
n
funcion
0.81865123
6.3037007
546.590939
0.81865123
6
546.590939 e^
0.81865123
funcion
546.590939 e^
0.81865123
x^2
Y nueva
0.16 758.362261
0.64 1052.18231
1.44 1459.84008
2.56 2025.44086
4 2810.17814
5.29 3592.48169
14.09
4000
3500
f(x) = 546.5909394332 exp( 0.8186512283 x )
3000
2500
Column D
2000
Exponential
1500
1000
500
0
0
0.5
1.5
2.5
86512283 x )
Column D
Exponential (Column D)
2.5
x
0
1
2
3
4
5
0.4
0.8
1.2
1.6
2
2.3
8.3
suma
n
(log e^B2x)/x
B5
Logy
xlogy
800 2.90308999 1.16123599
975 2.98900462 2.39120369
1500 3.17609126 3.81130951
1950 3.29003461 5.26405538
2900
3.462398
6.924796
3600 3.5563025 8.17949575
11725 19.376921 27.7320963
x^2
Y nueva
0.16 758.362261
0.64 1052.18231
1.44 1459.84008
2.56 2025.44086
4 2810.17814
5.29 3592.48169
14.09
a1
a0
alpha
beta
0.35553571
2.73766243
546.590939
0.35553571
funcion
546.590939 10^
0.35553571
x1
1
2
3
4
5
6
7
8
9
suma
n
St
Sr
Sy/x
R2
x2
0
1
1
2
2
3
3
4
4
20
9
1058.74889
4.73965217
0.82285671
0.99552335
y
0
1
2
1
2
1
2
1
2
12
15.1
17.9
12.7
25.6
20.5
35.1
29.7
45.4
40.2
242.2
x1^2
x1*x2
0
1
1
4
4
9
9
16
16
60
x2^2
0
1
2
2
4
3
6
4
8
30
x1y
0
1
4
1
4
1
4
1
4
20
x2y
0
17.9
12.7
51.2
41
105.3
89.1
181.6
160.8
659.6
0
17.9
25.4
25.6
41
35.1
59.4
45.4
80.4
330.2
(y-y^)2
0.40848771
0.01398563
0.38764159
1.45674405
0.36313724
0.53607864
0.18303516
0.2944242
1.09611796
4.73965217
(y-y-)2
139.502346
81.2001235
201.955679
1.71901235
41.1023457
67.0579012
7.77790124
341.839012
176.594568
1058.74889
Matriz
a0
a1
9
20
12
Formula
20
60
30
Kramer
Determinante
a0
a1
a2
a2
12
30
20
242.2
659.6
330.2
460
14.4608696
9.02521739
-5.70434783
14.4608696
9.02521739
a1
242.2
659.6
330.2
Da0
a2
20
60
30
6652
-5.70434783 x2
a0
12
30
20
9
20
12
Da1
a2
242.2
659.6
330.2
4151.6
a0
12
30
20
a1
9
20
12
Da2
b
20
60
30
-2624
242.2
659.6
330.2
x
1
2
3
4
5
6
7
Total
y
1
10
100
1,000
10,000
100,000
1,000,000
1111111
logx
1100
1000
925
800
625
550
420
5420
0
1
2
3
4
5
6
21
7
a1
a0
-0.069427376
3.08
Funcion
3.08
1200
f(x) = 1189.7113730209 x^-0.0694273757
R = 0.9658073254
1000
800
600
400
200
0
0
200000
400000
600000
80000
200
0
0
200000
400000
600000
80000
logy
logxlogy
3.0413926852
3
2.9661417327
2.903089987
2.7958800173
2.7403626895
2.6232492904
20.0701164021
beta
alpha
x2
0
3
5.93228347
8.70926996
11.1835201
13.7018134
15.7394957
58.2663827
0
1
4
9
16
25
36
91
-0.06942738
1,189.71
-0.0694273757 x
Column D
Power (Column D)
600000
800000
1000000
1200000
600000
800000
1000000
1200000
200
180
f(x) = 5.8x + 60
R = 0.97547638
160
140
120
100
80
60
40
20
0
0
200
x
1
2
3
4
5
6
180
y
0
4
8
12
16
20
67
84
98
125
149
185
f(x) = 67.30603
R = 0.9978657
160
140
120
100
80
60
40
20
0
0
200
180
160
140
120
100
80
60
40
20
f(x) = 0.150669
R = 0.9979457
180
f(x) = 0.150669
R = 0.9979457
160
140
120
100
80
60
40
20
0
0
200
180
f(x) = 5.8x + 60
R = 0.9754763877
160
140
Column D
Linear (Column
D)
120
100
80
60
40
20
0
0
10
15
20
25
200
180
f(x) = 67.3060364272 exp( 0.0502932201 x )
R = 0.9978657612
160
140
120
Column D
100
Exponential (Column D)
80
60
40
20
0
0
10
15
20
25
200
180
160
f(x) = 0.1506696429x^2 + 2.7866071429x + 68.0357142857
R = 0.9979457628
140
120
100
80
60
40
20
Column D
Polynomial (Column D)
180
f(x) = 0.1506696429x^2 + 2.7866071429x + 68.0357142857
R = 0.9979457628
160
140
120
Column D
100
Polynomial (Column D)
80
60
40
20
0
0
10
15
20
25
la cuadratica es la que se acopla mejor a los datos debido a la curvatura
