Reply to topic  [ 6 posts ] 
Excel : Destroyer of Economies 
Author Message
What's a life?
User avatar

Joined: Thu Apr 23, 2009 7:26 pm
Posts: 17040
Reply with quote
How an error in an Excel spreadsheet means influential academic paper is, well, wrong.


Thu Apr 18, 2013 6:17 pm
Profile
Legend

Joined: Sun Apr 26, 2009 12:30 pm
Posts: 45931
Location: Belfast
Reply with quote
It's definitely a pain in the hole, that much we know :lol:

_________________
Plain English advice on everything money, purchase and service related:

http://www.moneysavingexpert.com/


Thu Apr 18, 2013 9:37 pm
Profile
Legend
User avatar

Joined: Fri Apr 24, 2009 2:02 am
Posts: 29240
Location: Guantanamo Bay (thanks bobbdobbs)
Reply with quote
Quote:
The UK's 19-year stretch of high debt and moderate growth (during the period between 1946 and 1964, the debt-to-GDP ratio was above 90 percent, and growth averaged 2.4 percent) is conflated into a single data point and treated as equivalent to New Zealand's single year of debt above 90 percent, during which it experienced growth of -7.6.

During that period there was full employment in the UK. There was no unemployment unless you chose to not work. The fact that they used Excel appears to be irrelevant when the data in was garbage.

Quote:
This link was always controversial, with many economists proposing that the correlation between high debt and low growth was just as likely to have a causal link in the other direction to that proposed by Reinhart and Rogoff: it's not that high debt causes low growth, but rather that low growth leads to high debt.

This is the real answer, but many politicians do not care about that. They want to use it as a reason to shrink the state.

_________________
Do concentrate, 007...

"You are gifted. Mine is bordering on seven seconds."

https://www.dropbox.com/referrals/NTg5MzczNTk

http://astore.amazon.co.uk/wwwx404couk-21


Thu Apr 18, 2013 11:30 pm
Profile
What's a life?
User avatar

Joined: Thu Apr 23, 2009 8:25 pm
Posts: 10691
Location: Bramsche
Reply with quote
So, nothing to do with Excel and everything to do with nobody double checking their work, before they published!

It reminds me of the case against Lotus in the late 80s, where a company used 1-2-3 to produce quotes and the new quote was 3 lines longer than previous quotes and caused the engineers to under quote the work by $60,000 or so (ISTR), because they didn't extend the formula to cover the new lines, they assumed that 1-2-3 would magically recognise that 3 extra lines had data and adjust the formula itself.

Lotus won the case. Software is no magical remedy for idiocy.

_________________
"Do you know what this is? Hmm? No, I can see you do not. You have that vacant look in your eyes, which says hold my head to your ear, you will hear the sea!" - Londo Molari

Executive Producer No Agenda Show 246


Fri Apr 19, 2013 4:27 am
Profile ICQ
Legend
User avatar

Joined: Fri Apr 24, 2009 2:02 am
Posts: 29240
Location: Guantanamo Bay (thanks bobbdobbs)
Reply with quote
big_D wrote:
So, nothing to do with Excel and everything to do with nobody double checking their work, before they published!

It seems that some are more interested in blaming Microsoft than checking the facts. The fact that they produced the report on Excel is of minor significance. It could have just as easily been done with Numbers or Open Office. When I initially read the headline I thought that it was going to be similar to the floating point problem many years ago. I was drawn more to the fact that the selection of data was also highly selective.

_________________
Do concentrate, 007...

"You are gifted. Mine is bordering on seven seconds."

https://www.dropbox.com/referrals/NTg5MzczNTk

http://astore.amazon.co.uk/wwwx404couk-21


Fri Apr 19, 2013 4:47 am
Profile
Doesn't have much of a life
User avatar

Joined: Wed Apr 29, 2009 9:33 am
Posts: 667
Reply with quote
Is that what Excel's for?

I've never seen it used for anything other than cutter guides for large poly bags.

_________________
UltraSonic f***erPhonic ZombieShockin TrailerRockin BabyBoomin GaitorGroomin InterStellar LadyRaiders


Sun Apr 21, 2013 8:18 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 6 posts ] 

Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.