Una Serie de tiempo es una colección de obserbaciones sobre un determinado fenómeno, efectuadas en momento sucesivos, usualmente equiespaciados.
Algunos ejemplos de series de tiempo son: 1. Precios de acciones 2. Niveles de inventario 3. Rotación de personal 4. Ventas 5. PIB (GDP)
Más información: Libro R for Data Science (2e)
#install.packages("forecast")
library(forecast)
## Registered S3 method overwritten by 'quantmod':
## method from
## as.zoo.data.frame zoo
#install.packages("tidyverse")
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
Los siguientes datos de producción trimestral inician en el primer trimestre de 2020.
Se busca pronósticar la producción de los siguientes 5 trimestres.
produccion <- c(50,53,55,57,55,60)
ts <- ts(data=produccion, start = c(2020,1), frequency = 4)
ts
## Qtr1 Qtr2 Qtr3 Qtr4
## 2020 50 53 55 57
## 2021 55 60
ARIMA significa AutoRegressive Integrated Moving Average o Modelo Autorregresivo Integrado de Promedio Móvil.
arima <- auto.arima(ts)
arima
## Series: ts
## ARIMA(0,1,0)
##
## sigma^2 = 9.2: log likelihood = -12.64
## AIC=27.29 AICc=28.62 BIC=26.89
summary(arima)
## Series: ts
## ARIMA(0,1,0)
##
## sigma^2 = 9.2: log likelihood = -12.64
## AIC=27.29 AICc=28.62 BIC=26.89
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE ACF1
## Training set 1.675 2.76895 2.341667 2.933747 4.145868 0.3902778 -0.5152989
Series:ts
pronostico <- forecast(arima, level=c(95), h=5)
pronostico
## Point Forecast Lo 95 Hi 95
## 2021 Q3 60 54.05497 65.94503
## 2021 Q4 60 51.59246 68.40754
## 2022 Q1 60 49.70291 70.29709
## 2022 Q2 60 48.10995 71.89005
## 2022 Q3 60 46.70652 73.29348
library(readr)
lechita <- read_csv("C:/Users/melis/Downloads/Ventas_Históricas_Lechitas.csv")
#View(lechita)
lechita$Ventas...6 <- as.numeric(lechita$Ventas...6)
ts1 <- ts(data=lechita$Ventas...6, start= c(2017,1), frequency=12)
ts1
## Jan Feb Mar Apr May Jun Jul Aug
## 2017 32496.44 31287.28 33376.02 32949.77 34004.11 33757.89 32927.30 34324.12
## Sep Oct Nov Dec
## 2017 35151.28 36133.07 34799.91 34846.17
arima1 <- auto.arima(ts1)
arima1
## Series: ts1
## ARIMA(0,1,0)
##
## sigma^2 = 1204405: log likelihood = -92.62
## AIC=187.23 AICc=187.68 BIC=187.63
summary(arima1)
## Series: ts1
## ARIMA(0,1,0)
##
## sigma^2 = 1204405: log likelihood = -92.62
## AIC=187.23 AICc=187.68 BIC=187.63
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE ACF1
## Training set 198.5189 1050.732 872.7489 0.5408539 2.581043 NaN -0.3929139
pronostico1 <- forecast(arima1, level=c(95), h=12)
pronostico1
## Point Forecast Lo 95 Hi 95
## Jan 2018 34846.17 32695.20 36997.14
## Feb 2018 34846.17 31804.24 37888.10
## Mar 2018 34846.17 31120.58 38571.76
## Apr 2018 34846.17 30544.23 39148.11
## May 2018 34846.17 30036.46 39655.88
## Jun 2018 34846.17 29577.39 40114.95
## Jul 2018 34846.17 29155.24 40537.10
## Aug 2018 34846.17 28762.31 40930.03
## Sep 2018 34846.17 28393.26 41299.08
## Oct 2018 34846.17 28044.21 41648.13
## Nov 2018 34846.17 27712.21 41980.13
## Dec 2018 34846.17 27394.99 42297.35
plot(pronostico1)
El pronóstico realizado se basa en la serie de tiempo, la cual comienza a partir del mes 1 del año 2017 y con una frecuencia mensual. Se puede ver que las ventas pronosticadas se mantendrán igual, es decir, no tendrán ni una baja ni una subida.
#install.packages("finreportr")
library(finreportr)
Con la función “finreportr” podemos obtener la siguiente información - companyInfo(): Brinda información general como nombre, ubicación, ZIP, etc. - AnnualReports() : Brinda el nombre, fecha y número de acceso. - GetIncome(): Brinda el Estado de Resultados. - GetBalanceSheet(): Brinda el Balance General. - GetCashFlow(): Brinda el flujo de efectivo.
options(HTTPUserAgent = "a a@gmail.com")
CompanyInfo("JPM")
## company CIK SIC state state.inc FY.end street.address
## 1 JPMORGAN CHASE & CO 0000019617 6021 NY DE 1231 383 MADISON AVENUE
## city.state
## 1 NEW YORK NY 10017
AnnualReports("JPM")
## filing.name filing.date accession.no
## 1 10-K 2024-02-16 0000019617-24-000225
## 2 10-K 2023-02-21 0000019617-23-000231
## 3 10-K 2022-02-22 0000019617-22-000272
## 4 10-K 2021-02-23 0000019617-21-000236
## 5 10-K 2020-02-25 0000019617-20-000257
## 6 10-K 2019-02-26 0000019617-19-000054
## 7 10-K 2018-02-27 0000019617-18-000057
## 8 10-K 2017-02-28 0000019617-17-000314
## 9 10-K 2016-02-23 0000019617-16-000902
## 10 10-K 2015-02-24 0000019617-15-000272
## 11 10-K 2014-02-20 0000019617-14-000289
## 12 10-K 2013-02-28 0000019617-13-000221
## 13 10-K 2012-02-29 0000019617-12-000163
## 14 10-K 2011-02-28 0000950123-11-019773
## 15 10-K 2010-02-24 0000950123-10-016029
## 16 10-K 2009-03-02 0000950123-09-003840
## 17 10-K 2008-02-29 0001193125-08-043536
## 18 10-K 2007-03-01 0000950123-07-003015
## 19 10-K/A 2006-08-03 0000950123-06-009854
## 20 10-K/A 2006-06-22 0000950123-06-008545
## 21 10-K 2006-03-09 0000950123-06-002875
## 22 10-K/A 2005-06-28 9999999997-05-030472
## 23 10-K 2005-03-02 0000950123-05-002539
## 24 10-K/A 2004-06-28 9999999997-04-028305
## 25 10-K 2004-02-18 0000950123-04-002022
## 26 10-K/A 2003-06-30 9999999997-03-028080
## 27 10-K 2003-03-19 0000950123-03-002985
## 28 10-K/A 2002-06-28 9999999997-02-037872
## 29 10-K405 2002-03-22 0000950123-02-002823
## 30 10-K405 2001-03-22 0000950123-01-002499
## 31 10-K/A 2000-06-28 0000019617-00-000125
## 32 10-K 2000-03-13 0000950123-00-002204
## 33 10-K/A 1999-06-29 0000950123-99-006055
## 34 10-K405 1999-03-11 0000950123-99-002057
## 35 10-K405 1998-03-30 0000950123-98-003043
## 36 10-K 1997-03-25 0000950123-97-002412
## 37 10-K405 1996-03-20 0000950123-96-001197
## 38 10-K/A 1995-06-26 0000019617-95-000080
## 39 10-K405 1995-03-27 0000950123-95-000706
## 40 10-K/A 1994-05-09 0000019617-94-000048
## 41 10-K 1994-03-25 0000950123-94-000607
google_income <- GetIncome("GOOG", 2016)
amazon_balance <- GetBalanceSheet("AMZN", 2015)
apple_cashflow <- GetCashFlow("AAPL", 2014)
options(HTTPUserAgent = "a a@gmail.com")
CompanyInfo("V")
## company CIK SIC state state.inc FY.end street.address
## 1 VISA INC. 0001403161 7389 CA DE 0930 P.O. BOX 8999
## city.state
## 1 SAN FRANCISCO CA 94128-8999
AnnualReports("V")
## filing.name filing.date accession.no
## 1 10-K 2023-11-15 0001403161-23-000099
## 2 10-K 2022-11-16 0001403161-22-000081
## 3 10-K 2021-11-18 0001403161-21-000060
## 4 10-K 2020-11-19 0001403161-20-000070
## 5 10-K 2019-11-14 0001403161-19-000050
## 6 10-K 2018-11-16 0001403161-18-000055
## 7 10-K 2017-11-17 0001403161-17-000044
## 8 10-K 2016-11-15 0001403161-16-000058
## 9 10-K 2015-11-20 0001403161-15-000013
## 10 10-K 2014-11-21 0001403161-14-000017
## 11 10-K 2013-11-22 0001403161-13-000011
## 12 10-K 2012-11-16 0001384108-12-000011
## 13 10-K 2011-11-18 0001193125-11-315956
## 14 10-K 2010-11-19 0001193125-10-265236
## 15 10-K 2009-11-20 0001193125-09-239249
## 16 10-K 2008-11-21 0001193125-08-240384
## 17 10-K/A 2008-02-25 0001193125-08-036840
## 18 10-K/A 2008-02-04 0001193125-08-019268
## 19 10-K 2007-12-21 0001193125-07-270394
visa_income <- GetIncome("V", 2016)
visa_income2 <- GetIncome("V", 2013)
#view(visa_income)
visa_balance <- GetBalanceSheet("V", 2015)
visa_cashflow <- GetCashFlow("V", 2014)
merge_visa <- rbind(visa_income, visa_income2)
merge_visa$Amount <- as.numeric(merge_visa$Amount)
str(merge_visa)
## 'data.frame': 130 obs. of 5 variables:
## $ Metric : chr "Service fees" "Service fees" "Service fees" "Data Processing Fees" ...
## $ Units : chr "usd" "usd" "usd" "usd" ...
## $ Amount : num 5.80e+09 6.30e+09 6.75e+09 5.17e+09 5.55e+09 ...
## $ startDate: chr "2013-10-01" "2014-10-01" "2015-10-01" "2013-10-01" ...
## $ endDate : chr "2014-09-30" "2015-09-30" "2016-09-30" "2014-09-30" ...
visa1 <- merge_visa %>% select(Metric, Amount, startDate)
visa2 <- visa1 %>% filter(Metric=="Revenues")
visa2 <- visa2 [order(visa2$startDate), ]
visa3 <- visa2 %>% select(Amount)
ts <- ts(data = visa3$Amount, start=2010, frequency=1) #frequencia de 1 es para años
ts
## Time Series:
## Start = 2010
## End = 2015
## Frequency = 1
## [1] 9.1880e+09 1.0421e+10 1.1778e+10 1.2702e+10 1.3880e+10 1.5082e+10
arima <- auto.arima(ts)
arima
## Series: ts
## ARIMA(0,1,0) with drift
##
## Coefficients:
## drift
## 1178800000
## s.e. 62342384
##
## sigma^2 = 2.505e+16: log likelihood = -100.93
## AIC=205.87 AICc=211.87 BIC=205.09
summary(arima)
## Series: ts
## ARIMA(0,1,0) with drift
##
## Coefficients:
## drift
## 1178800000
## s.e. 62342384
##
## sigma^2 = 2.505e+16: log likelihood = -100.93
## AIC=205.87 AICc=211.87 BIC=205.09
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE
## Training set 1334866 129240697 86534866 0.04372382 0.7143061 0.07340929
## ACF1
## Training set -0.3502541
pronostico <- forecast(arima, level=c(95), h=5)
pronostico
## Point Forecast Lo 95 Hi 95
## 2016 16260800000 15950563413 16571036587
## 2017 17439600000 17000859212 17878340788
## 2018 18618400000 18081054470 19155745530
## 2019 19797200000 19176726827 20417673173
## 2020 20976000000 20282289903 21669710097
plot(pronostico)