Instalar paquetes y llamar librerías

#install.packages("WDI")
#install.packages("wbstats")
#install.packages("tidyverse")
#install.packages("plm")
#install.packages("gplots")
library(WDI)
library(wbstats)
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.4     ✔ readr     2.1.5
## ✔ forcats   1.0.0     ✔ stringr   1.5.1
## ✔ ggplot2   3.4.4     ✔ tibble    3.2.1
## ✔ lubridate 1.9.3     ✔ tidyr     1.3.1
## ✔ purrr     1.0.2     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(plm)
## 
## Attaching package: 'plm'
## 
## The following objects are masked from 'package:dplyr':
## 
##     between, lag, lead
library(gplots)
## 
## Attaching package: 'gplots'
## 
## The following object is masked from 'package:stats':
## 
##     lowess

Obtener información de varios países

gpd_data <- wb_data(country=c("MX", "EC", "CA"), indicator="NY.GDP.PCAP.CD", start_date=1950, end_date=2023)
gpd_data
## # A tibble: 189 × 9
##    iso2c iso3c country  date NY.GDP.PCAP.CD unit  obs_status footnote
##    <chr> <chr> <chr>   <dbl>          <dbl> <chr> <chr>      <chr>   
##  1 CA    CAN   Canada   1960          2259. <NA>  <NA>       <NA>    
##  2 CA    CAN   Canada   1961          2240. <NA>  <NA>       <NA>    
##  3 CA    CAN   Canada   1962          2269. <NA>  <NA>       <NA>    
##  4 CA    CAN   Canada   1963          2374. <NA>  <NA>       <NA>    
##  5 CA    CAN   Canada   1964          2555. <NA>  <NA>       <NA>    
##  6 CA    CAN   Canada   1965          2770. <NA>  <NA>       <NA>    
##  7 CA    CAN   Canada   1966          3047. <NA>  <NA>       <NA>    
##  8 CA    CAN   Canada   1967          3217. <NA>  <NA>       <NA>    
##  9 CA    CAN   Canada   1968          3463. <NA>  <NA>       <NA>    
## 10 CA    CAN   Canada   1969          3764. <NA>  <NA>       <NA>    
## # ℹ 179 more rows
## # ℹ 1 more variable: last_updated <date>

Genera un conjunto de datos de panel

panel <- select(gpd_data, country, date, NY.GDP.PCAP.CD)
panel
## # A tibble: 189 × 3
##    country  date NY.GDP.PCAP.CD
##    <chr>   <dbl>          <dbl>
##  1 Canada   1960          2259.
##  2 Canada   1961          2240.
##  3 Canada   1962          2269.
##  4 Canada   1963          2374.
##  5 Canada   1964          2555.
##  6 Canada   1965          2770.
##  7 Canada   1966          3047.
##  8 Canada   1967          3217.
##  9 Canada   1968          3463.
## 10 Canada   1969          3764.
## # ℹ 179 more rows

R Script “Panel” para obtener Indicadores del Banco Mundial

Equipo 4 Comercio Banco Mundial

#Industrialización, inflación, exportación
comercio_data <- wb_data(country=c("US", "CN", "IR", "UA"), indicator=c("FP.CPI.TOTL.ZG", "NE.EXP.GNFS.ZS", "NV.IND.MANF.ZS"), start_date=1970, end_date=2023)
comercio_data
## # A tibble: 212 × 7
##    iso2c iso3c country  date FP.CPI.TOTL.ZG NE.EXP.GNFS.ZS NV.IND.MANF.ZS
##    <chr> <chr> <chr>   <dbl>          <dbl>          <dbl>          <dbl>
##  1 CN    CHN   China    1970             NA           2.49             NA
##  2 CN    CHN   China    1971             NA           2.79             NA
##  3 CN    CHN   China    1972             NA           3.25             NA
##  4 CN    CHN   China    1973             NA           4.24             NA
##  5 CN    CHN   China    1974             NA           4.93             NA
##  6 CN    CHN   China    1975             NA           4.70             NA
##  7 CN    CHN   China    1976             NA           4.51             NA
##  8 CN    CHN   China    1977             NA           4.30             NA
##  9 CN    CHN   China    1978             NA           4.56             NA
## 10 CN    CHN   China    1979             NA           5.16             NA
## # ℹ 202 more rows
  • FP.CPI.TOTL.ZG = Inflación, precios al consumidor % anual
  • NE.EXP.GNFS.ZS = Exportaciones de bienes y servicios % del PIB
  • NV.IND.MANF.ZS = Industrialización, valor agregado % del PIB

Ejercicio 2. Conjunto de Datos de Panel

