Survey Says: Big Data, We Have Some Work to Do.

I recently read, per the tweeted recommendation of Secret Life of Pronouns author James Pennebaker, Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us About Who We Really Are, by Seth Stephens-Davidowitz.  See Seth Stephens-Davidowitz’s book Everybody Lies. Best #bigdata/#language book in years. Must read for #socialpsychology #economics — James W Pennebaker (@jwpennebaker) June 2, […]

R Explained for Excel Users: What is a Data Frame?

Like in Excel, data in R comes in different shapes and sizes. In Excel, there are cells, ranges, worksheets and so forth. R does things a bit differently. Ultimately, these difference come down to the use of a vector as its information building block.  Picture a table in Excel. If you know how to design […]

R Explained for Excel Users: Assigning Variables

The single-greatest difference? R and Excel are both powerful tools for the analyst. A good analyst uses each when appropriate. Many analysts haven’t used R, for different reasons. For one, it has a steeper learning curve than Excel. It is also less likely to be used by your boss. But it is a very powerful […]

Generating Unique Random Numbers in R For Excel

Never listen to the Excel haters — it’s not going anywhere. Choosing to use R “instead of” Excel is like naming a favorite child! Each has its advantages, and a savvy analyst is able to use them in tandem. Here’s an example of using R to make up for an Excel shortcoming. DO NOT BE […]

Excel’s Online Communities: Interview with Alex Powers

As I have been fumbling my way through learning Python, online forums and communities have fascinated me. Why are some forums strict to the point of rudeness and others nearly a yes-man free-for-all?  Are there such things as a stupid question on an online help forum? To discuss these questions and to work toward a […]