1214 search results for "Excel"

Big data problems

April 22, 2011
By
Big data problems

I have big data problems.I need to analyze 100s of millions of rows of data and tried hard for 2 weeks to see if I can use R for this. My assessment so far from the experiments...1) R is best for data that fits a computer's RAM (so get more RAM if...

Read more »

Open Source replacements for Operations Research and Analytics Software

April 21, 2011
By
Open Source replacements for Operations Research and Analytics Software

I was reading an article from Datamation on 70 Open Source Replacements for Small Business when I noticed a glaring omission.  Where are the software applications for Operations Research and Analytics?  So here is my best addendum to this art...

Read more »

Open Source replacements for Operations Research and Analytics Software

April 21, 2011
By
Open Source replacements for Operations Research and Analytics Software

I was reading an article from Datamation on 70 Open Source Replacements for Small Business when I noticed a glaring omission.  Where are the software applications for Operations Research and Analytics?  So here is my best addendum to this art...

Read more »

Survival skills for today’s analyst

April 21, 2011
By

I suffer a little from the age-old affliction of contrarianism. If a software package is used by the majority of the population, I assume it is flawed, highly limited, and its continued use will ultimately result in the downfall of the human race. Conversely, I am always extremely interested in a piece of software that has spread no further...

Read more »

Survival skills for today’s analyst

April 21, 2011
By

I suffer a little from the age-old affliction of contrarianism. If a software package is used by the majority of the population, I assume it is flawed, highly limited, and its continued use will ultimately result in the downfall of the human race. Conversely, I am always extremely interested in a piece of software that has spread no further...

Read more »

Spreadsheet errors

April 20, 2011
By
Spreadsheet errors

For my sins, I have done more than my fair share of analysis in Excel. I am quite capable of building and maintaining 130Mb spreadsheets (I had a dozen of them for one client). Excel is pretty much installed everywhere, so it is sometimes the only way to get started getting commercial value of the data in the...

Read more »

Spreadsheet errors

April 20, 2011
By
Spreadsheet errors

For my sins, I have done more than my fair share of analysis in Excel. I am quite capable of building and maintaining 130Mb spreadsheets (I had a dozen of them for one client). Excel is pretty much installed everywhere, so it is sometimes the only way...

Read more »

Spreadsheet errors

April 20, 2011
By
Spreadsheet errors

For my sins, I have done more than my fair share of analysis in Excel. I am quite capable of building and maintaining 130Mb spreadsheets (I had a dozen of them for one client). Excel is pretty much installed everywhere, so it is sometimes the only way...

Read more »

250 years of Bayes’ Theorem

April 19, 2011
By

The Reverend Thomas Bayes died 250 years ago this month. His grave, located near epidemiological centre of excellence St Mary's College, remains a point of pilgrimage for statisticians (of both Bayesian and Frequentist stripes) visiting London to this day. Because since then, Bayes Theorem has been the underpinning of predictive analytics applications from spam detection to medical alerts. There...

Read more »

Using R, Sweave and Latex to integrate animations into PDFs

April 18, 2011
By
Using R, Sweave and Latex to integrate animations into PDFs

The first week of April I attended an excellent workshop on biplots held by Michael Greenacre and Oleg Nenadić at the Gesis Institute in Cologne, Germany. Throughout his presentations, Michael used animations to visualize the concepts he was explaining. He also included  animations in some of his papers. This inspired me to do this post

Read more »