Observaciones

n INV. PUBL Bruto Interno PBI con retraso INV G

INV G PBI x3 RETRASO
1 4.4 116.8 113.0 3.6
2 5.1 122.2 116.8 4.4
3 5.5 126.5 122.2 5.1
4 6.5 134.4 126.5 5.5
5 10.2 147.0 134.4 6.5
6 11.4 153.3 147.0 10.2
7 10.7 155.6 153.3 11.4
8 7.9 156.1 155.6 10.7
9 6.5 152.0 156.1 7.9
10 7.4 158.2 152.0 6.5
11 9.7 167.6 158.2 7.4
12 12.0 176.9 167.6 9.7
13 12.5 176.5 176.9 12.0
14 11.0 158.1 176.5 12.5
15 11.1 163.8 158.1 11.0
16 8.9 167.2 163.8 11.1
17 8.5 183.0 167.2 8.9
18 8.1 200.8 183.0 8.5
19 5.5 181.8 200.8 8.1
20 6.4 159.4 181.8 5.5
21 4.7 151.5 159.4 6.4
22 5.1 154.9 151.5 4.7
23 6.1 154.0 154.9 5.1
24 7.1 162.1 154.0 6.1
25 9.3 182.0 162.1 7.1
26 9.1 195.5 182.0 9.3
27 8.9 201.0 195.5 9.1
28 10.1 214.0 201.0 8.9
29 10.9 213.2 214.0 10.1
30 12.0 216.4 213.2 10.9
31 10.2 222.2 216.4 12.0
32 7.8 223.6 222.2 10.2
33 7.3 235.8 223.6 7.8
34 7.5 245.6 235.8 7.3
35 7.5 257.8 245.6 7.5
36 8.2 274.0 257.8 7.5
37 9.7 294.6 274.0 8.2
38 11.3 319.7 294.6 9.7
39 14.4 348.8 319.7 11.3
40 19.1 352.7 348.8 14.4
41 22.0 382.1 352.7 19.1
42 19.5 406.2 382.1 22.0
43 23.3 431.2 406.2 19.5
44 25.9 456.4 431.2 23.3
45 25.1 467.3 456.4 25.9
 46 23.4 482.5 467.3 25.1
47 23.5 501.6 482.5 23.4
48 23.0 514.2 501.6 23.5
49 24.3 534.6 514.2 23.0
50 23.9 546.6 534.6 24.3
51 20.3 487.2 546.6 23.9
52 25.4 552.6 487.2 20.3
53 27.3 567.4 552.6 25.4
54 27.6 564.3 567.4 27.3
689.9 14,670.7 14,219.5 665.9
12.8 12.8

INVERSIÓN PÚBLICA 1970-2023

30.0

25.0

20.0

15.0

10.0

5.0

0.0
0 10 20 30 40 50 60

