Self-taught practice + university assignmentApplied Statistics for Finance — USAC (applied part)Individual work

R fundamentals with Guatemalan data

From vectors to ggplot2: annual inflation and July passive rate (2008–2023, Banco de Guatemala)

Problem

Learn R from scratch (vectors, matrices, factors, lists, data frames, Excel import, plots) and apply it to two Guatemalan economic series.

Data

DB_II.xlsx (INFLACION and TASA sheets; the file is not in the folder): Guatemala's annual July inflation and passive rate, 2008–2023, source Banco de Guatemala. Also mtcars (bundled with R) and a Gapminder xlsx.

Data source →

Methods

Tutorial series (Rafa González Gouveia): variables → vectors → matrices → factors → data frames → lists → Excel import → base and ggplot2 plots
Own applied scripts: Excel reading with readxl, column-name cleaning (leading spaces), histogram of annual inflation and frequency polygon of the passive rate (×100 from decimal to %)

Gallery

Tools

RRStudiotidyverse (dplyr, ggplot2)readxl

9 of 11 scripts follow a YouTube tutorial series (credited in each file); the two applied ones with Banco de Guatemala data are own work.