Regresion Lineal Simple

1 Un centro comercial sabe en función de la distancia, en kilómetros, a la que se sitúe de un núcleo de población,
acuden los clientes, en cientos:

Variable X Variable Y Decimales Y 1

Estatura Peso X2 Y2 X.Y Y*

1 1.86 85.6 3.4596 7327.36 159.216 83.567036
2 1.89 85.7 3.5721 7344.49 161.973 86.598014
3 1.9 86.7 3.61 7516.89 164.73 87.60834
4 1.92 90.4 3.6864 8172.16 173.568 89.628992
5 1.93 87.6 3.7249 7673.76 169.068 90.639318
6 1.93 91.7 3.7249 8408.89 176.981 90.639318
7 1.98 93.5 3.9204 8742.25 185.13 95.690948
8 2.01 103.4 4.0401 10691.56 207.834 98.721926
9 2.03 100.6 4.1209 10120.36 204.218 100.742578
10 2.05 101.4 4.2025 10281.96 207.87 102.76323
11 0 0 0 0
12 0 0 0 0
13 0 0 0 0
14 0 0 0 0
15 0 0 0 0
S 19.5 926.6 38.0618 86279.68 1810.588

A= -104.3536 Y* = -104.3536 101.0326 X

B= 101.0326 R = 0.9447
úcleo de población,

Y*
83.6
86.6
87.6
89.6
90.6
90.6
95.7
98.7
100.7
102.8
0
0
0
0
0
 Regresion Lineal Multiple
Variable Y (1) Variable X1 (2) Variable X2 (3) Decimales Y 1

Horas Ocio
Notas Horas Estud Sem
Sem Y2 X12 X22

1 16.5 35 8 272.25 1225 64

2 17.6 29 6 309.76 841 36
3 11.7 11 15 136.89 121 225
4 15.9 24 7 252.81 576 49
5 14.3 26 9 204.49 676 81
6 16.7 36 4 278.89 1296 16
7 10.8 14 18 116.64 196 324
8 0 0 0
9 0 0 0
10 0 0 0
11 0 0 0
12 0 0 0
13 0 0 0
14 0 0 0
15 0 0 0
S 103.5 175 67 1571.73 4931 795

7 175 67 A 17.2807
DM 175 4931 1417 132308 B 0.055
67 1417 795 C -0.4043

103.5 175 67 (X - X)^2 n

DA 2722.4 4931 1417 2286381 2.9241 Media
914.3 1417 795 7.8961 Varianza
9.5481 Desv Est (S1)
7 103.5 67 1.2321
DB 175 2722.4 1417 7277.2 0.2401 r12
67 914.3 795 3.6481 r13
15.9201 r23
7 175 103.5 0
DC 175 4931 2722.4 -53497 0 r12.3
67 1417 914.3 0
0 S12.3
0
0 R1.23
0
0
 X1 . Y X2 . Y X1 . X 2 Y*
577.5 132 280 83.2057 83.2 103.5 =
510.4 105.6 174 66.8757 66.9 2722.4 =
128.7 175.5 165 137.8857 137.9 914.3 =
381.6 111.3 168 74.6007 74.6
371.8 128.7 234 90.7107 90.7
601.2 66.8 144 51.2607 51.3
151.2 194.4 252 162.0507 162.1
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
2722.4 914.3 1417

Y* = 17.2807 + 0.055 X1 - 0.4043 X2

7
14.79
6.90145
2.6271

0.8891 Buena Relación

-0.9569 Buena Relación
-0.8825 Buena Relación

0.3268 Baja Relación

0.7211

0.9616 Buena Relación

A B C
7 175 67
175 4931 1417
67 1417 795
 Regresion Lineal Multiple
Variable Y (1) Variable X1 (2) Variable X2 (3) Decimales Y 1

Y X1 X2 Y2 X12 X22

1 11.5 -4 0.86 132.25 16 0.7396

2 13.7 -10 -1.97 187.69 100 3.8809
3 14.3 1 -1.51 204.49 1 2.2801
4 13.2 -6 0.92 174.24 36 0.8464
5 10.8 8 -0.78 116.64 64 0.6084
6 13.9 -2 -1.94 193.21 4 3.7636
7 10.7 -3 -0.86 114.49 9 0.7396
8 0 0 0
9 0 0 0
10 0 0 0
11 0 0 0
12 0 0 0
13 0 0 0
14 0 0 0
15 0 0 0
S 88.1 -16 -5.28 1123.01 230 12.8586

