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....


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Blog Archive

Translate

About Me

My photo
He started in 1979 as IBM/370 system engineer. In 1986 he got his PhD. in Robotics at St. Petersburg Technical University (Russia) and then worked as a professor teaching CAD/CAM, Robotics for 12 years. He published 30+ papers and made several presentations for conferences related to the Robotics and Artificial Intelligent fields. In 1999 he moved to the US, worked at Capital One bank as a Capacity Planner. His first CMG.org paper was written and presented in 2001. The next one, "Exception Detection System Based on MASF Technique," won a Best Paper award at CMG'02 and was presented at UKCMG'03 in Oxford, England. He made other tech. presentations at IBM z/Series Expo, SPEC.org, Southern and Central Europe CMG and ran several workshops covering his original method of Anomaly and Change Point Detection (Perfomalist.com). Author of “Performance Anomaly Detection” class (at CMG.com). Worked 2 years as the Capacity team lead for IBM, worked for SunTrust Bank for 3 years and then at IBM for 3 years as Sr. IT Architect. Now he works for Capital One bank as IT Manager at the Cloud Engineering and since 2015 he is a member of CMG.org Board of Directors. Runs UT channel iTrubin