5
Grid Approximation with Multiple Parameters
This is not meant to be a treatise on the use of VBA code—or R code for that matter—but if you are to understand what the code is doing it’s necessary to get at least an overview of it. I’m presenting this coding example using a combination of an Excel worksheet and Visual Basic for Applications (VBA). Here’s why:
It’s generally acknowledged that VBA is not optimized for statistical analysis. Certainly, it’s possible to carry out certain statistical procedures using VBA, but it’s also true that many of those procedures require 10, 20, even 50 lines of code to accomplish something that a language such as R can accomplish in one or two statements. ...
Get Bayesian Analysis with Excel and R now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