7 -16 -5.28 A 11.9086

DM -16 230 9.45 11970.0669 B -0.1111
-5.28 9.45 12.8586 C -0.5609

88.1 -16 -5.28 (X - X)^2 n

DA -221.4 230 9.45 142546.88331 1.1881 Media
-71.14 9.45 12.8586 1.2321 Varianza
2.9241 Desv Est (S1)
7 88.1 -5.28 0.3721
DB -16 -221.4 9.45 -1330.33176 3.2041 r12
-5.28 -71.14 12.8586 1.7161 r13
3.5721 r23
7 -16 88.1 0
DC -16 230 -221.4 -6713.902 0 r12.3
-5.28 9.45 -71.14 0
0 S12.3
0
0 R1.23
0
0
 X1 . Y X2 . Y X1 . X 2 Y*
-46 9.89 -3.44 13.0926 13.1 88.1 =
-137 -26.989 19.7 11.3254 11.3 -221.4 =
14.3 -21.593 -1.51 10.4989 10.5 -71.14 =
-79.2 12.144 -5.52 13.3664 13.4
86.4 -8.424 -6.24 10.349 10.3
-27.8 -26.966 3.88 10.4624 10.5
-32.1 -9.202 2.58 11.5023 11.5
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
-221.4 -71.14 9.45

Y* = 11.9086 - 0.1111 X1 - 0.5609 X2

7
12.59
2.3681
1.5389

-0.382 Baja Relación

-0.4174 Baja Relación
-0.0632 Baja Relación

-0.4503 Baja Relación

1.2486

0.5845 Baja Relación

 A B C
7 -16 -5.28
-16 230 9.45
-5.28 9.45 12.8586
 Regresion Lineal Multiple
Variable Y (1) Variable X1 (2) Variable X2 (3) Decimales Y 2

Y X1 X2 Y2 X12 X22

1 16.08 3.5 0.01 258.5664 12.25 0.0001

2 10.26 2.1 0.04 105.2676 4.41 0.0016
3 26.43 1.2 0.06 698.5449 1.44 0.0036
4 8.28 -3.6 0.09 68.5584 12.96 0.0081
5 10.53 -4.3 0.08 110.8809 18.49 0.0064
6 2.22 -4.1 0.07 4.9284 16.81 0.0049
7 0 0 0
8 0 0 0
9 0 0 0
10 0 0 0
11 0 0 0
12 0 0 0
13 0 0 0
14 0 0 0
15 0 0 0
S 73.8 -5.2 0.35 1246.7466 66.36 0.0247

6 -5.2 0.35 A -2.2833

DM -5.2 66.36 -0.764 0.316348 B 3.7172
0.35 -0.764 0.0247 C 305.2257

73.8 -5.2 0.35 (X - X)^2 n

DA 25.353 66.36 -0.764 -0.72230808 14.2884 Media
3.9 -0.764 0.0247 4.1616 Varianza
199.6569 Desv Est (S1)
6 73.8 0.35 16.1604
DB -5.2 25.353 -0.764 1.1759241 3.1329 r12
0.35 3.9 0.0247 101.6064 r13
0 r23
6 -5.2 73.8 0
DC -5.2 66.36 25.353 96.557532 0 r12.3
0.35 -0.764 3.9 0
0 S12.3
0
0 R1.23
0
0
 X1 . Y X2 . Y X1 . X 2 Y* Y* =
56.28 0.1608 0.035 10.727 10.73 73.8 =
21.546 0.4104 0.084 5.52322 5.52 25.353 =
31.716 1.5858 0.072 2.17794 2.18 3.9 =
-29.808 0.7452 -0.324 -15.66432 -15.66
-45.279 0.8424 -0.344 -18.26646 -18.27
-9.102 0.1554 -0.287 -17.52312 -17.52
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
25.353 3.9 -0.764

Y* = -2.2833 + 3.7172 X1 + 305.2257 X2

6
12.3
67.8013
8.2342

0.6168 Baja Relación

-0.3361 Baja Relación
-0.895 Buena Relación

0.7521 Buena Relación

5.1106

0.7841 Buena Relación

 A B C
