Is Microsoft Excel an Adequate Statistics Package?
Never, ever use Excel for anything other than prototyping, spot-checking data, or as a makeshift GUI while you develop a proper one.<p>I&#x27;ve seen several financial shops where people were moving millions of dollars around using Excel. IMHO, it&#x27;s always an indicator of deficient processes and lack of coding skill. Yes, I do know that some clever people use it. They are productive in spite of excel, not because of it.<p>Your main problem with excel is not that some statistical function is missing, or wrong, or misleading. Sure, that&#x27;s an issue, but you can live with a few things being wrong if you can detect them and fix them yourself. I&#x27;ll come back to stats later...<p>The problem with Excel is it&#x27;s damn near undebuggable. There&#x27;s simply nothing in the way of someone making a beast of a calculation, with the flow going all over several sheets. You can even make things circular if you want. The data and the code are all together, mixed up. Was a number in a given cell written there by the VB code, or was it an input? You can use the auditing functions, but chances are you will see a spaghetti of arrows.<p>It&#x27;s also non trivial to find differences between different versions. Typically the dude who is using excel has also never heard of Git or SVN, so you will see a load of sheets like &quot;portfolio1&quot; and &quot;portfolio2_new_old&quot; and so on. I don&#x27;t know if it&#x27;s changed, but when I was using Excel, the files had code files within them, rather than separate files, like we do with most other languages.<p>Of course you aren&#x27;t forced to write crappy spreadsheets, but there&#x27;s simply a tendency for people who don&#x27;t code to be a bit messy. But Excel is positively inviting trouble. It&#x27;s so flexible that anyone under a little pressure will hack in some extra bell or whistle, building up tech debt for future generations. It basically lulls the novice into thinking they can build anything.<p>Amazingly I&#x27;ve met several people in finance who pride themselves on spreadsheets that stretch over thousands of lines. I remember a billion dollar merger where the analyst in charge of the &quot;modelling&quot; showed me how they reached the line limit (I think that&#x27;s gone now, so good luck!). It&#x27;s as if making things complicated justified their salaries, so maybe that&#x27;s why excel is so popular.<p>Now, about statistics. If you&#x27;re doing anything non-trivial, you absolutely do not have space to look at all the individual numbers in your matrices. Just like if you&#x27;re solving equations on a piece of paper, you need your own symbolism. You need to be able to give things names and see short statements at the appropriate level of abstraction. You probably need to be able to verify the pieces independently, too. So unit tests for various operations, that aren&#x27;t intruding into the business logic.