panel_comercio <- select(comercio_data, country, date, FP.CPI.TOTL.ZG, NE.EXP.GNFS.ZS, NV.IND.MANF.ZS )
panel_comercio <- subset(panel_comercio, date == 1990 | date == 2000 | date == 2010 | date == 2020)
panel_comercio <- pdata.frame(panel_comercio, index = c("country", "date"))
panel_comercio
##                                    country date FP.CPI.TOTL.ZG NE.EXP.GNFS.ZS
## China-1990                           China 1990      3.0522901      12.451603
## China-2000                           China 2000      0.3478112      20.893697
## China-2010                           China 2010      3.1753248      27.185333
## China-2020                           China 2020      2.4194219      18.586139
## Iran, Islamic Rep.-1990 Iran, Islamic Rep. 1990      7.6276749      13.278742
## Iran, Islamic Rep.-2000 Iran, Islamic Rep. 2000     14.4767513      21.467058
## Iran, Islamic Rep.-2010 Iran, Islamic Rep. 2010     10.0893629      24.399653
## Iran, Islamic Rep.-2020 Iran, Islamic Rep. 2020     30.5941390      19.424609
## Ukraine-1990                       Ukraine 1990             NA      27.664671
## Ukraine-2000                       Ukraine 2000     28.2030972      60.297057
## Ukraine-2010                       Ukraine 2010      9.3729311      46.456538
## Ukraine-2020                       Ukraine 2020      2.7324921      38.821646
## United States-1990           United States 1990      5.3979564       9.254732
## United States-2000           United States 2000      3.3768573      10.692777
## United States-2010           United States 2010      1.6400434      12.341361
## United States-2020           United States 2020      1.2335844      10.209229
##                         NV.IND.MANF.ZS
## China-1990                          NA
## China-2000                          NA
## China-2010                    31.61282
## China-2020                    26.28517
## Iran, Islamic Rep.-1990       14.51243
## Iran, Islamic Rep.-2000       16.63923
## Iran, Islamic Rep.-2010       12.78391
## Iran, Islamic Rep.-2020       21.13949
## Ukraine-1990                        NA
## Ukraine-2000                  17.38735
## Ukraine-2010                  13.09575
## Ukraine-2020                  10.10138
## United States-1990                  NA
## United States-2000            15.11507
## United States-2010            11.90609
## United States-2020            10.62906
#Na's = reemplazar por el promedio
panel_comercio$NV.IND.MANF.ZS[is.na(panel_comercio$NV.IND.MANF.ZS)]<-mean(panel_comercio$NV.IND.MANF.ZS,na.rm=TRUE)
panel_comercio$FP.CPI.TOTL.ZG [is.na(panel_comercio$FP.CPI.TOTL.ZG)]<-mean(panel_comercio$FP.CPI.TOTL.ZG
,na.rm=TRUE)
panel_comercio
##                                    country date FP.CPI.TOTL.ZG NE.EXP.GNFS.ZS
## China-1990                           China 1990      3.0522901      12.451603
## China-2000                           China 2000      0.3478112      20.893697
## China-2010                           China 2010      3.1753248      27.185333
## China-2020                           China 2020      2.4194219      18.586139
## Iran, Islamic Rep.-1990 Iran, Islamic Rep. 1990      7.6276749      13.278742
## Iran, Islamic Rep.-2000 Iran, Islamic Rep. 2000     14.4767513      21.467058
## Iran, Islamic Rep.-2010 Iran, Islamic Rep. 2010     10.0893629      24.399653
## Iran, Islamic Rep.-2020 Iran, Islamic Rep. 2020     30.5941390      19.424609
## Ukraine-1990                       Ukraine 1990      8.2493159      27.664671
## Ukraine-2000                       Ukraine 2000     28.2030972      60.297057
## Ukraine-2010                       Ukraine 2010      9.3729311      46.456538
## Ukraine-2020                       Ukraine 2020      2.7324921      38.821646
## United States-1990           United States 1990      5.3979564       9.254732
## United States-2000           United States 2000      3.3768573      10.692777
## United States-2010           United States 2010      1.6400434      12.341361
## United States-2020           United States 2020      1.2335844      10.209229
##                         NV.IND.MANF.ZS
## China-1990                    16.76731
## China-2000                    16.76731
## China-2010                    31.61282
## China-2020                    26.28517
## Iran, Islamic Rep.-1990       14.51243
## Iran, Islamic Rep.-2000       16.63923
## Iran, Islamic Rep.-2010       12.78391
## Iran, Islamic Rep.-2020       21.13949
## Ukraine-1990                  16.76731
## Ukraine-2000                  17.38735
## Ukraine-2010                  13.09575
## Ukraine-2020                  10.10138
## United States-1990            16.76731
## United States-2000            15.11507
## United States-2010            11.90609
## United States-2020            10.62906

