November 2022
Beginner to intermediate
192 pages
5h 49m
English
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. ...
Read now
Unlock full access