6 -5.2 0.35
-5.2 66.36 -0.764
0.35 -0.764 0.0247
 Regresion Lineal Multiple
Variable Y (1) Variable X1 (2) Variable X2 (3) Decimales Y 0

Y X1 X2 Y2 X12 X22

1 71 388 2414 5041 150544 5827396

2 53 258 10396 2809 66564 108076816
3 55 292 11682 3025 85264 136469124
4 48 205 12560 2304 42025 157753600
5 69 449 2464 4761 201601 6071296
6 84 331 2607 7056 109561 6796449
7 21 114 16205 441 12996 262602025
8 68 580 2005 4624 336400 4020025
9 68 622 1825 4624 386884 3330625
10 75 480 4500 5625 230400 20250000
11 0 0 0
12 0 0 0
13 0 0 0
14 0 0 0
15 0 0 0
S 612 3719 66658 40310 1622239 711197356

10 3719 66658 A 97.7977

DM 3719 1622239 17879417 1.6062017E+14 B -0.0312
66658 17879417 711197356 C -0.0037

612 3719 66658 (X - X)^2 n

DA 246037 1622239 17879417 1.5708278E+16 96.04 Media
3295021 17879417 711197356 67.24 Varianza
38.44 Desv Est (S1)
10 612 66658 174.24
DB 3719 246037 17879417 -5.01577E+12 60.84 r12
66658 3295021 711197356 519.84 r13
1616.04 r23
10 3719 612 46.24
DC 3719 1622239 246037 -602022125175 46.24 r12.3
66658 17879417 3295021 190.44
0 S12.3
0
0 R1.23
0
0
 X1 . Y X2 . Y X1 . X 2 Y* Y* =
27548 171394 936632 5827481.6921 5827482 612 =
13674 550988 2682168 25096033.7481 25096034 246037 =
16060 642510 3411144 28200436.6873 28200437 3295021 =
9840 602880 2574800 30319931.4017 30319931
30981 170016 1106336 5948179.7889 5948180
27804 218988 862917 6293385.4705 6293385
2394 340305 1847370 39118964.2409 39118964
39440 136340 1162900 4840149.7017 4840150
42296 124100 1135150 4405628.3913 4405628
36000 337500 2160000 10863082.8217 10863083
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
246037 3295021 17879417

Y* = 97.7977 - 0.0312 X1 - 0.0037 X2

10
61.2
317.2889
17.8126

0.7054 Baja Relación

-0.8986 Buena Relación
-0.8651 Buena Relación

-0.327 Baja Relación

7.3858

0.91 Buena Relación

 A B C
10 3719 66658
3719 1622239 17879417
66658 17879417 711197356
 -9 19 16 -9 19 -29096
E 10 16 109 10 16 -29720
-8 18 107 -8 18 624

15 15 94 15 15 94632
F 24 0 31 24 0 71307
24 37 17 24 37 23325

56 35 76 56 35 745822
G 75 38 81 75 38 5336
94 49 94 94 49 740486
 -9 19 16 -9 19 -29096
E 10 16 109 10 16 -29720
-8 18 107 -8 18 624

15 15 94 15 15 94632
F 24 0 31 24 0 71307
24 37 17 24 37 23325

56 35 76 56 35 745822
G 75 38 81 75 38 5336
94 49 94 94 49 740486
 105 45 -146 105 45 2292581
109 15 234 109 15 1761386
244 26 87 244 26 531195

6 0.2 2.6 6 0.2 202.58

7 1.5 6.3 7 1.5 -78.04
4 6.7 8.4 4 6.7 280.62

152.45 542.33 235.68 152.45 542.33 174238687.64005

562.4 794.58 524.36 562.4 794.58 66311121.43437
145.6 1000 2.37 145.6 1000 107927566.20568

15 12 8 15 12 1131
-10 9 11 -10 9 1185
8 -6 -3 8 -6 -54
 Regresion Lineal Multiple
Variable Y (1) Variable X1 (2) Variable X2 (3) Decimales Y 0

Y X1 X2 Y2 X12 X22

1 15 1.5 200 225 2.25 40000