Tarea 2. Gráficas de Heterogeneidad

Gráfica de Exportación

plotmeans(NE.EXP.GNFS.ZS ~ country, data = panel_comercio,
          main = "Heterogeneidad entre países",
                      xlab = "Año", ylab = "Exportación",
                      barcol = "red")
## Warning in arrows(x, li, x, pmax(y - gap, li), col = barcol, lwd = lwd, :
## zero-length arrow is of indeterminate angle and so skipped
## Warning in arrows(x, ui, x, pmin(y + gap, ui), col = barcol, lwd = lwd, :
## zero-length arrow is of indeterminate angle and so skipped

En la gráfica de exportaciones de bienes y servicios, utilizando un promedio ponderado y un nivel de confianza del 95%, observamos picos significativos. La gráfica no es horizontal, lo que indica que los intervalos de confianza varían notablemente entre los países. Sin embargo, China e Irán muestran intervalos casi idénticos, con una media cercana al 20%.

En este contexto, la heterogeneidad refleja que hay inestabilidad o volatilidad en las exportaciones, lo cual puede afectar para la planificación económica y comercial.

Gráfica de Inflación

plotmeans(FP.CPI.TOTL.ZG ~ country, data = panel_comercio,
          main = "Heterogeneidad entre países",
                      xlab = "Año", ylab = "Inflación",
                      barcol = "red")

La siguiente gráfica muestra la inflación en los precios de los consumidores, utilizando la mediana anualizada. También observamos picos en la gráfica, y ahora China y Estados Unidos muestran un intervalo de confianza similar.

Los resultados sugieren que la inflación en los precios de los consumidores varía entre los países, demostrando así que es heterogénea.

Gráfica de Industrialización

plotmeans(NV.IND.MANF.ZS ~ country, data = panel_comercio,
          main = "Heterogeneidad entre países",
                      xlab = "Año", ylab = "Industrialización",
                      barcol = "red")

Por último, la siguiente gráfica mide la contribución del sector manufacturero al Producto Interno Bruto, utilizando el porcentaje del promedio ponderado de cada país. Observamos variación en la gráfica, excepto al final, donde es horizontal, indicando que los intervalos de Ucrania y Estados Unidos son muy similares. La variación en la gráfica indica diferencias en la contribución del sector manufacturero entre los países. La heterogeneidad en este contexto podría considerarse ligeramente constante.

Ejercicio 3. Modelos con Indicadores del Banco Mundial

Modelo 1. Regresión Agrupada (pooled)

pooled <- plm(NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG, data= panel_comercio, model="pooling")
summary(pooled)
## Pooling Model
## 
## Call:
## plm(formula = NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG, 
##     data = panel_comercio, model = "pooling")
## 
## Balanced Panel: n = 4, T = 4, N = 16
## 
## Residuals:
##     Min.  1st Qu.   Median  3rd Qu.     Max. 
## -20.3587  -8.7484  -3.7500   5.6762  21.8281 
## 
## Coefficients:
##                Estimate Std. Error t-value Pr(>|t|)  
## (Intercept)    19.32268   11.13593  1.7352  0.10634  
## NV.IND.MANF.ZS -0.13559    0.62589 -0.2166  0.83186  
## FP.CPI.TOTL.ZG  0.76246    0.38585  1.9761  0.06976 .
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Total Sum of Squares:    3093.4
## Residual Sum of Squares: 2378.9
## R-Squared:      0.231
## Adj. R-Squared: 0.11269
## F-statistic: 1.95251 on 2 and 13 DF, p-value: 0.18135

Modelo 2. Efectos Fijos (within)

within <- plm(NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG, data= panel_comercio, model="within")
summary(within)
## Oneway (individual) effect Within Model
## 
## Call:
## plm(formula = NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG, 
##     data = panel_comercio, model = "within")
## 
## Balanced Panel: n = 4, T = 4, N = 16
## 
## Residuals:
##      Min.   1st Qu.    Median   3rd Qu.      Max. 
## -13.49706  -2.17112   0.51032   3.02790   8.29901 
## 
## Coefficients:
##                 Estimate Std. Error t-value Pr(>|t|)
## NV.IND.MANF.ZS -0.013969   0.530951 -0.0263   0.9795
## FP.CPI.TOTL.ZG  0.543505   0.322619  1.6847   0.1230
## 
## Total Sum of Squares:    746.1
## Residual Sum of Squares: 541.05
## R-Squared:      0.27483
## Adj. R-Squared: -0.087758
## F-statistic: 1.89492 on 2 and 10 DF, p-value: 0.20054

