USe of Web Element for Google Wave to Embed a Wave

Here is my second attempt. Nothing Shows here




a smaller version



Embedding a Wave in a Blogger Post

Google today released Webelement for wave that allows embedding a wave into a web page here

http://www.google.com/webelements/wave

The webelement generates Javascript code. However, Google's own web publishing programs do not allow inserting Javascript developed by its own programs,therefore, webelement for wave will not work in blogger or for that matter your Google Web site. There is always a way around every problem.


-----------------------------------------------------------------------------

A work around this will be to go here

http://everybodywave.appspot.com/index/embedwiz.html
and create a web address for the Wave to be emvbedded and then put an iframe through it like this:



Even here Wave shows just fine within preview and then some times disappears in the actual post. If the Wave does not show up Try using Firefox because Google Chrome got so problem with this.

------------------------------------------------------------------------------------

Anther method using Embeddy is described here http://randomthougts101.blogspot.com/2009/12/example-of-embedding-public-wave-in.html

-------------------------------------------------------------------
I think Google need to start looking in the reliability of its product as well as how well they fit with other products they have. They all just seems to work but not always or reliably.

----------------------------------------------------------------------------------------------------------

Friday, April 23, 2010

Developing Motion Charts for Historical Stock Data

Google spreadsheet comes with functions that allow to populate spreadsheet columns with historical stock information. This information can then be plotted easily using motion chart gadget available within the spreadsheet.

The spreadsheet is shown below




Click on Bubble Chart option to see the Bubble motion chart.

OR

See the chart below



The web address of the Spreadsheet is here

You can make a copy of this spreadsheet to see how it was created.

The two main commands to create this spreadsheet are

=GoogleFinance("GOOG";"all"; "1/1/2008","4/24/2010";7) to get the historical stock data

and copying all the information from different sheets to the main sheet is done by using this command

=ImportRange("tNYLkOzp1dX9Lf35_1Ye9fw","Google!A2:G121")

The first input is the spreadsheet key that is located after the question mark in the web address of spreadsheet shown within the address bar of the web browser.

The moving bar chart is shown below




The screencast for the moving bubble chart is



Another screencast showing the moving bubble chart with trails




Firefox 3.5 could not handle the last plot. The motion became jerky and slow. The plot is done using Google Chrome

Some helpful information is available in this article:

"Visualising Financial Data In a Google Spreadsheet Motion Chart OUseful.Info, the blog" http://bit.ly/9A4Z87

Tuesday, April 20, 2010

Google Spreadsheet and Google Visual Api for Maps

The following map showing the population of states is created using Google spreadsheet and a map gadget based upon the Google visualization api.

Move mouse over the map to see the population numbers





the Map Gadget address http://hosting.gmodules.com/ig/gadgets/file/111281674411733733399/usgeomap1color.xml

Saturday, April 17, 2010

NodexL A Network Visualization Tool based upon Microsoft Excel used for Creating a Twitter friends Visualization

NodeXL is a Microsoft Excel based network visualization tool. The program exports and imports network connectivity data in many different formats.

It has the capability to directly download membership data from many popular social networks. This data is processed and the program can calculate network characteristics parameters. It also draws a network connectivity diagram. A brief overview of the use of the program is shown in the video below by the the program creator:


2009 - November - NodeXL - Demo - Mapping Twitter Social Networks "Digg" from Marc Smith on Vimeo.

I created a network visualization for the people I am connected on the twitter. First I used NodeXL's capability to download data directly from Twitter. The used the program's capability to create the following Network visualization diagram.

Click on the image for an enlarged view.

The diagram shows most of the people I am connected to on twitter. Another picture that shows the edges of network is shown below:

Click on the image for an enlarged view


Social network visualization diagrams are very interesting. They provide a snapshot of connectivity that will not be obvious by looking at the raw data.

Right now these plots are restricted to only one social network at a time. Also, the social networks put limits on how much and what kind of data can accessed from their website.

NodeXl is gaining popularity among academics. A number of instructors have been using to help teaching social network analysis. A book entitled "
Analyzing Social Media Networks with Microsoft NodeXL Book" will be published in few months time. The outline of the book can be obtained here http://bit.ly/cCFEXD

