Examinando por Materia "Complemento de excel"

Mostrando 1 - 2 de 2
  • Miniatura
    PublicaciónAcceso abierto
    Complemento de Excel para ajuste paramétrico de series de tiempo
    (Universidad EIA, 2012) Santa Vélez, Camilo; Obando López, Jorge Mario
    This thesis is based on Fisher’s scoring algorithm to fit GARMA parametric series using an Excel® 2010 Add-in. Initially, a theoretical framwork is presented regarding time series and the paremetric models used in this thesis. The models used by the Add-in are ARMA, ARIMA and GARMA. In the case of GARMA models, the conditional distributions used are Normal, Binomial, Poisson and Gamma with canonical link function (With the Gamma conditional distribution, the identity link function is also available)
  • Miniatura
    PublicaciónAcceso abierto
    Complemento en Excel® 2010 para el pronóstico no paramétrico de series de tiempo
    (Universidad EIA, 2011) Quintero Cataño, Jonathan; Jaramillo Betancur, Javier Vicente
    Today, it could be seen the need for people and companies to determinate the future environment that they have to face and with the goal to make decisions to take advantage over the rest, together with advances in technology that humanity has made and the massive use of Microsoft Excel ® which is a tool for data management, it is necessary to create an add-in in the program that allows forecasting of future observations of a time series under different methods that in the case of this project are in nonparametric forecasts. By the above, it was identified a mathematical and statistical algorithm that allows calculation of descriptive statistical measures and graphics, and also forecasting time series under non-parametric statistical methods in Visual Basic for Applications (VBA), it is included in Excel ® 2010.