Prueba pF

pFtest(within, pooled)
## 
##  F test for individual effects
## 
## data:  NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG
## F = 11.323, df1 = 3, df2 = 10, p-value = 0.001483
## alternative hypothesis: significant effects
#Resultado indica modelos significantes. Nuestro mejor modelo es el agrupado debido al resultado de la r cuadrada ajustada.

Modelo 3. Efectos Aleatorios (random) - Método walhus

walhus <- plm(NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG, data= panel_comercio, model="random", random.method="walhus")
summary(walhus)
## Oneway (individual) effect Random Effect Model 
##    (Wallace-Hussain's transformation)
## 
## Call:
## plm(formula = NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG, 
##     data = panel_comercio, model = "random", random.method = "walhus")
## 
## Balanced Panel: n = 4, T = 4, N = 16
## 
## Effects:
##                   var std.dev share
## idiosyncratic  47.251   6.874 0.318
## individual    101.428  10.071 0.682
## theta: 0.677
## 
## Residuals:
##     Min.  1st Qu.   Median  3rd Qu.     Max. 
## -11.3695  -4.6894  -0.8683   5.5393  13.3124 
## 
## Coefficients:
##                 Estimate Std. Error z-value Pr(>|z|)  
## (Intercept)    19.522835   9.587209  2.0363  0.04172 *
## NV.IND.MANF.ZS -0.064129   0.500120 -0.1282  0.89797  
## FP.CPI.TOTL.ZG  0.592957   0.304645  1.9464  0.05161 .
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Total Sum of Squares:    990.96
## Residual Sum of Squares: 737.68
## R-Squared:      0.25559
## Adj. R-Squared: 0.14107
## Chisq: 4.46357 on 2 DF, p-value: 0.10734

Modelo 3.1. Efectos Aleatorios (random) - Método amemiya

amemiya <- plm(NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG, data= panel_comercio, model="random", random.method="amemiya")
summary(amemiya)
## Oneway (individual) effect Random Effect Model 
##    (Amemiya's transformation)
## 
## Call:
## plm(formula = NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG, 
##     data = panel_comercio, model = "random", random.method = "amemiya")
## 
## Balanced Panel: n = 4, T = 4, N = 16
## 
## Effects:
##                   var std.dev share
## idiosyncratic  45.087   6.715 0.296
## individual    107.467  10.367 0.704
## theta: 0.6919
## 
## Residuals:
##      Min.   1st Qu.    Median   3rd Qu.      Max. 
## -11.19960  -4.57480  -0.81202   5.56180  13.10955 
## 
## Coefficients:
##                Estimate Std. Error z-value Pr(>|z|)  
## (Intercept)    19.49533    9.67140  2.0158  0.04382 *
## NV.IND.MANF.ZS -0.06062    0.49747 -0.1219  0.90301  
## FP.CPI.TOTL.ZG  0.58916    0.30297  1.9446  0.05182 .
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Total Sum of Squares:    968.93
## Residual Sum of Squares: 720.09
## R-Squared:      0.25682
## Adj. R-Squared: 0.14248
## Chisq: 4.49229 on 2 DF, p-value: 0.10581

Modelo 3.2 Efectos Aleatorios (random) - Método nerlove

nerlove <- plm(NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG, data= panel_comercio, model="random", random.method="nerlove")
summary(nerlove)
## Oneway (individual) effect Random Effect Model 
##    (Nerlove's transformation)
## 
## Call:
## plm(formula = NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG, 
##     data = panel_comercio, model = "random", random.method = "nerlove")
## 
## Balanced Panel: n = 4, T = 4, N = 16
## 
## Effects:
##                   var std.dev share
## idiosyncratic  33.816   5.815 0.176
## individual    158.318  12.582 0.824
## theta: 0.7749
## 
## Residuals:
##      Min.   1st Qu.    Median   3rd Qu.      Max. 
## -10.29388  -3.93960  -0.47956   5.00513  11.93748 
## 
## Coefficients:
##                Estimate Std. Error z-value Pr(>|z|)  
## (Intercept)    19.33851   10.64463  1.8167  0.06926 .
## NV.IND.MANF.ZS -0.04169    0.48394 -0.0861  0.93135  
## FP.CPI.TOTL.ZG  0.56969    0.29442  1.9350  0.05300 .
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Total Sum of Squares:    865.09
## Residual Sum of Squares: 636.95
## R-Squared:      0.26371
## Adj. R-Squared: 0.15044
## Chisq: 4.65618 on 2 DF, p-value: 0.097482

Prueba de Hausman

