Demand Forecast Monte Carlo Method

Asked

Viewed 24 times

1

Good personal evening, I am developing a select in order to simulate a demand forecast in my company, I am using the Monte Carlo method, which uses a function to generate random values within the distributive function. Does anyone know the function or how to apply the inverse of the distribution in a select in the Oracle database? I use the Sqltools tool. Here’s an article I’m using as support, page 11 this formula when applied in Excel. Thanks for your attention

http://pos.federalnoar.com.br/wp-content/uploads/2018/02/PREVIS%C3%83O-DE-DEMANDA-POR-MEIO-DO-M%C3%89TODO-DE-SIMULA%C3%87%C3%83O-DE-MONTE-CARLOS-EM-UMA-LOJA-E-CONVENI%C3%8ANCIA.pdf

sql oracle

  • pdf has not been downloaded on my tablet but Oracle has a wide range of statistical functions , https://www.oracle.com/database/technologies/bi-datawarehousing.html ... https://docs.oracle.com/cd/B19306_01/server.102/b14223/analysis.htm#i1007362

  • Improves the question, data model, problem definition and "page 11". A simpler model such as linear regression or movable means does not solve ?

  • https://pt.wikipedia.org/wiki/Invers%C3%A3o_de_Moro

  • https://web.archive.org/web/200705050933/http://home.online.no/~pjacklam/Notes/invnorm/#Oracle_plsql

No answers

Browser other questions tagged sql oracle

You are not signed in. Login or sign up in order to post.