1270 search results for "excel"

More reasons not to use Excel for modeling

April 17, 2013
By
More reasons not to use Excel for modeling

As if the London Whale nearly bankrupting Chase Bank wasn't lesson enough, we now hear that an Excel error impacted the conclusions of a major economics paper that influenced the recent austerity policies in the US, UK and elsewhere. Matt Frost says enough is enough, and implores to everyone to stop using error-prone point-and-click tools, and instead use a...

Read more »

Spring Cleaning Data: 1of 6- Downloading the Data & Opening Excel Files

April 8, 2013
By

With spring in the air, I thought it would be fun to do a series on (spring) cleaning data. The posts will follow my efforts to to download the data, import into R, cleaned it up, merge the different files, add columns of information created, and then ...

Read more »

Rationality, and MS Excel (and other calculators)

March 27, 2013
By
Rationality, and MS Excel (and other calculators)

This morning, Mathieu had a nice experience in his course on computational method in actuarial science. But let us start with some mathematical formal definitions. First, recall that is – somehow – a standard expression. No one should be surprised to see such an expression. Generally (as explained in http://en.wikipedia.org/… ), this function is defined only when . The...

Read more »

Copying Data from Excel to R and Back

February 24, 2013
By
Copying Data from Excel to R and Back

A lot of times we are given a data set in Excel format and we want to run a quick analysis using R's functionality to look at advanced statistics or make better visualizations. There are packages for importing/exporting data from/to Excel, but I have f...

Read more »

Copying Data from Excel to R and Back

February 23, 2013
By
Copying Data from Excel to R and Back

A lot of times we are given a data set in Excel format and we want to run a quick analysis using R's functionality to look at advanced statistics or make better visualizations. There are packages for importing/exporting data from/to Excel, but I have found them to be hard to work with or only work with old versions of...

Read more »

Some of Excel’s Finance Functions in R

February 16, 2013
By

Last year I took a free online class on finance by Gautam Kaul. I recommend it, although there are other classes I can not compare it to. The instructor took great efforts in motivating the concepts, structuring the material, and enable critical thinking / intuition. I believe this is an advantage of video...

Read more »

Did an Excel error bring down the London Whale?

February 11, 2013
By

When JP Morgan Chase announced it had lost more than 2 billion dollars on the capital markets back in May 2012, many pointed to the actions of rogue trader Bruno Iksil as the cause. But was the "London Whale" — the nickname he was given by other traders for his outsized positions — the victim not of hubris, but...

Read more »

Management of Research Data – a Shell+Python+Excel+R Approach

January 23, 2013
By
Management of Research Data – a Shell+Python+Excel+R Approach

I am a computer science researcher, usually working on both Windows and Linux system. Windows is the place where I do the document work, like reading paper, browsing the internet, writing papers with LaTex… Linux is where I run and generate experimental results. The Chaos After years of messy data management and recent data chaos,

Read more »

Please stop using Excel-like formats to exchange data

December 7, 2012
By
Please stop using Excel-like formats to exchange data

I know “officially” data scientists all always work in “big data” environments with data in a remote database, streaming store or key-value system. But in day to day work Excel files and Excel export files get used a lot and cause a disproportionate amount of pain. I would like to make a plea to my Related posts:

Read more »

Excel + Cytoscape + R = ExCytR

November 16, 2012
By
Excel + Cytoscape + R = ExCytR

My new project is coming along nicely and should be released early 2013. It builds on the structures developed in imDEV to link Excel, Cytoscape and R using RExcel,  RCytoscape, and CytoscapeRPC . This trio can be used to rapidly generate beautiful and  informative network representations of data. Here is an example of a  undirected Gaussian graphical

Read more »