phtest(walhus,within)
## 
##  Hausman Test
## 
## data:  NE.EXP.GNFS.ZS ~ NV.IND.MANF.ZS + FP.CPI.TOTL.ZG
## chisq = 0.12456, df = 2, p-value = 0.9396
## alternative hypothesis: one model is inconsistent
#el mejor modelo de los datos de panel es el de efectos aleatorios por el método Walhus debido al resultado de la r cuadrada ajustada más cercano al 1.00.
LS0tCnRpdGxlOiAiUGFuZWwgZGUgRGF0b3MiCmF1dGhvcjogIkdlcmFyZG8gR2FyemEgLSBBMDEzODMyODcsIERhbmllbGEgR2FyemEgLSBBMDE3MjEwNzEsIFJhcXVlbCBHYXJ6YSAtIEEwMDgzMDIwMyIKZGF0ZTogIjIwMjQtMDItMTMiCm91dHB1dDogCiAgaHRtbF9kb2N1bWVudDoKICAgIHRvYzogVFJVRQogICAgdG9jX2Zsb2F0OiBUUlVFCiAgICBjb2RlX2Rvd25sb2FkOiBUUlVFCi0tLQoKIVtdKGljZWdpZi5naWYpCgpgYGB7ciBzZXR1cCwgaW5jbHVkZT1GQUxTRX0Ka25pdHI6Om9wdHNfY2h1bmskc2V0KGVjaG8gPSBUUlVFKQpgYGAKCiMgSW5zdGFsYXIgcGFxdWV0ZXMgeSBsbGFtYXIgbGlicmVyw61hcwpgYGB7cn0KI2luc3RhbGwucGFja2FnZXMoIldESSIpCiNpbnN0YWxsLnBhY2thZ2VzKCJ3YnN0YXRzIikKI2luc3RhbGwucGFja2FnZXMoInRpZHl2ZXJzZSIpCiNpbnN0YWxsLnBhY2thZ2VzKCJwbG0iKQojaW5zdGFsbC5wYWNrYWdlcygiZ3Bsb3RzIikKbGlicmFyeShXREkpCmxpYnJhcnkod2JzdGF0cykKbGlicmFyeSh0aWR5dmVyc2UpCmxpYnJhcnkocGxtKQpsaWJyYXJ5KGdwbG90cykKYGBgCiMgT2J0ZW5lciBpbmZvcm1hY2nDs24gZGUgdmFyaW9zIHBhw61zZXMKYGBge3J9CmdwZF9kYXRhIDwtIHdiX2RhdGEoY291bnRyeT1jKCJNWCIsICJFQyIsICJDQSIpLCBpbmRpY2F0b3I9Ik5ZLkdEUC5QQ0FQLkNEIiwgc3RhcnRfZGF0ZT0xOTUwLCBlbmRfZGF0ZT0yMDIzKQpncGRfZGF0YQpgYGAKCiMgR2VuZXJhIHVuIGNvbmp1bnRvIGRlIGRhdG9zIGRlIHBhbmVsCmBgYHtyfQpwYW5lbCA8LSBzZWxlY3QoZ3BkX2RhdGEsIGNvdW50cnksIGRhdGUsIE5ZLkdEUC5QQ0FQLkNEKQpwYW5lbApgYGAKCiMgUiBTY3JpcHQgIlBhbmVsIiBwYXJhIG9idGVuZXIgSW5kaWNhZG9yZXMgZGVsIEJhbmNvIE11bmRpYWwKIyMgRXF1aXBvIDQgQ29tZXJjaW8gQmFuY28gTXVuZGlhbApgYGB7cn0KI0luZHVzdHJpYWxpemFjacOzbiwgaW5mbGFjacOzbiwgZXhwb3J0YWNpw7NuCmNvbWVyY2lvX2RhdGEgPC0gd2JfZGF0YShjb3VudHJ5PWMoIlVTIiwgIkNOIiwgIklSIiwgIlVBIiksIGluZGljYXRvcj1jKCJGUC5DUEkuVE9UTC5aRyIsICJORS5FWFAuR05GUy5aUyIsICJOVi5JTkQuTUFORi5aUyIpLCBzdGFydF9kYXRlPTE5NzAsIGVuZF9kYXRlPTIwMjMpCmNvbWVyY2lvX2RhdGEKYGBgCiAKIAotIEZQLkNQSS5UT1RMLlpHID0gSW5mbGFjacOzbiwgcHJlY2lvcyBhbCBjb25zdW1pZG9yICUgYW51YWwgICAgICAgIAotIE5FLkVYUC5HTkZTLlpTID0gRXhwb3J0YWNpb25lcyBkZSBiaWVuZXMgeSBzZXJ2aWNpb3MgJSBkZWwgUElCICAgICAgICAKLSBOVi5JTkQuTUFORi5aUyA9IEluZHVzdHJpYWxpemFjacOzbiwgdmFsb3IgYWdyZWdhZG8gJSBkZWwgUElCICAgICAgICAKCiMgRWplcmNpY2lvIDIuIENvbmp1bnRvIGRlIERhdG9zIGRlIFBhbmVsCmBgYHtyfQpwYW5lbF9jb21lcmNpbyA8LSBzZWxlY3QoY29tZXJjaW9fZGF0YSwgY291bnRyeSwgZGF0ZSwgRlAuQ1BJLlRPVEwuWkcsIE5FLkVYUC5HTkZTLlpTLCBOVi5JTkQuTUFORi5aUyApCnBhbmVsX2NvbWVyY2lvIDwtIHN1YnNldChwYW5lbF9jb21lcmNpbywgZGF0ZSA9PSAxOTkwIHwgZGF0ZSA9PSAyMDAwIHwgZGF0ZSA9PSAyMDEwIHwgZGF0ZSA9PSAyMDIwKQpwYW5lbF9jb21lcmNpbyA8LSBwZGF0YS5mcmFtZShwYW5lbF9jb21lcmNpbywgaW5kZXggPSBjKCJjb3VudHJ5IiwgImRhdGUiKSkKcGFuZWxfY29tZXJjaW8KCiNOYSdzID0gcmVlbXBsYXphciBwb3IgZWwgcHJvbWVkaW8KcGFuZWxfY29tZXJjaW8kTlYuSU5ELk1BTkYuWlNbaXMubmEocGFuZWxfY29tZXJjaW8kTlYuSU5ELk1BTkYuWlMpXTwtbWVhbihwYW5lbF9jb21lcmNpbyROVi5JTkQuTUFORi5aUyxuYS5ybT1UUlVFKQpwYW5lbF9jb21lcmNpbyRGUC5DUEkuVE9UTC5aRyBbaXMubmEocGFuZWxfY29tZXJjaW8kRlAuQ1BJLlRPVEwuWkcpXTwtbWVhbihwYW5lbF9jb21lcmNpbyRGUC5DUEkuVE9UTC5aRwosbmEucm09VFJVRSkKcGFuZWxfY29tZXJjaW8KYGBgCgojIFRhcmVhIDIuIEdyw6FmaWNhcyBkZSBIZXRlcm9nZW5laWRhZAoKCiMjIEdyw6FmaWNhIGRlIEV4cG9ydGFjacOzbgpgYGB7cn0KcGxvdG1lYW5zKE5FLkVYUC5HTkZTLlpTIH4gY291bnRyeSwgZGF0YSA9IHBhbmVsX2NvbWVyY2lvLAogICAgICAgICAgbWFpbiA9ICJIZXRlcm9nZW5laWRhZCBlbnRyZSBwYcOtc2VzIiwKICAgICAgICAgICAgICAgICAgICAgIHhsYWIgPSAiQcOxbyIsIHlsYWIgPSAiRXhwb3J0YWNpw7NuIiwKICAgICAgICAgICAgICAgICAgICAgIGJhcmNvbCA9ICJyZWQiKQpgYGAKCgogIEVuIGxhIGdyw6FmaWNhIGRlIGV4cG9ydGFjaW9uZXMgZGUgYmllbmVzIHkgc2VydmljaW9zLCB1dGlsaXphbmRvIHVuIHByb21lZGlvIHBvbmRlcmFkbyB5IHVuIG5pdmVsIGRlIGNvbmZpYW56YSBkZWwgOTUlLCBvYnNlcnZhbW9zIHBpY29zIHNpZ25pZmljYXRpdm9zLiBMYSBncsOhZmljYSBubyBlcyBob3Jpem9udGFsLCBsbyBxdWUgaW5kaWNhIHF1ZSBsb3MgaW50ZXJ2YWxvcyBkZSBjb25maWFuemEgdmFyw61hbiBub3RhYmxlbWVudGUgZW50cmUgbG9zIHBhw61zZXMuIFNpbiBlbWJhcmdvLCBDaGluYSBlIElyw6FuIG11ZXN0cmFuIGludGVydmFsb3MgY2FzaSBpZMOpbnRpY29zLCBjb24gdW5hIG1lZGlhIGNlcmNhbmEgYWwgMjAlLiAgICAgICAgCiAgCiAgRW4gZXN0ZSBjb250ZXh0bywgbGEgaGV0ZXJvZ2VuZWlkYWQgcmVmbGVqYSBxdWUgaGF5IGluZXN0YWJpbGlkYWQgbyB2b2xhdGlsaWRhZCBlbiBsYXMgZXhwb3J0YWNpb25lcywgbG8gY3VhbCBwdWVkZSBhZmVjdGFyIHBhcmEgbGEgcGxhbmlmaWNhY2nDs24gZWNvbsOzbWljYSB5IGNvbWVyY2lhbC4KCiMjIEdyw6FmaWNhIGRlIEluZmxhY2nDs24KYGBge3J9CnBsb3RtZWFucyhGUC5DUEkuVE9UTC5aRyB+IGNvdW50cnksIGRhdGEgPSBwYW5lbF9jb21lcmNpbywKICAgICAgICAgIG1haW4gPSAiSGV0ZXJvZ2VuZWlkYWQgZW50cmUgcGHDrXNlcyIsCiAgICAgICAgICAgICAgICAgICAgICB4bGFiID0gIkHDsW8iLCB5bGFiID0gIkluZmxhY2nDs24iLAogICAgICAgICAgICAgICAgICAgICAgYmFyY29sID0gInJlZCIpCmBgYAoKICBMYSBzaWd1aWVudGUgZ3LDoWZpY2EgbXVlc3RyYSBsYSBpbmZsYWNpw7NuIGVuIGxvcyBwcmVjaW9zIGRlIGxvcyBjb25zdW1pZG9yZXMsIHV0aWxpemFuZG8gbGEgbWVkaWFuYSBhbnVhbGl6YWRhLiBUYW1iacOpbiBvYnNlcnZhbW9zIHBpY29zIGVuIGxhIGdyw6FmaWNhLCB5IGFob3JhIENoaW5hIHkgRXN0YWRvcyBVbmlkb3MgbXVlc3RyYW4gdW4gaW50ZXJ2YWxvIGRlIGNvbmZpYW56YSBzaW1pbGFyLiAgICAgICAgCiAgCiAgTG9zIHJlc3VsdGFkb3Mgc3VnaWVyZW4gcXVlIGxhIGluZmxhY2nDs24gZW4gbG9zIHByZWNpb3MgZGUgbG9zIGNvbnN1bWlkb3JlcyB2YXLDrWEgZW50cmUgbG9zIHBhw61zZXMsIGRlbW9zdHJhbmRvIGFzw60gcXVlIGVzIGhldGVyb2fDqW5lYS4KCiMjIEdyw6FmaWNhIGRlIEluZHVzdHJpYWxpemFjacOzbgpgYGB7cn0KCnBsb3RtZWFucyhOVi5JTkQuTUFORi5aUyB+IGNvdW50cnksIGRhdGEgPSBwYW5lbF9jb21lcmNpbywKICAgICAgICAgIG1haW4gPSAiSGV0ZXJvZ2VuZWlkYWQgZW50cmUgcGHDrXNlcyIsCiAgICAgICAgICAgICAgICAgICAgICB4bGFiID0gIkHDsW8iLCB5bGFiID0gIkluZHVzdHJpYWxpemFjacOzbiIsCiAgICAgICAgICAgICAgICAgICAgICBiYXJjb2wgPSAicmVkIikKYGBgCgoKICBQb3Igw7psdGltbywgbGEgc2lndWllbnRlIGdyw6FmaWNhIG1pZGUgbGEgY29udHJpYnVjacOzbiBkZWwgc2VjdG9yIG1hbnVmYWN0dXJlcm8gYWwgUHJvZHVjdG8gSW50ZXJubyBCcnV0bywgdXRpbGl6YW5kbyBlbCBwb3JjZW50YWplIGRlbCBwcm9tZWRpbyBwb25kZXJhZG8gZGUgY2FkYSBwYcOtcy4gT2JzZXJ2YW1vcyB2YXJpYWNpw7NuIGVuIGxhIGdyw6FmaWNhLCBleGNlcHRvIGFsIGZpbmFsLCBkb25kZSBlcyBob3Jpem9udGFsLCBpbmRpY2FuZG8gcXVlIGxvcyBpbnRlcnZhbG9zIGRlIFVjcmFuaWEgeSBFc3RhZG9zIFVuaWRvcyBzb24gbXV5IHNpbWlsYXJlcy4KTGEgdmFyaWFjacOzbiBlbiBsYSBncsOhZmljYSBpbmRpY2EgZGlmZXJlbmNpYXMgZW4gbGEgY29udHJpYnVjacOzbiBkZWwgc2VjdG9yIG1hbnVmYWN0dXJlcm8gZW50cmUgbG9zIHBhw61zZXMuIExhIGhldGVyb2dlbmVpZGFkIGVuIGVzdGUgY29udGV4dG8gcG9kcsOtYSBjb25zaWRlcmFyc2UgbGlnZXJhbWVudGUgY29uc3RhbnRlLiAKCiMgRWplcmNpY2lvIDMuIE1vZGVsb3MgY29uIEluZGljYWRvcmVzIGRlbCBCYW5jbyBNdW5kaWFsCgoKIyMgTW9kZWxvIDEuIFJlZ3Jlc2nDs24gQWdydXBhZGEgKHBvb2xlZCkKYGBge3J9CnBvb2xlZCA8LSBwbG0oTkUuRVhQLkdORlMuWlMgfiBOVi5JTkQuTUFORi5aUyArIEZQLkNQSS5UT1RMLlpHLCBkYXRhPSBwYW5lbF9jb21lcmNpbywgbW9kZWw9InBvb2xpbmciKQpzdW1tYXJ5KHBvb2xlZCkKYGBgCgojIyBNb2RlbG8gMi4gRWZlY3RvcyBGaWpvcyAod2l0aGluKQpgYGB7cn0Kd2l0aGluIDwtIHBsbShORS5FWFAuR05GUy5aUyB+IE5WLklORC5NQU5GLlpTICsgRlAuQ1BJLlRPVEwuWkcsIGRhdGE9IHBhbmVsX2NvbWVyY2lvLCBtb2RlbD0id2l0aGluIikKc3VtbWFyeSh3aXRoaW4pCmBgYAojIyBQcnVlYmEgcEYKYGBge3J9CnBGdGVzdCh3aXRoaW4sIHBvb2xlZCkKI1Jlc3VsdGFkbyBpbmRpY2EgbW9kZWxvcyBzaWduaWZpY2FudGVzLiBOdWVzdHJvIG1lam9yIG1vZGVsbyBlcyBlbCBhZ3J1cGFkbyBkZWJpZG8gYWwgcmVzdWx0YWRvIGRlIGxhIHIgY3VhZHJhZGEgYWp1c3RhZGEuCmBgYAojIyBNb2RlbG8gMy4gRWZlY3RvcyBBbGVhdG9yaW9zIChyYW5kb20pIC0gTcOpdG9kbyB3YWxodXMKYGBge3J9CndhbGh1cyA8LSBwbG0oTkUuRVhQLkdORlMuWlMgfiBOVi5JTkQuTUFORi5aUyArIEZQLkNQSS5UT1RMLlpHLCBkYXRhPSBwYW5lbF9jb21lcmNpbywgbW9kZWw9InJhbmRvbSIsIHJhbmRvbS5tZXRob2Q9IndhbGh1cyIpCnN1bW1hcnkod2FsaHVzKQpgYGAKCiMjIE1vZGVsbyAzLjEuIEVmZWN0b3MgQWxlYXRvcmlvcyAocmFuZG9tKSAtIE3DqXRvZG8gYW1lbWl5YQpgYGB7cn0KYW1lbWl5YSA8LSBwbG0oTkUuRVhQLkdORlMuWlMgfiBOVi5JTkQuTUFORi5aUyArIEZQLkNQSS5UT1RMLlpHLCBkYXRhPSBwYW5lbF9jb21lcmNpbywgbW9kZWw9InJhbmRvbSIsIHJhbmRvbS5tZXRob2Q9ImFtZW1peWEiKQpzdW1tYXJ5KGFtZW1peWEpCmBgYAoKIyMgTW9kZWxvIDMuMiBFZmVjdG9zIEFsZWF0b3Jpb3MgKHJhbmRvbSkgLSBNw6l0b2RvIG5lcmxvdmUKYGBge3J9Cm5lcmxvdmUgPC0gcGxtKE5FLkVYUC5HTkZTLlpTIH4gTlYuSU5ELk1BTkYuWlMgKyBGUC5DUEkuVE9UTC5aRywgZGF0YT0gcGFuZWxfY29tZXJjaW8sIG1vZGVsPSJyYW5kb20iLCByYW5kb20ubWV0aG9kPSJuZXJsb3ZlIikKc3VtbWFyeShuZXJsb3ZlKQpgYGAKIyMgUHJ1ZWJhIGRlIEhhdXNtYW4KYGBge3J9CnBodGVzdCh3YWxodXMsd2l0aGluKQojZWwgbWVqb3IgbW9kZWxvIGRlIGxvcyBkYXRvcyBkZSBwYW5lbCBlcyBlbCBkZSBlZmVjdG9zIGFsZWF0b3Jpb3MgcG9yIGVsIG3DqXRvZG8gV2FsaHVzIGRlYmlkbyBhbCByZXN1bHRhZG8gZGUgbGEgciBjdWFkcmFkYSBhanVzdGFkYSBtw6FzIGNlcmNhbm8gYWwgMS4wMC4KYGBgCgo=