Matches in SemOpenAlex for { <https://semopenalex.org/work/W1780990970> ?p ?o ?g. }
- W1780990970 abstract "Monte Carlo (MC) simulation includes a wide range of stochastic techniques used to quantitatively evaluate the behavior of complex systems or processes. Microsoft Excel spreadsheets with Visual Basic for Applications (VBA) software is, arguably, the most commonly employed general purpose tool for MC simulation. Despite the popularity of the Excel in many industries and educational institutions, it has been repeatedly criticized for its flaws and often described as questionable, if not completely unsuitable, for statistical problems. The purpose of this study is to assess suitability of the Excel (specifically its 2010 and 2013 versions) with VBA programming as a tool for MC simulation. The results of the study indicate that Microsoft Excel (versions 2010 and 2013) is a strong Monte Carlo simulation application offering a solid framework of core simulation components including spreadsheets for data input and output, VBA development environment and summary statistics functions. This framework should be complemented with an external high-quality pseudo-random number generator added as a VBA module. A large and diverse category of Excel incidental simulation components that includes statistical distributions, linear and non-linear regression and other statistical, engineering and business functions require execution of due diligence to determine their suitability for a specific MC project." @default.
- W1780990970 created "2016-06-24" @default.
- W1780990970 creator A5084002697 @default.
- W1780990970 date "2015-03-29" @default.
- W1780990970 modified "2023-09-27" @default.
- W1780990970 title "Assessing Excel VBA Suitability for Monte Carlo Simulation" @default.
- W1780990970 cites W1041249711 @default.
- W1780990970 cites W1508103490 @default.
- W1780990970 cites W1536359674 @default.
- W1780990970 cites W1578713482 @default.
- W1780990970 cites W1596606480 @default.
- W1780990970 cites W1614949726 @default.
- W1780990970 cites W193897080 @default.
- W1780990970 cites W1963581710 @default.
- W1780990970 cites W1966383311 @default.
- W1780990970 cites W1978220024 @default.
- W1780990970 cites W1986517320 @default.
- W1780990970 cites W1991853218 @default.
- W1780990970 cites W1999674105 @default.
- W1780990970 cites W2024835947 @default.
- W1780990970 cites W2025455610 @default.
- W1780990970 cites W2028317999 @default.
- W1780990970 cites W2033582774 @default.
- W1780990970 cites W2035743124 @default.
- W1780990970 cites W2036919197 @default.
- W1780990970 cites W2041488292 @default.
- W1780990970 cites W2042057696 @default.
- W1780990970 cites W2045978895 @default.
- W1780990970 cites W2049294866 @default.
- W1780990970 cites W2059150393 @default.
- W1780990970 cites W2070539368 @default.
- W1780990970 cites W2079991932 @default.
- W1780990970 cites W2083910000 @default.
- W1780990970 cites W2084150680 @default.
- W1780990970 cites W2090824272 @default.
- W1780990970 cites W2094151643 @default.
- W1780990970 cites W2095595785 @default.
- W1780990970 cites W2097569052 @default.
- W1780990970 cites W2100077262 @default.
- W1780990970 cites W2101685006 @default.
- W1780990970 cites W2109150479 @default.
- W1780990970 cites W2110821007 @default.
- W1780990970 cites W2121764011 @default.
- W1780990970 cites W2123076475 @default.
- W1780990970 cites W2125467704 @default.
- W1780990970 cites W2127250502 @default.
- W1780990970 cites W2127951107 @default.
- W1780990970 cites W2141193347 @default.
- W1780990970 cites W2142568711 @default.
- W1780990970 cites W2143144462 @default.
- W1780990970 cites W2145779853 @default.
- W1780990970 cites W2158662288 @default.
- W1780990970 cites W2161011220 @default.
- W1780990970 cites W2164768649 @default.
- W1780990970 cites W2164895118 @default.
- W1780990970 cites W2165030400 @default.
- W1780990970 cites W2272129171 @default.
- W1780990970 cites W2320477252 @default.
- W1780990970 cites W2322744709 @default.
- W1780990970 cites W2328886926 @default.
- W1780990970 cites W2479377679 @default.
- W1780990970 cites W2725542278 @default.
- W1780990970 cites W2945152609 @default.
- W1780990970 cites W295740984 @default.
- W1780990970 cites W3020882730 @default.
- W1780990970 cites W565095754 @default.
- W1780990970 cites W62283792 @default.
- W1780990970 cites W649564723 @default.
- W1780990970 cites W650512571 @default.
- W1780990970 cites W1749677908 @default.
- W1780990970 cites W2159628926 @default.
- W1780990970 hasPublicationYear "2015" @default.
- W1780990970 type Work @default.
- W1780990970 sameAs 1780990970 @default.
- W1780990970 citedByCount "0" @default.
- W1780990970 crossrefType "posted-content" @default.
- W1780990970 hasAuthorship W1780990970A5084002697 @default.
- W1780990970 hasConcept C105795698 @default.
- W1780990970 hasConcept C111919701 @default.
- W1780990970 hasConcept C115199736 @default.
- W1780990970 hasConcept C124101348 @default.
- W1780990970 hasConcept C127413603 @default.
- W1780990970 hasConcept C146978453 @default.
- W1780990970 hasConcept C19499675 @default.
- W1780990970 hasConcept C199360897 @default.
- W1780990970 hasConcept C204323151 @default.
- W1780990970 hasConcept C3019730874 @default.
- W1780990970 hasConcept C33923547 @default.
- W1780990970 hasConcept C41008148 @default.
- W1780990970 hasConceptScore W1780990970C105795698 @default.
- W1780990970 hasConceptScore W1780990970C111919701 @default.
- W1780990970 hasConceptScore W1780990970C115199736 @default.
- W1780990970 hasConceptScore W1780990970C124101348 @default.
- W1780990970 hasConceptScore W1780990970C127413603 @default.
- W1780990970 hasConceptScore W1780990970C146978453 @default.
- W1780990970 hasConceptScore W1780990970C19499675 @default.
- W1780990970 hasConceptScore W1780990970C199360897 @default.
- W1780990970 hasConceptScore W1780990970C204323151 @default.
- W1780990970 hasConceptScore W1780990970C3019730874 @default.
- W1780990970 hasConceptScore W1780990970C33923547 @default.