• C++ Programming for Financial Engineering
    Highly recommended by thousands of MFE students. Covers essential C++ topics with applications to financial engineering. Learn more Join!
    Python for Finance with Intro to Data Science
    Gain practical understanding of Python to read, understand, and write professional Python code for your first day on the job. Learn more Join!
    An Intuition-Based Options Primer for FE
    Ideal for entry level positions interviews and graduate studies, specializing in options trading arbitrage and options valuation models. Learn more Join!

Excel flawed for statistical calculations?

Joined
6/28/09
Messages
69
Points
18
Hi all,

I saw this paper:
http://www.pages.drexel.edu/~bdm25/excel2007.pdf

This paper was published in 2008 so I'm not sure if these problems still exist in the current versions. Also, do financial institutions do a quality assurance check on their computational tools using benchmark problems?
 
The article is about using Excel for involved statistical methods, which is not how most people use Excel.

Someone could be coding something and have it back out of Excel as an interface; in which case, the computations are being done by the compiler of a low-level language and fed into Excel but Excel didn't really have to 'do' anything. That is, if they are using Excel at all for statistical methods / numerical type stuff.

The limitations of Excel have been widely known for a long time. It's just still used because it's the spreadsheet program that everyone has and the amount of the time you can only conveniently communicate something through a spreadsheet is quite often.
 
Back
Top