{"id":2799,"date":"2019-01-06T00:31:32","date_gmt":"2019-01-06T00:31:32","guid":{"rendered":"https:\/\/ideasillustrated.com\/blog\/?p=2799"},"modified":"2019-01-06T13:18:32","modified_gmt":"2019-01-06T13:18:32","slug":"data-points-january-2019","status":"publish","type":"post","link":"https:\/\/ideasillustrated.com\/blog\/2019\/01\/06\/data-points-january-2019\/","title":{"rendered":"Data Points: January 2019"},"content":{"rendered":"<p><em>A roundup of random thoughts on data, information and design for the New Year.<\/em><\/p>\n<p><strong>Diversity in the 116th U.S. Congress<\/strong><\/p>\n<p>There has been a lot of discussion this week about the racial, ethnic and gender makeup of the incoming <a href=\"https:\/\/www.nytimes.com\/interactive\/2018\/11\/28\/us\/politics\/congress-freshman-class.html\" rel=\"noopener nofollow\" target=\"_blank\">class of congress<\/a>, including celebrations of <a href=\"https:\/\/www.cnn.com\/2019\/01\/03\/politics\/new-congress-history-women-diversity\/index.html\" rel=\"noopener nofollow\" target=\"_blank\">firsts<\/a> on the Democratic side of the aisle to laments that the incoming Republican representatives looked like <a href=\"https:\/\/www.huffingtonpost.com\/entry\/gop-congressmen-1950-boardroom_us_5c3005b9e4b073352832da90\" rel=\"noopener nofollow\" target=\"_blank\">a corporate board from the 1950s<\/a>. <\/p>\n<p>The starkness of some of the pictures made me wonder if there was a way to summarize the differences between the two political parties. Using a technique from a <a href=\"https:\/\/ideasillustrated.com\/blog\/2015\/05\/25\/what-does-the-average-biker-dude-look-like\/\">previous post<\/a>, I was able to average the images of 67 incoming freshmen Democrats and 44 incoming freshmen Republicans into a side-by-side comparison. Yeah, it&#8217;s pretty obvious &#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/US_Congress_Freshmen_2019.png\" alt=\"\" width=\"667\" height=\"364\" class=\"aligncenter size-full wp-image-2801\" srcset=\"https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/US_Congress_Freshmen_2019.png 667w, https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/US_Congress_Freshmen_2019-300x164.png 300w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/p>\n<p>Time to change your approach, boys!<\/p>\n<p><strong>A Sample of Survey Spelling Errors<\/strong><\/p>\n<p>I&#8217;ve already written a <a href=\"https:\/\/ideasillustrated.com\/blog\/2013\/05\/18\/spelling-and-national-security\/\">post<\/a> about the impact that spelling errors can have on your data but a recent review of an old research project made me want to revisit the topic. This particular project involved a survey of vehicle owners and the use of a text input box for questions about the &#8220;make&#8221; and &#8220;model&#8221; of a vehicle. <\/p>\n<p>There is nothing necessarily wrong with free-form comments or open-ended questions but if you use such an approach for categorical questions &#8212; the groupings you&#8217;ll be using to summarize the results of your survey &#8212; you&#8217;re asking for trouble. For this survey, there were two big issues: 1) not all respondents knew what the terms &#8220;make&#8221; and &#8220;model&#8221; meant (e.g. Toyota Celica or Ford Mustang); and 2) people cannot spell worth a darn. <\/p>\n<p>For issue #1, less than half the people surveyed answered the make and model questions appropriately. Transposition of the responses and the addition of extraneous information like model year, trim or body style severely reduced the correct response rate and required a large amount of manual intervention to correct. Issue #2 caused even more headaches. The winner for most misspelled vehicle model was the Honda Odyssey minivan:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/Odyssey.png\" alt=\"\" width=\"610\" height=\"403\" class=\"aligncenter size-full wp-image-2805\" srcset=\"https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/Odyssey.png 610w, https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/Odyssey-300x198.png 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/p>\n<p>The better approach in these circumstances is to limit the respondents options with a drop-down menu or other user interface elements.<\/p>\n<p><strong>Echoes of the Great Migration<\/strong><\/p>\n<p>The New York Times published an <a href=\"https:\/\/www.nytimes.com\/interactive\/2018\/09\/19\/upshot\/facebook-county-friendships.html\" rel=\"noopener nofollow\" target=\"_blank\">interactive map<\/a> of Facebook connections back in September. It was very interesting to see some of the southern &#8220;hot spots&#8221; of friends associated with northern cities like Milwaukee and Chicago. <\/p>\n<p>Many of these connections are the direct result of the <a href=\"https:\/\/www.the-american-interest.com\/2011\/09\/01\/the-great-migration\/\" rel=\"noopener nofollow\" target=\"_blank\">migration of African-Americans<\/a> in the early 20th Century. Of the three main routes out of the South, the roads and rail lines along the Mississippi River were used primarily by migrants from Alabama, Arkansas, Mississippi and Tennessee looking for work in the industrial centers in the Midwest. The family histories of people like <a href=\"https:\/\/mcpl.monroe.lib.in.us\/Mobile\/BakerAndTaylor\/Excerpt?ISBN=9781595554154&#038;UPC=&#038;position=1\" rel=\"noopener nofollow\" target=\"_blank\">Oprah Winfrey<\/a>, <a href=\"https:\/\/www.nytimes.com\/2018\/12\/06\/books\/review\/michelle-obama-becoming-memoir.html\" rel=\"noopener nofollow\" target=\"_blank\">Michelle Obama<\/a>, and <a href=\"https:\/\/www.npr.org\/templates\/story\/story.php?storyId=130291351\" rel=\"noopener nofollow\" target=\"_blank\">many others<\/a> can be traced to this massive population shift.<\/p>\n<p>Here are details showing the &#8220;likelihood of friendship&#8221; for Milwaukee County (Milwaukee) and Cook County (Chicago) &#8230; along with neighboring suburban counties such as Waukesha County (Milwaukee) and DuPage County (Chicago).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/Migration-Connections-871x1024.png\" alt=\"\" width=\"871\" height=\"1024\" class=\"aligncenter size-large wp-image-2809\" srcset=\"https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/Migration-Connections-871x1024.png 871w, https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/Migration-Connections-255x300.png 255w, https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/Migration-Connections-768x903.png 768w, https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/Migration-Connections.png 1157w\" sizes=\"auto, (max-width: 871px) 100vw, 871px\" \/><\/p>\n<p>The African-American populations in the urban centers of these cities still have large pockets of friends and family in the South. Suburban counties to the west have lower numbers of African-Americans and limited connection to the area. (I personally think the Chicago-Milwaukee corridor is ripe for some <a href=\"https:\/\/www.foodnetwork.com\/restaurants\/packages\/best-food-in-america\/photos\/what-to-eat-mississippi\" rel=\"noopener nofollow\" target=\"_blank\">Mississippi cousine<\/a>!)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A roundup of random thoughts on data, information and design for the New Year. Diversity in the 116th U.S. Congress There has been a lot of discussion this week about the racial,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2817,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[19,191,2,27,193,192,111,113],"class_list":["post-2799","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-information","tag-charts","tag-congress","tag-data","tag-data-visualization","tag-spelling","tag-survey","tag-visualization","tag-words"],"jetpack_featured_media_url":"https:\/\/ideasillustrated.com\/blog\/wp-content\/uploads\/2019\/01\/Data_Points.png","_links":{"self":[{"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/posts\/2799","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/comments?post=2799"}],"version-history":[{"count":10,"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/posts\/2799\/revisions"}],"predecessor-version":[{"id":2819,"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/posts\/2799\/revisions\/2819"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/media\/2817"}],"wp:attachment":[{"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/media?parent=2799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/categories?post=2799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ideasillustrated.com\/blog\/wp-json\/wp\/v2\/tags?post=2799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}