N X Y XY X Y : Regresion Lineal

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 4

REGRESION LINEAL

n X Y X² Y² XY
1 19 1.75 361 3.06 33.25
2 20 1.76 400 3.10 35.20
3 20 1.53 400 2.34 30.60
4 20 1.67 400 2.79 33.40
5 20 1.70 400 2.89 34.00
6 21 1.79 441 3.20 37.59
7 21 1.80 441 3.24 37.80
8 22 1.70 484 2.89 37.40
9 22 1.65 484 2.72 36.30
10 22 1.75 484 3.06 38.50
11 23 1.72 529 2.96 39.56
12 23 1.54 529 2.37 35.42
13 24 1.73 576 2.99 41.52
14 24 1.70 576 2.89 40.80
15 27 1.70 729 2.89 45.90
∑ 328 25.49 7234 43.40 557.24

n= 15

Resultados Formula Calculadora


b -0.0023
a 1.749
r -0.061
REGRESION LOGARITMICA

n X Y In X (In x)² Y² (In x) Y


1 19 1.75 2.94 8.67 3.06 5.15
2 20 1.76 3.00 8.97 3.10 5.27
3 20 1.53 3.00 8.97 2.34 4.58
4 20 1.67 3.00 8.97 2.79 5.00
5 20 1.70 3.00 8.97 2.89 5.09
6 21 1.79 3.04 9.27 3.20 5.45
7 21 1.80 3.04 9.27 3.24 5.48
8 22 1.70 3.09 9.55 2.89 5.25
9 22 1.65 3.09 9.55 2.72 5.10
10 22 1.75 3.09 9.55 3.06 5.41
11 23 1.72 3.14 9.83 2.96 5.39
12 23 1.54 3.14 9.83 2.37 4.83
13 24 1.73 3.18 10.10 2.99 5.50
14 24 1.70 3.18 10.10 2.89 5.40
15 27 1.70 3.30 10.86 2.89 5.60
∑ 328 25.49 46.21 142.49 43.40 78.52

n = 15

Resultados Formula Calculadora


b -0.053
a 1.865
r -0.063
REGRESION EXPONENCIAL

n X Y In y X² (In y)² (In y) x


1 19 1.75 0.56 361.00 0.31 10.63
2 20 1.76 0.57 400.00 0.32 11.31
3 20 1.53 0.43 400.00 0.18 8.51
4 20 1.67 0.51 400.00 0.26 10.26
5 20 1.70 0.53 400.00 0.28 10.61
6 21 1.79 0.58 441.00 0.34 12.23
7 21 1.80 0.59 441.00 0.35 12.34
8 22 1.70 0.53 484.00 0.28 11.67
9 22 1.65 0.50 484.00 0.25 11.02
10 22 1.75 0.56 484.00 0.31 12.31
11 23 1.72 0.54 529.00 0.29 12.47
12 23 1.54 0.43 529.00 0.19 9.93
13 24 1.73 0.55 576.00 0.30 13.15
14 24 1.70 0.53 576.00 0.28 12.74
15 27 1.70 0.53 729.00 0.28 14.33
∑ 328 25.49 7.94 7234.00 4.23 173.51

n= 15
Resultados Formula Calculadora
b -0.0012
a 1.7425
r -0.0531
REGRESION DE POTENCIA

n x y In x In y (In x)² (In y)² (In x) (In y)


1 19 1.75 2.94 0.56 8.67 0.31 1.65
2 20 1.76 3.00 0.57 8.97 0.32 1.69
3 20 1.53 3.00 0.43 8.97 0.18 1.27
4 20 1.67 3.00 0.51 8.97 0.26 1.54
5 20 1.70 3.00 0.53 8.97 0.28 1.59
6 21 1.79 3.04 0.58 9.27 0.34 1.77
7 21 1.80 3.04 0.59 9.27 0.35 1.79
8 22 1.70 3.09 0.53 9.55 0.28 1.64
9 22 1.65 3.09 0.50 9.55 0.25 1.55
10 22 1.75 3.09 0.56 9.55 0.31 1.73
11 23 1.72 3.14 0.54 9.83 0.29 1.70
12 23 1.54 3.14 0.43 9.83 0.19 1.35
13 24 1.73 3.18 0.55 10.10 0.30 1.74
14 24 1.70 3.18 0.53 10.10 0.28 1.69
15 27 1.70 3.30 0.53 10.86 0.28 1.75
∑ 328 25.49 46.21 7.94 142.49 4.23 24.45

n= 15
Resultados Formula Calculadora
b -1.728E-06
a 1.6976
r 364.64

You might also like