{"id":558,"date":"2013-10-22T10:52:36","date_gmt":"2013-10-22T15:52:36","guid":{"rendered":"http:\/\/blogs.dickinson.edu\/edtech\/?p=558"},"modified":"2013-10-22T12:02:21","modified_gmt":"2013-10-22T17:02:21","slug":"bubble-chart-tutorial","status":"publish","type":"post","link":"https:\/\/blogs.dickinson.edu\/edtech\/2013\/10\/22\/bubble-chart-tutorial\/","title":{"rendered":"Bubble Chart Tutorial"},"content":{"rendered":"<p><code><script type=\"text\/javascript\" src=\"\/\/ajax.googleapis.com\/ajax\/static\/modules\/gviz\/1.0\/chart.js\"> {\"dataSourceUrl\":\"\/\/docs.google.com\/spreadsheet\/tq?key=0AseK2cPi8K7fdFBCcl9lVWg3NnFBUVI2RFpmLVNxU1E&transpose=0&headers=1&range=A1%3AE17&gid=0&pub=1\",\"options\":{\"titleTextStyle\":{\"fontSize\":16},\"vAxes\":[{\"useFormatFromData\":true,\"title\":\"Left vertical axis title\",\"minValue\":null,\"viewWindow\":{\"max\":null,\"min\":null},\"maxValue\":null},{\"useFormatFromData\":true,\"minValue\":null,\"viewWindow\":{\"max\":null,\"min\":null},\"maxValue\":null}],\"booleanRole\":\"certainty\",\"title\":\"Chart title\",\"height\":493,\"animation\":{\"duration\":500},\"width\":657,\"focusTarget\":\"series\",\"hAxis\":{\"useFormatFromData\":true,\"title\":\"Horizontal axis title\",\"minValue\":null,\"viewWindow\":{\"max\":null,\"min\":null},\"maxValue\":null},\"tooltip\":{\"trigger\":\"none\"}},\"state\":{},\"view\":{},\"isDefaultVisualization\":true,\"chartType\":\"MotionChart\",\"chartName\":\"Chart 1\"} <\/script><\/code><\/p>\n<p>Select your x axis, y axis, bubble size and set colors to unique. If we use # of immigrants and unemployment rate for each axis, we&#8217;d expect to find a correlation, so bubbles should move from lower left to upper right or the reverse. Is it true?<\/p>\n<p>To create, we need the data formatted as so, https:\/\/docs.google.com\/spreadsheet\/ccc?key=0AseK2cPi8K7fdFBCcl9lVWg3NnFBUVI2RFpmLVNxU1E&amp;usp=sharing<\/p>\n<p>Choose countries that have data and create your own starting with a Google Docs spreadsheet<\/p>\n<p>Can&#8217;t use date ranges in Google Docs, must provide an average year for each decade. We&#8217;re dividing decade totals of immigrants by 10 to get an average year.  Also need average for unemployment<\/p>\n<p>To speed up data entry, use Excel to add years in decade and divide by total to get average unemployment<\/p>\n<p>To make for easier viewing select columns you don&#8217;t need, right click and hide in Excel<\/p>\n<p>Will frequently encounter problems when using historical data. Consider Germany was divided. No unemployment rate given for China, so couldn&#8217;t use them. West German population is a guess for 1990 since reunified. No data for Mexico unemployment in the 1960s, found 1970 is 7.0, http:\/\/bls.gov\/opub\/mlr\/1994\/11\/art1full.pdf We can enter that in, or leave it out. If we leave it out, Mexico won&#8217;t appear until 1975  With all of these assumptions, it&#8217;s important to inform the reader.<\/p>\n<p>Once you have the data, create a Chart -&gt; Trends -&gt; Motion Chart<\/p>\n<p>To export to put on a blog post, click the arrow in the top right of the chart and choose Publish. \u00a0Can paste that code into any html page or blog post.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Select your x axis, y axis, bubble size and set colors to unique. If we use # of immigrants and unemployment rate for each axis, we&#8217;d expect to find a correlation, so bubbles should move from lower left to upper &hellip; <a href=\"https:\/\/blogs.dickinson.edu\/edtech\/2013\/10\/22\/bubble-chart-tutorial\/\">Continue reading<\/a><\/p>\n","protected":false},"author":776,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-558","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blogs.dickinson.edu\/edtech\/wp-json\/wp\/v2\/posts\/558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.dickinson.edu\/edtech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.dickinson.edu\/edtech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.dickinson.edu\/edtech\/wp-json\/wp\/v2\/users\/776"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.dickinson.edu\/edtech\/wp-json\/wp\/v2\/comments?post=558"}],"version-history":[{"count":0,"href":"https:\/\/blogs.dickinson.edu\/edtech\/wp-json\/wp\/v2\/posts\/558\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.dickinson.edu\/edtech\/wp-json\/wp\/v2\/media?parent=558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.dickinson.edu\/edtech\/wp-json\/wp\/v2\/categories?post=558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.dickinson.edu\/edtech\/wp-json\/wp\/v2\/tags?post=558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}