UPDF AI

Essentials of Excel, Excel VBA, SAS, and Minitab for statistical and financial analysis

R. Shanmugam

2019 · DOI: 10.1080/00949655.2019.1628890
Journal of Statistical Computation and Simulation · 1 Citations

TLDR

The first division illustrates introduction to Excel programming, Visual Basic for Application programming, professional techniques, binomial option pricing, decision tree approach, alternative option pricing, estimation of implied variance, portfolio insurance, option strategies, and simulation methods among others.

Abstract

numbers versus stock market analyses, sampling, decision theory among others. The second division illustrates introduction to Excel programming, Visual Basic for Application (VBA) programming, professional techniques, binomial option pricing, decision tree approach, alternative option pricing, estimation of implied variance, portfolio insurance, option strategies, and simulation methods among others. The third division explains simultaneous equation, empirical methods, linear regression models, and hedge ratios among others.