When China overtook India- using DEDUCER

I was just reading about the new release of World Bank Data at http://www.r-chart.com/2010/09/new-world-bank-data-available.html Now World Bank Data is something I worked with in the past, but the RWDI package is a great package. (see http://www.r-chart.com/2010/09/new-world-bank-data-available.html)

The whole dataset is a 29 mb in zipped CSV though and is available for terrific macroeconomic analysis _ I downloaded it and loaded it instead.

http://data.worldbank.org/sites/default/files/data/wdiandgdf_csv.zip

I took a small subset of the data –


WDI_GDF_Data <- read.table("C:/Documents and Settings/abc/My Documents/Downloads/WDI_GDF_Data.csv",header=T,sep=",",quote="\"")
 WDI_GDF_Data.sub<-subset(WDI_GDF_Data,Country.Code == "CHN" | Country.Code == "IND" | Country.Code == "USA")
WDI_GDF_Data.sub.sub<-subset(WDI_GDF_Data.sub,Series.Code == "NY.GDP.PCAP.KD")
WDI_GDF_Data.sub.sub<-as.data.frame(t(WDI_GDF_Data.sub.sub))
write.csv(WDI_GDF_Data.sub.sub,'C:/Documents and Settings/abc/Desktop/gdp3.csv')

Note- WordPress.com now supports source code in R via http://en.support.wordpress.com/code/posting-source-code/

Now this is basic data manipulation- and I used Deducer for it.

The best thing is the ability to use GGPlot using a GUI.
I am now trying to create more complicated plots for example with more than one Y variable but it is still a work in progress. Overall Deducer has made impressive improvements and with the JGR GUI seems very very promising. The look and feel also shows a combination of features (from SPSS ‘s variable and data view)

And yes China overtook India in 1985. In GDP per capita. Sigh

GGPLot though overtook Excel graphics as well.


Here is a video which is much better than my screenshots

OT: How would you fix the economy

The Business Section asked readers for ideas on “How Would You Fix the Economy?”

I think this guy nailed it!

Dear Mr. President:

Please find below my suggestion for fixing America ‘s economy.

Instead of giving billions of dollars to companies that will squander the money on lavish parties and unearned bonuses, use the following plan.

You can call it the Patriotic Retirement Plan:

There are about 40 million people over 50 in the work force.

Pay them $1 million apiece severance for early retirement with the following stipulations:

1) They MUST retire. Forty million job openings – Unemployment fixed.

2) They MUST buy a new American CAR. Forty million cars ordered – Auto Industry fixed.

3) They MUST either buy Continue reading “OT: How would you fix the economy”

Bailout Poem

Two kids were talking in the park, and they played a game.

Who was the tougher guy, What is your daddys name.

 

My daddy worked on Wall Street , and boy he was so good,

He created more money out of money,oh yes , he sure could.

But good times had to end, times turned tough.

but my daddy was tougher, he changed tactics soon enough.

 

By the proper contributions, and fundraisers ball,

He got the government to bail him out, in billions ,thats not small.

Your daddy is such a loser , he paid taxes on time,

filled his 401 k account, and committed no white/blue collar crime.

 

Thats why your daddy stands in line, in the cutback recession stall

Hoping to get food stamps , which have grown more since last fall.

If your daddy got the billions , he would have created stuff,

He would have created startups and jobs, the world needs that enough.

 

My daddy worked on Main Street, in an old American factory of cars,

He created good cars when young, but lost out in the oil price wars.

He may not have paid the fundraisers, but he is a honest man,

Your daddy might be richer, but my dad is the ordinary Ameri-CAN

 

By the sweat of his brow, and the toil of his arms,

My dad will rise  despite this fall,

If we could kick Nazi and Commi Butt,

Your dads dishonest white collar butt is even more small.

 

the kids moved on to another game, but what about Mr YOU.

are you going to be a wolf or a sheep, while the big guy fleeces us too.

Happy New Year : 2009 Predictions and 2008 Recap

Here are some economic predictions I made at the start of 2008 –

http://www.decisionstats.com/?p=80

1) Recessions -especially recessions that are anticipated and planned for always look worst at the beginning.

2) While some can cut spending the usual way for Govts is supply side (fed  rate cuts) for more money  , and demand side(Keynes) stimulus spending

3) Political costs is always a key policy decider in economic slow downs. We may see more bi partisan ship as parties work together for welfare projects in an election year

Basically the only prediction that I got correct was Number 9 –

9) We will have more interesting 2008 than 2007. That’s the economist in me speaking. As Alan Greenspan wrote we will live in the age of turbulence.

In fact that was the only thing Alan and I got correct the whole year , though I did switch to Keynesian spending in June , that’s before Ben Bernanke did but about 15 years after Paul Krugman did.

Anyway here are some economic predictions for 2009 ( economists , even pretend ones like me are rather stubborn)

 

)0( Price of Oil and Commodities will rebound by end of quarter 1. This would also be impacted by the auto industry in 2 months time and any consolidation there.

1) Entertaintment business will continue to grow. It may thrive as people have more time and more reason to get cheered up.Expect more shift to the web though not in the degree expected.Online entertainment will  further evolve. Expect more profitable online communities.

2) War focuses will shift from Iraq to Afghan-Pakistan ( it already has).Expect some more rumbles and surprises there.

Continue reading “Happy New Year : 2009 Predictions and 2008 Recap”

Sub Prime Crisis: A Risk Analyst view from the Trenches

Pricing of Future Securities and Derivatives Based on Mortgage Assets are all about projecting delinquency rates , and it depends on the analysts to be either conservative in projecting a high rate or optimistic in a low rate.

Based on these projections , the assets are priced, packed up in SPV’s or collateralized, and options priced. Now Senior Management gets a big bonus if they sell off their balance sheet like this, and business is able to use cash generated to create higher loans….. so they lean on the analyst to Continue reading “Sub Prime Crisis: A Risk Analyst view from the Trenches”

Dude , Wheres my software ?

Here is the reason why .

It would take an average Indian 26 months to buy a software worth 6000 USD (Assuming he didnot spend any money on anything else) while it takes the average UK  citizen only 2 months.

But why Sweden ……see post here on a Swedish Website

Here is a list of countries by per capita GDP in terms of purchasing power parity

(or how much they make on an year).

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

http://en.wikipedia.org/wiki/List_of_countries_by_GDP_(PPP)_per_capita