2 26 2.4 300 676 5.76 90000
3 34 2.8 400 1156 7.84 160000
4 45 3.4 500 2025 11.56 250000
5 64 3.8 600 4096 14.44 360000
6 72 4.2 700 5184 17.64 490000
7 83 4.6 800 6889 21.16 640000
8 0 0 0
9 0 0 0
10 0 0 0
11 0 0 0
12 0 0 0
13 0 0 0
14 0 0 0
15 0 0 0
S 339 22.7 3500 20251 80.65 2030000

7 22.7 3500 A -6.0914

DM 22.7 80.65 12740 268100 B -4.8564
3500 12740 2030000 C 0.1405

339 22.7 3500 (X - X)^2 n

DA 1260.5 80.65 12740 -1633100 1117.5649 Media
202100 12740 2030000 503.1049 Varianza
208.2249 Desv Est (S1)
7 339 3500 11.7649
DB 22.7 1260.5 12740 -1302000 242.4249 r12
3500 202100 2030000 555.5449 r13
1195.0849 r23
7 22.7 339 0
DC 22.7 80.65 1260.5 37678 0 r12.3
3500 12740 202100 0
0 S12.3
0
0 R1.23
0
0
 X1 . Y X2 . Y X1 . X 2 Y*
22.5 3000 300 39986.624 39987 339 =
62.4 7800 720 59982.25324 59982 1260.5 =
95.2 13600 1120 79980.31068 79980 202100 =
153 22500 1700 99977.39684 99977
243.2 38400 2280 119975.45428 119975
302.4 50400 2940 139973.51172 139974
381.8 66400 3680 159971.56916 159972
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
1260.5 202100 12740

Y* = -6.0914 - 4.8564 X1 + 0.1405 X2

7
48.43
638.9524
25.2775

0.9813 Buena Relación

0.995 Buena Relación
0.9902 Buena Relación

-0.2831 Baja Relación

2.4213

0.9954 Buena Relación

 A B C
7 22.7 3500
22.7 80.65 12740
3500 12740 2030000
 Regresion Lineal Multiple
Variable Y (1) Variable X1 (2) Variable X2 (3) Decimales Y 0

Y X1 X2 Y2 X12 X22

1 15 1.5 200 225 2.25 40000

2 26 2.4 300 676 5.76 90000
3 34 2.8 400 1156 7.84 160000
4 45 3.4 500 2025 11.56 250000
5 64 3.8 600 4096 14.44 360000
6 72 4.2 700 5184 17.64 490000
7 83 4.6 800 6889 21.16 640000
8 0 0 0
9 0 0 0
10 0 0 0
11 0 0 0
12 0 0 0
13 0 0 0
14 0 0 0
15 0 0 0
S 339 22.7 3500 20251 80.65 2030000

7 22.7 3500 A -6.0914

DM 22.7 80.65 12740 268100 B -4.8564
3500 12740 2030000 C 0.1405

339 22.7 3500 (X - X)^2 n

DA 1260.5 80.65 12740 -1633100 1117.5649 Media
202100 12740 2030000 503.1049 Varianza
208.2249 Desv Est (S1)
7 339 3500 11.7649
DB 22.7 1260.5 12740 -1302000 242.4249 r12
3500 202100 2030000 555.5449 r13
1195.0849 r23
7 22.7 339 0
DC 22.7 80.65 1260.5 37678 0 r12.3
3500 12740 202100 0
0 S12.3
0
0 R1.23
0
0
 X1 . Y X2 . Y X1 . X 2 Y*
22.5 3000 300 39986.624 39987 339 =
62.4 7800 720 59982.25324 59982 1260.5 =
95.2 13600 1120 79980.31068 79980 202100 =
153 22500 1700 99977.39684 99977
243.2 38400 2280 119975.45428 119975
302.4 50400 2940 139973.51172 139974
381.8 66400 3680 159971.56916 159972
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
1260.5 202100 12740

Y* = -6.0914 - 4.8564 X1 + 0.1405 X2

7
48.43
638.9524
25.2775

0.9813 Buena Relación

0.995 Buena Relación
0.9902 Buena Relación

-0.2831 Baja Relación

2.4213

0.9954 Buena Relación

 A B C
7 22.7 3500
22.7 80.65 12740
3500 12740 2030000
 Regresion Lineal Multiple
Variable Y (1) Variable X1 (2) Variable X2 (3) Decimales Y 0

Y X1 X2 Y2 X12 X22

1 15 1.5 200 225 2.25 40000