parámetr
Y^2 X2^2 x3^2 x4^2 X2*Yt
19.121 13,653.689 12,778.946 13.257 510.955
25.508 14,936.017 13,653.689 19.121 617.245
30.140 15,992.890 14,936.017 25.508 694.277
41.967 18,063.629 15,992.890 30.140 870.671
103.443 21,613.998 18,063.629 41.967 1495.267
129.528 23,513.156 21,613.998 103.443 1745.166
115.182 24,198.602 23,513.156 129.528 1669.506
61.886 24,367.834 24,198.602 115.182 1228.020
42.428 23,097.009 24,367.834 61.886 989.931
55.236 25,025.342 23,097.009 42.428 1175.717
93.654 28,088.419 25,025.342 55.236 1621.911
145.091 31,293.964 28,088.419 93.654 2130.835
155.626 31,154.721 31,293.964 145.091 2201.925
120.616 25,006.994 31,154.721 155.626 1736.735
122.436 26,844.201 25,006.994 120.616 1812.925
79.876 27,962.194 26,844.201 122.436 1494.493
72.635 33,482.046 27,962.194 79.876 1559.479
65.802 40,311.805 33,482.046 72.635 1628.685
30.453 33,059.240 40,311.805 65.802 1003.367
40.650 25,419.838 33,059.240 30.453 1016.521
21.752 22,949.826 25,419.838 40.650 706.543
25.731 23,979.761 22,949.826 21.752 785.512
37.157 23,721.236 23,979.761 25.731 938.833
50.589 26,274.141 23,721.236 37.157 1152.898
85.829 33,139.898 26,274.141 50.589 1686.527
83.536 38,234.324 33,139.898 85.829 1787.159
78.706 40,404.735 38,234.324 83.536 1783.280
102.972 45,808.110 40,404.735 78.706 2171.854
117.962 45,449.973 45,808.110 102.972 2315.459
144.154 46,818.894 45,449.973 117.962 2597.908
104.091 49,375.821 46,818.894 144.154 2267.060
60.747 49,987.827 49,375.821 104.091 1742.593
53.478 55,588.883 49,987.827 60.747 1724.173
55.931 60,315.732 55,588.883 53.478 1836.716
55.749 66,445.263 60,315.732 55.931 1924.642
67.642 75,060.193 66,445.263 55.749 2253.262
93.408 86,787.882 75,060.193 67.642 2847.219
128.181 102,203.614 86,787.882 93.408 3619.473
206.099 121,693.577 102,203.614 128.181 5008.081
365.662 124,376.167 121,693.577 206.099 6743.856
482.480 145,972.686 124,376.167 365.662 8392.190
380.600 165,021.207 145,972.686 482.480 7925.094
542.824 185,916.350 165,021.207 380.600 10045.884
669.775 208,311.662 185,916.350 542.824 11811.939
631.094 218,361.043 208,311.662 669.775 11739.099
 547.316 232,793.239 218,361.043 631.094 11287.667
550.139 251,565.971 232,793.239 547.316 11764.190
530.588 264,417.066 251,565.971 550.139 11844.684
590.512 285,824.960 264,417.066 530.588 12991.656
572.665 298,777.026 285,824.960 590.512 13080.485
413.133 237,356.128 298,777.026 572.665 9902.502
643.688 305,322.704 237,356.128 413.133 14019.009
747.087 321,931.552 305,322.704 643.688 15508.411
761.893 318,389.999 321,931.552 747.087 15574.951
11,554.4 5,085,663.0 4,780,052.0 10,805.8 238,984.4

tabulación SYt 689.901 SX2tYt

SX2t 14,670.7 SX3tYt
SX3t 14,219.5 SX4tYt
SX4t 665.9

SYt^2 11,554.445 SX2tX3t

SX2t^2 5,085,663.038 SX2tX4t
SX3t^2 4,780,051.985 SX3tX4t
SX4t^2 10,805.809 Yest
N

matriz 54 14,670.7 14,219.5 665.9

14,670.7 5,085,663.038 4923816.565 230411.123
14,219.5 4923816.565 4,780,051.985 223821.079
665.9 230411.123 223821.079 10,805.809

inversa 0.0858 -0.0001 -0.0001 -0.0001

-0.0001 0.0001 -0.0001 0.0000
-0.0001 -0.0001 0.0001 -0.0002
-0.0001 0.0000 -0.0002 0.0031