Gephi Network Visualization Program and Connectivity in a Social Network

Gephi is a program that allows to create network visualization diagrams from standard network data files. The following video shows some of the capabilities of the program.


To give a test run I downloaded the data of my friendship connectivity from one of the social network. This data is also known as Social graph. The data was loaded in Gephi and a network diagram was created.

The presentation below shows the network diagram and provides an explanation.

The adobe swf loads slow, so please wait few minutes for presentation to load.


These plots of Social graph are useful plots. They provide a visual confirmation of the connectivity. It also shows that social connectivity in the social network is a sparsely connected network. There are few hubs and a significant number are not really connected.

Network studies are becoming popular these days. Here is a very infromative website "Connected: The Surprising Power of Our Social Networks" http://bit.ly/av6nKZ
for additional information on social network analysis.

Sunday, April 11, 2010

Should We Trust Pundits? Latest on Population Bomb or Bust

Paul Ehrlich is a Biologist at Stanford University. He is the author of the famous book "The Population Bomb" that created a panic about the over population on the earth.
Since the release of this book in 1968, Ehrlich has been one of the most frequently cited "experts" on environmental issues by the media, despite the fact that his predictions on the fate of the planet, more often than not, have been wrong. In The Population Bomb, Ehrlich predicted that hundreds of millions of people would die of starvation during the 1970s because the earth's inhabitants would multiply at a faster rate than world's ability to supply food.

Source: Dossier - Dr. Paul Erlich http://bit.ly/dj2oCT

According to him over population will create a shortage of resources and will result in mass starvation and death. So far that has not happened. The problem his trend analysis is that he extrapolated the trend in population assuming that the trend in population growth will always be positive. A typical error made by Scientists who assume that the past trends will continue in the future. They however, are successful in getting people's attention because humans have always listened to doomsday Sayers. Belief in doomsday must satisfy some innate need within humans.

The reality is totally different. The current world populations is
6,814,078,514 and growing an average of 23.2 kids born per 1,000 people. This is slightly higher than the 21 kids born per 1,000 people, needed to maintain the current level of population.

The map below shows the birth rates in different countries


Please move the mouse over the map to see the name of the country and the birthrate for different countries




What is interesting is that the two countries India and China with the world's largest population, now have a birth rate of 12 and 24 children per 1,000 people. That is quite manageable.

Here is the complete table showing data for for each country




If one looks at the bottom right, there a many of countries whose birth rate is well below 21 children per 1,000 people. They are mostly located in Western and Central Europe and in South East Asia.

In fact there are countries now those are experiencing negative population growth. Here are some of the estimates of the percent population decline by the year 2050, shown on the map below:



From the map, it seems that the phenomenon of estimated population decline is highly localized around the regions that are located near or around Russia. Only non-European country that is showing up in this group is Japan. However, Japan belongs to the same geographical region and located on the eastern side of Russia.

There seems to be some positive correlation between literacy level and the population growth. The map below shows the percent literacy rates:




Countries with hundred percent literacy rate are having least number of children.

Is this trend will move southward? That will be something to watch in the future. Dr. Paul Ehrlich predicted a uncontrolled population growth. However, that does not seems to be the case. If the trends that is currently underway in Russia and Central Europe moves southward we may be heading toward a population bust not a population growth, all we need is to make people literate.





Map Showing Literacy Rate by Countries

Chart below shows literacy rate of different countries in percentage of literate population

Move mouse over the map to see the name of the country and percentage literacy rate




The data spreadsheet is shown below





Source:List of countries by literacy rate - Wikipedia, the free encyclopedia http://bit.ly/b2MSMa

Saturday, April 10, 2010

World Countries Educational Spending

The map below shows the Educational Spending as percent total of each government expenditures. The data is the recently available data

Move your mouse over the map to see the name and the spending for each country

The data for each country is shown below




Original Source: Education spending (% of total government expenditure) statistics - countries compared - NationMaster

Sunday, April 4, 2010

What World Eats Cost per Week in US $

Move mouse over the picture to see the numbers

The Table Data