2 26 2.4 300 676 5.76 90000
3 34 2.8 400 1156 7.84 160000
4 45 3.4 500 2025 11.56 250000
5 64 3.8 600 4096 14.44 360000
6 72 4.2 700 5184 17.64 490000
7 83 4.6 800 6889 21.16 640000
8 0 0 0
9 0 0 0
10 0 0 0
11 0 0 0
12 0 0 0
13 0 0 0
14 0 0 0
15 0 0 0
S 339 22.7 3500 20251 80.65 2030000

7 22.7 3500 A -6.0914

DM 22.7 80.65 12740 268100 B -4.8564
3500 12740 2030000 C 0.1405

339 22.7 3500 (X - X)^2 n

DA 1260.5 80.65 12740 -1633100 1117.5649 Media
202100 12740 2030000 503.1049 Varianza
208.2249 Desv Est (S1)
7 339 3500 11.7649
DB 22.7 1260.5 12740 -1302000 242.4249 r12
3500 202100 2030000 555.5449 r13
1195.0849 r23
7 22.7 339 0
DC 22.7 80.65 1260.5 37678 0 r12.3
3500 12740 202100 0
0 S12.3
0
0 R1.23
0
0
 X1 . Y X2 . Y X1 . X 2 Y*
22.5 3000 300 39986.624 39987 339 =
62.4 7800 720 59982.25324 59982 1260.5 =
95.2 13600 1120 79980.31068 79980 202100 =
153 22500 1700 99977.39684 99977
243.2 38400 2280 119975.45428 119975
302.4 50400 2940 139973.51172 139974
381.8 66400 3680 159971.56916 159972
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
1260.5 202100 12740

Y* = -6.0914 - 4.8564 X1 + 0.1405 X2

7
48.43
638.9524
25.2775

0.9813 Buena Relación

0.995 Buena Relación
0.9902 Buena Relación

-0.2831 Baja Relación

2.4213

0.9954 Buena Relación

 A B C
7 22.7 3500
22.7 80.65 12740
3500 12740 2030000
 Regresion Lineal Multiple
Variable Y (1) Variable X1 (2) Variable X2 (3) Decimales Y 0

Y X1 X2 Y2 X12 X22

1 15 1.5 200 225 2.25 40000

2 26 2.4 300 676 5.76 90000
3 34 2.8 400 1156 7.84 160000
4 45 3.4 500 2025 11.56 250000
5 64 3.8 600 4096 14.44 360000
6 72 4.2 700 5184 17.64 490000
7 83 4.6 800 6889 21.16 640000
8 0 0 0
9 0 0 0
10 0 0 0
11 0 0 0
12 0 0 0
13 0 0 0
14 0 0 0
15 0 0 0
S 339 22.7 3500 20251 80.65 2030000

7 22.7 3500 A -6.0914

DM 22.7 80.65 12740 268100 B -4.8564
3500 12740 2030000 C 0.1405

339 22.7 3500 (X - X)^2 n

DA 1260.5 80.65 12740 -1633100 1117.5649 Media
202100 12740 2030000 503.1049 Varianza
208.2249 Desv Est (S1)
7 339 3500 11.7649
DB 22.7 1260.5 12740 -1302000 242.4249 r12
3500 202100 2030000 555.5449 r13
1195.0849 r23
7 22.7 339 0
DC 22.7 80.65 1260.5 37678 0 r12.3
3500 12740 202100 0
0 S12.3
0
0 R1.23
0
0
 X1 . Y X2 . Y X1 . X 2 Y*
22.5 3000 300 39986.624 39987 339 =
62.4 7800 720 59982.25324 59982 1260.5 =
95.2 13600 1120 79980.31068 79980 202100 =
153 22500 1700 99977.39684 99977
243.2 38400 2280 119975.45428 119975
302.4 50400 2940 139973.51172 139974
381.8 66400 3680 159971.56916 159972
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
1260.5 202100 12740

Y* = -6.0914 - 4.8564 X1 + 0.1405 X2

7
48.43
638.9524
25.2775

0.9813 Buena Relación

0.995 Buena Relación
0.9902 Buena Relación

-0.2831 Baja Relación

2.4213

0.9954 Buena Relación

 A B C
7 22.7 3500
22.7 80.65 12740
3500 12740 2030000