1 Gráfico evolución del PIB a precios corrientes

Dado que se pide una relación entre el tiempo (2005 hasta 2023) y el PIB de cada año, lo más conveniente es crear una relación en un plano de 2 dimensiones donde el tiempo (Año) corresponde al eje horizontal y el PIB al eje vertical.

1.1 Metodología

Lo más conveniente es simplificar toda la información de archivo excel a un dataframe, de tal manera que a cada Año le corresponda un valor de PIB. Así

Error in install.packages : Updating loaded packages
Error in install.packages : Updating loaded packages

Adjuntando el paquete: ‘plotly’

The following object is masked from ‘package:ggplot2’:

    last_plot

The following object is masked from ‘package:stats’:

    filter

The following object is masked from ‘package:graphics’:

    layout

2 Gráfico evolución del PIB a precios constantes

3 Gráfico evolución del ahorro / formación bruta de capital en el tiempo.

Error in install.packages : Updating loaded packages
Error in install.packages : Updating loaded packages

4 Comentarios

De acuerdo a los datos, podemos decir quese tiene correlación entre la evolución del PIB a nivel corriente y constante. La correlación es análoga en el caso del ahorro bruto y la formación bruta de capital

LS0tDQp0aXRsZTogIklFQ19UQVJFQV8xX0FORFJFU19TVUFSRVoiDQpvdXRwdXQ6DQogIGh0bWxfbm90ZWJvb2s6DQogICAgdG9jOiB0cnVlDQogICAgdG9jX2Zsb2F0OiB0cnVlDQogICAgbnVtYmVyX3NlY3Rpb25zOiB0cnVlDQogICAgdGhlbWU6IHNwYWNlbGFiICAjIEFwbGljYSBlbCBtb2RvIG9zY3VybyBlbiBSIE5vdGVib29rDQogIHBkZl9kb2N1bWVudDogZGVmYXVsdA0KICBodG1sX2RvY3VtZW50Og0KICAgIGRmX3ByaW50OiBwYWdlZA0KICAgIHRvYzogdHJ1ZQ0KICAgIHRvY19mbG9hdDogdHJ1ZQ0KICAgIG51bWJlcl9zZWN0aW9uczogdHJ1ZQ0KICAgIHRoZW1lOiBzcGFjZWxhYiAgIyBBcGxpY2EgZWwgbW9kbyBvc2N1cm8gZW4gbGEgdmVyc2nDs24gSFRNTA0KZGF0ZTogIjIwMjUtMDItMDYiDQotLS0NCg0KLS0tDQoNCi0tLQ0KDQojIEdyw6FmaWNvIGV2b2x1Y2nDs24gZGVsIFBJQiBhIHByZWNpb3MgY29ycmllbnRlcw0KDQpEYWRvIHF1ZSBzZSBwaWRlIHVuYSByZWxhY2nDs24gZW50cmUgZWwgdGllbXBvICgyMDA1IGhhc3RhIDIwMjMpIHkgZWwgUElCIGRlIGNhZGEgYcOxbywgbG8gbcOhcyBjb252ZW5pZW50ZSBlcyBjcmVhciB1bmEgcmVsYWNpw7NuIGVuIHVuIHBsYW5vIGRlIDIgZGltZW5zaW9uZXMgZG9uZGUgZWwgdGllbXBvIChBw7FvKSBjb3JyZXNwb25kZSBhbCBlamUgaG9yaXpvbnRhbCB5IGVsIFBJQiBhbCBlamUgdmVydGljYWwuDQoNCiMjIE1ldG9kb2xvZ8OtYQ0KDQpMbyBtw6FzIGNvbnZlbmllbnRlIGVzIHNpbXBsaWZpY2FyIHRvZGEgbGEgaW5mb3JtYWNpw7NuIGRlIGFyY2hpdm8gZXhjZWwgYSB1biBkYXRhZnJhbWUsIGRlIHRhbCBtYW5lcmEgcXVlIGEgY2FkYSBBw7FvIGxlIGNvcnJlc3BvbmRhIHVuIHZhbG9yIGRlIFBJQi4gQXPDrQ0KDQpgYGB7ciBlY2hvPUZBTFNFLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFLCBwYWdlZC5wcmludD1UUlVFfQ0KIyBJbnN0YWxhciB5IGNhcmdhciBsYXMgbGlicmVyw61hcyBuZWNlc2FyaWFzDQppbnN0YWxsLnBhY2thZ2VzKCJnZ3Bsb3QyIikNCmluc3RhbGwucGFja2FnZXMoInBsb3RseSIpDQoNCmxpYnJhcnkoZ2dwbG90MikNCmxpYnJhcnkocGxvdGx5KQ0KDQojIENyZWFyIGVsIERhdGFGcmFtZSBjb24gbG9zIGRhdG9zIGRlbCBQSUIgdG90YWwgKGV4dHJhw61kb3MgZGVsIEV4Y2VsKQ0KcGliX3RvdGFsIDwtIGRhdGEuZnJhbWUoDQogIEHDsW8gPSBjKDIwMDUsIDIwMDYsIDIwMDcsIDIwMDgsIDIwMDksIDIwMTAsIDIwMTEsIDIwMTIsIDIwMTMsIDIwMTQsIA0KICAgICAgICAgIDIwMTUsIDIwMTYsIDIwMTcsIDIwMTgsIDIwMTksIDIwMjAsIDIwMjEsIDIwMjIsIDIwMjMpLA0KICBQSUIgPSBjKDMzNzk1OCwgMzgxNjA0LCA0Mjg1MDYsIDQ3NjU1NCwgNTAxNTc0LCA1NDQwNjAsIDYxOTAyMywgNjY2NTA3LCANCiAgICAgICAgICA3MTQwOTMsIDc2MjkwMywgODA0NjkyLCA4NjM3ODIsIDkyMDQ3MSwgOTg3NzkxLCAxMDYwMDY4LCA5OTg0NzEsIA0KICAgICAgICAgIDExOTI2MzQsIDE0Njk3OTEsIDE1NzI0NTkpDQopDQoNCiMgQ3JlYXIgZWwgZ3LDoWZpY28gYmFzZSBjb24gZ2dwbG90Mg0KZ3JhZmljbyA8LSBnZ3Bsb3QocGliX3RvdGFsLCBhZXMoeCA9IEHDsW8sIHkgPSBQSUIsIHRleHQgPSBwYXN0ZSgiQcOxbzoiLCBBw7FvLCAiPGJyPlBJQjoiLCBQSUIpKSkgKw0KICBnZW9tX2xpbmUoY29sb3IgPSAiYmx1ZSIsIHNpemUgPSAxKSArICAgIyBMw61uZWEgYXp1bA0KICBnZW9tX3BvaW50KGNvbG9yID0gInJlZCIsIHNpemUgPSAzKSArICAgIyBQdW50b3Mgcm9qb3MgaW50ZXJhY3Rpdm9zDQogIGxhYnModGl0bGUgPSAiRXZvbHVjacOzbiBJbnRlcmFjdGl2YSBkZWwgUElCICgyMDA1LTIwMjMpIiwNCiAgICAgICB4ID0gIkHDsW8iLA0KICAgICAgIHkgPSAiUElCIChtaWxsb25lcyBkZSBDT1ApIikgKw0KICB0aGVtZV9taW5pbWFsKCkNCg0KIyBDb252ZXJ0aXIgZWwgZ3LDoWZpY28gZW4gaW50ZXJhY3Rpdm8gY29uIGdncGxvdGx5DQpncmFmaWNvX2ludGVyYWN0aXZvIDwtIGdncGxvdGx5KGdyYWZpY28sIHRvb2x0aXAgPSAidGV4dCIpDQoNCiMgTW9zdHJhciBlbCBncsOhZmljbyBlbiBSU3R1ZGlvDQpncmFmaWNvX2ludGVyYWN0aXZvDQoNCmh0bWx3aWRnZXRzOjpzYXZlV2lkZ2V0KGdyYWZpY29faW50ZXJhY3Rpdm8sICJncmFmaWNvX3BpYi5odG1sIiwgc2VsZmNvbnRhaW5lZCA9IFRSVUUpDQpicm93c2VVUkwoImdyYWZpY29fcGliLmh0bWwiKQ0KYGBgDQoNCiMgR3LDoWZpY28gZXZvbHVjacOzbiBkZWwgUElCIGEgcHJlY2lvcyBjb25zdGFudGVzDQoNCmBgYHtyIGVjaG89RkFMU0UsIG1lc3NhZ2U9VFJVRSwgd2FybmluZz1GQUxTRX0NCiMgQ3JlYXIgZWwgRGF0YUZyYW1lIGNvbiBsb3MgZGF0b3MgY29ycmVnaWRvcyBkZWwgUElCIGVuIHNlcmllcyBlbmNhZGVuYWRhcyBkZSB2b2x1bWVuDQpwaWJfdm9sdW1lbl9lbmNhZGVuYWRvIDwtIGRhdGEuZnJhbWUoDQogIEHDsW8gPSBjKDIwMDUsIDIwMDYsIDIwMDcsIDIwMDgsIDIwMDksIDIwMTAsIDIwMTEsIDIwMTIsIDIwMTMsIDIwMTQsIA0KICAgICAgICAgIDIwMTUsIDIwMTYsIDIwMTcsIDIwMTgsIDIwMTksIDIwMjAsIDIwMjEsIDIwMjIsIDIwMjMpLA0KICBQSUIgPSBjKDUxNDg1MywgNTQ5NDM1LCA1ODY0NTcsIDYwNTcxMywgNjEyNjE2LCA2NDAxNTEsIDY4NDYyOCwgNzExNDE1LCANCiAgICAgICAgICA3NDc5MzksIDc4MTU4OSwgODA0NjkyLCA4MjE0ODksIDgzMjY1NiwgODU0MDA4LCA4ODEyMjQsIDgxNzkwMCwgDQogICAgICAgICAgOTA2MjQzLCA5NzIyOTgsIDk3ODIzMykNCikNCg0KIyBDcmVhciBlbCBncsOhZmljbyBpbnRlcmFjdGl2bw0KZ3JhZmljb19waWJfdm9sdW1lbiA8LSBnZ3Bsb3QocGliX3ZvbHVtZW5fZW5jYWRlbmFkbywgYWVzKHggPSBBw7FvLCB5ID0gUElCLCB0ZXh0ID0gcGFzdGUoIkHDsW86IiwgQcOxbywgIjxicj5QSUI6IiwgUElCKSkpICsNCiAgZ2VvbV9saW5lKGNvbG9yID0gImJsdWUiLCBzaXplID0gMSkgKyAgICMgTMOtbmVhIGF6dWwNCiAgZ2VvbV9wb2ludChjb2xvciA9ICJibHVlIiwgc2l6ZSA9IDMpICsgICAjIFB1bnRvcyByb2pvcyBpbnRlcmFjdGl2b3MNCiAgbGFicyh0aXRsZSA9ICJFdm9sdWNpw7NuIEludGVyYWN0aXZhIGRlbCBQSUIgZW4gVm9sdW1lbiAoMjAwNS0yMDIzKSIsDQogICAgICAgeCA9ICJBw7FvIiwNCiAgICAgICB5ID0gIlBJQiAobWlsbG9uZXMgZGUgQ09QLCBlbmNhZGVuYWRvcykiKSArDQogIHRoZW1lX21pbmltYWwoKQ0KDQojIENvbnZlcnRpciBlbCBncsOhZmljbyBlbiBpbnRlcmFjdGl2byBjb24gZ2dwbG90bHkNCmdyYWZpY29fcGliX3ZvbHVtZW5faW50ZXJhY3Rpdm8gPC0gZ2dwbG90bHkoZ3JhZmljb19waWJfdm9sdW1lbiwgdG9vbHRpcCA9ICJ0ZXh0IikNCg0KIyBNb3N0cmFyIGVsIGdyw6FmaWNvIGludGVyYWN0aXZvIGVuIFJTdHVkaW8NCmdyYWZpY29fcGliX3ZvbHVtZW5faW50ZXJhY3Rpdm8NCg0KYGBgDQoNCiMgR3LDoWZpY28gZXZvbHVjacOzbiBkZWwgYWhvcnJvIC8gIGZvcm1hY2nDs24gYnJ1dGEgZGUgY2FwaXRhbCBlbiBlbCB0aWVtcG8uDQoNCmBgYHtyIGVjaG89RkFMU0UsIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0UsIHBhZ2VkLnByaW50PUZBTFNFfQ0KIyBJbnN0YWxhciB5IGNhcmdhciBsYXMgbGlicmVyw61hcyBuZWNlc2FyaWFzDQppbnN0YWxsLnBhY2thZ2VzKCJnZ3Bsb3QyIikNCmluc3RhbGwucGFja2FnZXMoInBsb3RseSIpDQoNCmxpYnJhcnkoZ2dwbG90MikNCmxpYnJhcnkocGxvdGx5KQ0KDQojIENyZWFyIGVsIERhdGFGcmFtZSBjb24gbG9zIGRhdG9zIGRlIEFob3JybyBCcnV0byB5IEZvcm1hY2nDs24gQnJ1dGEgZGUgQ2FwaXRhbA0KZGZfYWhvcnJvX2NhcGl0YWwgPC0gZGF0YS5mcmFtZSgNCiAgQcOxbyA9IGMoMjAwNSwgMjAwNiwgMjAwNywgMjAwOCwgMjAwOSwgMjAxMCwgMjAxMSwgMjAxMiwgMjAxMywgMjAxNCwgDQogICAgICAgICAgMjAxNSwgMjAxNiwgMjAxNywgMjAxOCwgMjAxOSwgMjAyMCwgMjAyMSwgMjAyMiwgMjAyMyksDQogIEFob3Jyb19CcnV0byA9IGMoNjE4MDgsIDczOTgzLCA4MTUyNywgOTUxOTIsIDk1NzU2LCAxMDI2MTYsIDEyMjIwOSwgMTI1MjcyLCANCiAgICAgICAgICAgICAgICAgICAgMTM4NTUzLCAxNDA3OTQsIDE1MDA3OSwgMTU2NjI5LCAxNjA4MzcsIDE3MDQzMCwgMTQ0MDg1LCANCiAgICAgICAgICAgICAgICAgICAgMTU1ODIwLCAxOTkxMDAsIDE3NzgwNCwgMjI1NjEwKSwNCiAgRm9ybWFjaW9uX0JydXRhX0NhcGl0YWwgPSBjKDczMTg5LCA4NzUzNiwgMTAwNTAzLCAxMTMwNDMsIDExMDI4NCwgMTE5MDg4LCANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDE0MjM0OCwgMTQ3MzI5LCAxODMxMjIsIDE5MTMwNSwgMjAwMTE2LCAxOTg4MTYsIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgMjA5MzY3LCAyMjY2NDksIDE5MDk4OSwgMjI1NjEwLCAyOTAxOTYsIDIxMzg5MSwgMjczMjgwKQ0KKQ0KDQojIENyZWFyIGVsIGdyw6FmaWNvIGludGVyYWN0aXZvDQpncmFmaWNvX2Fob3Jyb19jYXBpdGFsIDwtIGdncGxvdChkZl9haG9ycm9fY2FwaXRhbCwgYWVzKHggPSBBw7FvKSkgKw0KICBnZW9tX2xpbmUoYWVzKHkgPSBBaG9ycm9fQnJ1dG8sIGNvbG9yID0gIkFob3JybyBCcnV0byIpLCBzaXplID0gMSkgKw0KICBnZW9tX3BvaW50KGFlcyh5ID0gQWhvcnJvX0JydXRvLCBjb2xvciA9ICJBaG9ycm8gQnJ1dG8iKSwgc2l6ZSA9IDMpICsNCiAgZ2VvbV9saW5lKGFlcyh5ID0gRm9ybWFjaW9uX0JydXRhX0NhcGl0YWwsIGNvbG9yID0gIkZvcm1hY2nDs24gQnJ1dGEgZGUgQ2FwaXRhbCIpLCBzaXplID0gMSwgbGluZXR5cGUgPSAiZGFzaGVkIikgKw0KICBnZW9tX3BvaW50KGFlcyh5ID0gRm9ybWFjaW9uX0JydXRhX0NhcGl0YWwsIGNvbG9yID0gIkZvcm1hY2nDs24gQnJ1dGEgZGUgQ2FwaXRhbCIpLCBzaXplID0gMykgKw0KICBsYWJzKHRpdGxlID0gIkV2b2x1Y2nDs24gSW50ZXJhY3RpdmEgZGVsIEFob3JybyBCcnV0byB5IGxhIEZvcm1hY2nDs24gQnJ1dGEgZGUgQ2FwaXRhbCAoMjAwNS0yMDIzKSIsDQogICAgICAgeCA9ICJBw7FvIiwNCiAgICAgICB5ID0gIk1pbGxvbmVzIGRlIENPUCIpICsNCiAgc2NhbGVfY29sb3JfbWFudWFsKHZhbHVlcyA9IGMoIkFob3JybyBCcnV0byIgPSAiYmx1ZSIsICJGb3JtYWNpw7NuIEJydXRhIGRlIENhcGl0YWwiID0gInJlZCIpKSArDQogIHRoZW1lX21pbmltYWwoKQ0KDQojIENvbnZlcnRpciBlbCBncsOhZmljbyBlbiBpbnRlcmFjdGl2byBjb24gZ2dwbG90bHkNCmdyYWZpY29fYWhvcnJvX2NhcGl0YWxfaW50ZXJhY3Rpdm8gPC0gZ2dwbG90bHkoZ3JhZmljb19haG9ycm9fY2FwaXRhbCkgJT4lIGxheW91dCh3aWR0aCA9IDEwMDAsIGhlaWdodCA9IDYwMCwgeGF4aXMgPSBsaXN0KGR0aWNrID0gMSwgdGlja21vZGUgPSAnYXJyYXknLCB0aWNrdmFscyA9IGRmX2Fob3Jyb19jYXBpdGFsJEHDsW8sIHRpY2t0ZXh0ID0gZGZfYWhvcnJvX2NhcGl0YWwkQcOxbykpICU+JSBsYXlvdXQod2lkdGggPSAxMDAwLCBoZWlnaHQgPSA2MDApDQoNCiMgTW9zdHJhciBlbCBncsOhZmljbyBpbnRlcmFjdGl2byBlbiBSU3R1ZGlvDQpncmFmaWNvX2Fob3Jyb19jYXBpdGFsX2ludGVyYWN0aXZvDQpgYGANCg0KIyBDb21lbnRhcmlvcyANCg0KRGUgYWN1ZXJkbyBhIGxvcyBkYXRvcywgcG9kZW1vcyBkZWNpciBxdWVzZSB0aWVuZSBjb3JyZWxhY2nDs24gZW50cmUgbGEgZXZvbHVjacOzbiBkZWwgUElCIGEgbml2ZWwgY29ycmllbnRlIHkgY29uc3RhbnRlLiBMYSBjb3JyZWxhY2nDs24gZXMgYW7DoWxvZ2EgZW4gZWwgY2FzbyBkZWwgYWhvcnJvIGJydXRvIHkgbGEgZm9ybWFjacOzbiBicnV0YSBkZSBjYXBpdGFsXA0K