Category: Business Intelligence

Anyone who has ever done a linear regression in R has seen an R formula. R formulae are examples of the Wilkinson notation, sometimes called the Wilkinson-Rogers notation. This same notation is used by other applications including Matlab and Octave to indicate relationships between variables. In most cases, R users have seen the Wilkinson notation […]

When R starts up, it looks for several files to initialize its configuration. R has its own configuration file called Rprofile.site located in the /etc folder. It is probably wise not to mess with this file unless you are very confident in your understanding. Most R users are aware that during startup, R reads an […]

The Data Frame The fundamental data structure used by the majority of R functions and packages is the data frame. In a data frame, sets of related values constitute rows, while an individual column vector in a data frame contains comparable measures that can be summed, averaged, or subjected to any number of numerical manipulations. […]

You probably thought that the chapter on binary number systems in your Intro to Computer Science textbook would never have to be opened again, especially now that you’re a report writer or a data analyst and generally don’t get too close to the silicon. SQL Server DBAs bump into binary numbers from time to time […]

Productive Microsoft Excel Add-Ins There are many Microsoft Excel Add-Ins available for Free that can make you more productive. This article will show you how to find and install them on your local copy of Microsoft Excel. You can also install them in you Office365 copy of Excel as well. What is an Excel Add-In? […]