Thursday, April 18, 2013

Do not blame Excel, blame analyst!

I have been using Excel for more than 20 years and I even had run a class teaching accouters to work with spreadsheets! And sure, time to time some bugs were seen and some inaccurate calculations (e.g. working already as Capacity planner I was pointed by my manger on some not precise trend charts I built and had to redo that by use intercept(), slop() and RSQ() functions to get trends, not trusting to the graphical way to plot them.

BUT I LOVE EXCEL!!! You just need to know what you can and cannot do with it!

So I am LOL reading the following article where wrong global trend were drown from mistaken Excel based analysis. Do not blame excel, blame analyst! And I Applauding to the student who is brave to  find the  error in famous but bad analyst's work!


Here is original American article: http://finance.fortune.cnn.com/2013/04/17/rogoff-reinhart-excel-errors
And Russian one I guess about the same fact but under different angle: http://newsru.com/finance/18apr2013/student.html


Plus I personalty enjoy living in debt. Being relatively new here in US (~13 yeas ago I moved with family with ~$10,000 in my pocket), that economical mechanism allowed me to reach almost middle class life level by just lending my brain....


No comments:

Blog Archive

Translate

About Me

My photo

I started my career in 1979 as an IBM/370 system engineer. In 1986 I got my PhD. in Robotics at St. Petersburg Technical University (Russia) and then worked as a professor teaching there CAD/CAM, Robotics and Computer Science for about 12 years. I published 30 papers and made several presentations for international conferences related to the Robotics, Artificial Intelligent and Computer fields. In 1999 I moved to the US and worked at Capital One bank in Richmond as a Capacity Planner. My first CMG paper was written and presented in 2001. The next one, "Global and Application Level Exception Detection System Based on MASF Technique," won a Best Paper award at CMG 2002 and was presented again at UKCMG 2003 in Oxford, England. My CMG 2004 paper about applying MASF technique to mainframe performance data was republished in the IBM z/Series Expo. I also presented my papers in Central Europe CMG conference and in numerous US regional meetings. I continue to enhance my exception detection methodologies. After working more than 2 years as the Capacity Management team lead for IBM, I had worked for SunTrust Bank for 3 years and then got back to IBM holding for 2+ years  Sr. IT Architect position. Currently I work for Capital One bank as IT Manager for IT Capacity Management group. In 2015 I have been elected to the CMG (http://www.cmg.org) board of directors,

The views expressed here are my own and do not necessarily reflect the views of my employer.