b1 0.0312
b2 0.0654
b3 -0.0570
b4 0.8083
X3*Yt X4*Yt X2*X3 X2*X4 X3*X4 Y estimada
494.317 15.921 13209.078 425.442 411.588 4.2
590.153 22.085 14280.467 534.411 510.955 4.9
670.945 27.727 15455.423 638.710 617.245 5.4
819.247 35.565 16996.754 737.857 694.277 6.1
1366.953 65.887 19759.232 952.399 870.671 7.2
1673.203 115.753 22543.587 1559.576 1495.267 9.9
1645.691 122.145 23853.417 1770.420 1745.166 10.7
1223.748 84.429 24283.071 1675.334 1669.506 10.1
1016.800 51.242 23723.914 1195.569 1228.020 7.4
1129.512 48.411 24041.850 1030.427 989.931 7.0
1530.923 71.924 26512.682 1245.594 1175.717 8.0
2018.753 116.569 29647.900 1711.960 1621.911 9.9
2206.840 150.266 31224.265 2126.090 2130.835 11.2
1938.495 137.007 27912.111 1972.747 2201.925 10.4
1749.788 121.523 25909.319 1799.401 1736.735 10.6
1464.311 98.892 27397.495 1850.292 1812.925 10.6
1425.145 76.170 30597.900 1635.363 1494.493 9.7
1484.318 69.134 36738.559 1711.156 1559.479 9.6
1107.973 44.765 36505.858 1474.917 1628.685 7.0
1159.248 35.184 28988.972 879.832 1003.367 4.6
743.593 29.736 24153.279 965.872 1016.521 6.0
768.458 23.658 23459.142 722.223 706.543 5.3
943.936 30.921 23850.149 781.266 785.512 5.4
1095.457 43.356 24965.078 988.062 938.833 6.8
1501.696 65.894 29508.005 1294.798 1152.898 8.5
1663.842 84.675 35596.090 1811.525 1686.527 9.9
1734.723 81.085 39304.551 1837.183 1787.159 9.4
2039.744 90.025 43021.675 1898.779 1783.280 9.8
2324.564 110.212 45628.690 2163.348 2171.854 10.0
2559.647 130.402 46129.356 2350.071 2315.459 10.8
2207.580 122.495 48080.363 2667.905 2597.908 11.9
1731.893 79.519 49680.881 2281.067 2267.060 10.2
1635.005 56.997 52714.015 1837.629 1742.593 9.0
1763.278 54.691 57904.094 1795.983 1724.173 8.6
1833.721 55.840 63306.356 1927.786 1836.716 9.0
2120.014 61.408 70621.486 2045.610 1924.642 9.3
2647.867 79.487 80711.308 2422.905 2253.262 10.3
3335.353 109.422 94180.864 3089.758 2847.219 12.0
4589.556 162.536 111523.645 3949.536 3619.473 13.8
6670.733 274.522 123027.561 5062.979 5008.081 14.8
7746.546 420.029 134742.433 7305.930 6743.856 20.4
7453.673 428.523 155204.989 8922.969 8392.190 22.6
9464.534 454.531 175157.473 8411.885 7925.094 20.9
11158.947 602.967 196795.691 10633.743 10045.884 24.2
11465.790 650.147 213277.172 12093.500 11811.939 25.5
 10932.175 587.714 225461.692 12120.830 11739.099 25.3
11316.738 548.725 241997.639 11733.969 11287.667 24.3
11553.263 540.275 257911.489 12060.931 11764.190 24.1
12495.660 559.749 274912.709 12314.841 11844.684 24.3
12793.822 581.520 292229.245 13282.752 12991.656 25.0
11110.109 486.402 266301.630 11658.709 13080.485 20.1
12360.555 515.683 269202.925 11231.151 9902.502 24.9
15103.065 693.463 313517.164 14395.261 14019.009 26.2
15661.334 754.454 320155.878 15422.872 15508.411 26.7
231,243.2 11,081.7 4,923,816.6 230,411.1 223,821.1 689.9

238984.442
231,243.2
11,081.7 11554.445281195 21.54595215111 15634.409255

4,923,816.565 0.0312
230,411.123 0.0654
223,821.079 -0.0570
0.8083
54.000 21.54595215111 15634.409255
11554.445281

689.901
238984.442
231243.236
11081.659

21.545952151112 15634.40925509 -13169.53459

689.9007 11554.44528119 8814.1297149
238984.4420
X 231243.2356
11081.6595
1 1.06 0.0404709205

0.19023618893 0.4361607375
0.000162509064 0.0127479043
0.000194340864 0.0139406192
0.006842795165 0.0827211893

0.071603215193
 5.13183935764
-4.08525645854
9.771177401185
e e^2 Yt-Yprom Yes-Yprom (Yt-Yprom)^2 (Yes-Yprom)^2
0.2 0.037 -8.4 -8.6 70.613 73.882
0.1 0.021 -7.7 -7.9 59.681 61.933
0.1 0.004 -7.3 -7.3 53.085 54.013
0.4 0.176 -6.3 -6.7 39.662 45.117
2.9 8.642 -2.6 -5.5 6.787 30.746
1.5 2.162 -1.4 -2.9 1.946 8.209
0.1 0.003 -2.0 -2.1 4.176 4.418
-2.2 4.806 -4.9 -2.7 24.100 7.382
-0.9 0.862 -6.3 -5.3 39.216 28.451
0.4 0.195 -5.3 -5.8 28.556 33.477
1.7 2.836 -3.1 -4.8 9.600 22.873
2.2 4.682 -0.7 -2.9 0.534 8.378
1.2 1.526 -0.3 -1.5 0.091 2.360
0.6 0.331 -1.8 -2.4 3.216 5.609
0.4 0.197 -1.7 -2.2 2.927 4.645
-1.6 2.710 -3.8 -2.2 14.735 4.807
-1.2 1.392 -4.3 -3.1 18.091 9.446
-1.5 2.317 -4.7 -3.1 21.754 9.872
-1.5 2.340 -7.3 -5.7 52.672 32.806
1.8 3.271 -6.4 -8.2 40.963 67.386
-1.4 1.826 -8.1 -6.8 65.805 45.707
-0.2 0.054 -7.7 -7.5 59.341 55.831
0.7 0.501 -6.7 -7.4 44.626 54.581
0.3 0.103 -5.7 -6.0 32.074 35.820
0.8 0.650 -3.5 -4.3 12.331 18.643
-0.8 0.647 -3.6 -2.8 13.222 8.020
-0.6 0.315 -3.9 -3.3 15.244 11.176
0.4 0.153 -2.6 -3.0 6.909 9.119
0.9 0.757 -1.9 -2.8 3.667 7.755
1.2 1.398 -0.8 -2.0 0.592 3.810
-1.7 3.053 -2.6 -0.8 6.623 0.683
-2.5 6.029 -5.0 -2.5 24.819 6.383
-1.7 2.922 -5.5 -3.8 29.845 14.090
-1.1 1.216 -5.3 -4.2 28.061 17.595
-1.5 2.209 -5.3 -3.8 28.190 14.617
-1.1 1.177 -4.6 -3.5 20.716 12.018
-0.7 0.468 -3.1 -2.4 9.679 5.892
-0.7 0.433 -1.5 -0.8 2.115 0.634
0.6 0.312 1.6 1.0 2.497 1.043
4.3 18.341 6.3 2.1 40.276 4.259
1.6 2.459 9.2 7.6 84.447 58.084
-3.1 9.568 6.7 9.8 45.334 96.554
2.4 5.884 10.5 8.1 110.726 65.559
1.7 2.940 13.1 11.4 171.717 129.722
-0.4 0.164 12.3 12.8 152.415 162.584
 -1.9 3.585 10.6 12.5 112.760 156.558
-0.8 0.673 10.7 11.5 114.043 132.232
-1.0 1.062 10.3 11.3 105.238 127.444
0.0 0.002 11.5 11.6 132.815 133.725
-1.1 1.111 11.2 12.2 124.422 149.047
0.2 0.044 7.5 7.3 56.998 53.881
0.5 0.258 12.6 12.1 158.636 146.088
1.1 1.311 14.6 13.4 211.905 179.886
0.9 0.771 14.8 13.9 219.824 194.564
0.0 110.9 0.0 0.0 2,740.3 2,629.4

94.49364021593
9.720783930112

-13169.5346 8957.12157 110.903093 2.218061866586 1.489315905571

50

1.489315905571

-13169.5346 8957.12157 11443.5422 0.990401694704

11554.4453

8957.12157 8814.129715 2629.41247 0.959529079536

2740.31557

0.957100824