<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Andrew Fogg on Medium]]></title>
        <description><![CDATA[Stories by Andrew Fogg on Medium]]></description>
        <link>https://medium.com/@andrewfogg?source=rss-3c9697a4199e------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*T1Co4PPwpm-wOIJhi6yx_Q.png</url>
            <title>Stories by Andrew Fogg on Medium</title>
            <link>https://medium.com/@andrewfogg?source=rss-3c9697a4199e------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 18:51:33 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@andrewfogg/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[7 days of dataisbeautiful]]></title>
            <link>https://medium.com/@andrewfogg/7-days-of-dataisbeautiful-7672b64d97c9?source=rss-3c9697a4199e------2</link>
            <guid isPermaLink="false">https://medium.com/p/7672b64d97c9</guid>
            <dc:creator><![CDATA[Andrew Fogg]]></dc:creator>
            <pubDate>Thu, 29 Jan 2015 01:07:38 GMT</pubDate>
            <atom:updated>2015-01-29T01:07:38.975Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1000/1*x2xbQ7rDaAJmSBiHyt2X0w.png" /></figure><p>That’s a word cloud. It took me about 30 <a href="http://blog.import.io/post/build-a-word-cloud-in-30-seconds">seconds to build</a>.</p><p>It shows the relative word frequencies in the titles of posts to <a href="http://www.reddit.com/r/dataisbeautiful/">r/dataisbeautiful</a> over the last 7 days.</p><h2>“Citi”</h2><p>One thing that jumps out immediately is the high occurrence of the word “Citi”.</p><p>“Citi” is presumably a reference to <a href="https://www.citibikenyc.com/">New York’s bike sharing service</a> that is sponsored by <a href="http://www.citigroup.com/citi/">Citibank</a>.</p><p>It turns out that there were 4 data visualisations about Citi Bikes last week,</p><ul><li><a href="http://www.reddit.com/r/dataisbeautiful/comments/2tyq8f/snowstorm_shutters_20_of_nyc_citi_bike_system_oc/">Snowstorm shutters 20% of NYC Citi Bike system</a></li><li><a href="http://www.reddit.com/r/dataisbeautiful/comments/2tlzbv/nyc_citi_bike_fleet_size_drops_to_record_low_as/">NYC Citi Bike fleet size drops to record low as Operation Overhaul begins</a></li><li><a href="http://www.reddit.com/r/dataisbeautiful/comments/2tie44/this_winter_nyc_citi_bike_riders_are_taking/">This winter, NYC Citi Bike riders are taking shorter trips</a></li><li><a href="http://www.reddit.com/r/dataisbeautiful/comments/2teb3u/remarkable_how_nyc_citi_bike_penalty_fees_are/">Remarkable how NYC Citi Bike penalty fees are such a steady contributor to bottom line</a></li></ul><p>And they were all submitted by the same Reddit user: <a href="http://www.reddit.com/user/wefollocitibike">wefollocitibike</a></p><h2>How we talk about data</h2><p>The word cloud suggests some interesting patterns about how data visualisations are talked about.</p><p>But it is difficult to draw clear conclusions from a word cloud because it relies on the viewer being able to compare different font sizes — which is a hard thing to do.</p><p>To make it easier for you, here is a bar chart of the top 10 words ranked by relative frequency.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/468/1*ysDLhHkarfQf3dvTyntgDQ.png" /></figure><h2>Build a word cloud in 30 seconds</h2><p>I was inspired to give this a go after reading <a href="http://blog.import.io/post/build-a-word-cloud-in-30-seconds">today’s tutorial</a> that shows how to use <a href="https://magic.import.io/">Import.io Magic</a> to extract written content from a blog and then visualise the results in a word cloud, in the shape of a logo.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/995/1*flT-DVy3eBLEaMFXqMbEzw.png" /></figure><p>It was very quick. It took longer to write this post than it did to create the visualisation.</p><p><em>Originally published at </em><a href="http://blog.import.io/post/7-days-of-rdataisbeautiful"><em>blog.import.io</em></a><em> on January 29, 2015.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7672b64d97c9" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Every iPhone release follows the hype cycle]]></title>
            <link>https://medium.com/@andrewfogg/every-iphone-release-follows-the-hype-cycle-d8dff2697948?source=rss-3c9697a4199e------2</link>
            <guid isPermaLink="false">https://medium.com/p/d8dff2697948</guid>
            <dc:creator><![CDATA[Andrew Fogg]]></dc:creator>
            <pubDate>Fri, 17 Oct 2014 01:59:05 GMT</pubDate>
            <atom:updated>2014-10-17T01:59:05.153Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/772/0*yMXaD4P74Sm7zB9O.jpg" /></figure><p><a href="http://www.gartner.com/">Gartner</a> developed the concept of the technology <a href="http://en.wikipedia.org/wiki/Hype_cycle">hype cycle</a> as a tool to help explain the different stages that a new technology goes through as it is released into the market and adopted by users.</p><p>Every iPhone release takes its own special path through the hype cycle.</p><p>Before a release the rumours start about what features the phone will have. The hype builds to a frenzy that peaks with a glittering presentation of the new device and pictures of queues, as fanboys line up to be the first to try the new product.</p><p>We then enter the #gate stage. Where some “fatal” technical flaw is discovered by users after release and is widely discussed on social media. We have had <a href="http://online.wsj.com/articles/SB10001424052748704913304575371131458273498">antennagate</a>, <a href="http://articles.latimes.com/2012/sep/28/business/la-fi-tn-steve-jobs-tim-cook-maps-antenna-20120928">mapgate</a> and now: <a href="http://www.forbes.com/sites/gordonkelly/2014/09/24/iphone-6-plus-bendgate/">bendgate</a>.</p><p>We will get over it though and before you know it we will be asking ourselves “when is the next release due?”</p><p><em>Originally published at </em><a href="http://andrewfogg.com/2014/09/24/every-iphone-release-follows-gartners-hype-cycle/"><em>andrewfogg.com</em></a><em> on September 25, 2014.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d8dff2697948" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Gender differences amongst sex workers online]]></title>
            <link>https://medium.com/@andrewfogg/gender-differences-amongst-sex-workers-online-734dd22327c3?source=rss-3c9697a4199e------2</link>
            <guid isPermaLink="false">https://medium.com/p/734dd22327c3</guid>
            <dc:creator><![CDATA[Andrew Fogg]]></dc:creator>
            <pubDate>Fri, 17 Oct 2014 00:02:29 GMT</pubDate>
            <atom:updated>2014-10-17T00:02:29.333Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fUX7S_K58tFQmitflYgT1g.png" /></figure><p>Two weeks ago the UK’s Office of National Statistics (ONS) announced that the <a href="http://www.bbc.co.uk/news/business-29422267">UK economy had grown by 0.9% in the second quarter of 201</a>4. This growth was partly due to the decision to include prostitution in gross domestic product (GDP) for the first time ever.</p><p>The ONS estimate that Britain’s 60<a href="http://www.ons.gov.uk/ons/publications/re-reference-tables.html?edition=tcm%3A77-360136">,879 prostitutes contribute £5.314bn</a> (0.4% GDP) to the UK economy. But, this figure completely ignores male prostitution. In a previous post we used data from AdultWork, a popular sex worker website, to determine that 42<a href="http://blog.import.io/post/how-much-does-prostitution-contribute-to-the-uk-economy">% of UK prostitutes are male</a>, which (all other factors being equal) represents an additional £3.542bn of UK GDP!</p><p>Our initial analysis was very simple, but nonetheless raised a lot of interest from you all, along with some great questions about the gender differences between male and female sex workers. We decided to look a little deeper into the gender differences amongst sex workers online and this is what we found.</p><h3>Sex workers on AdultWork are heterosexual</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*gtH1MI3tkhXDp030.png" /></figure><p>Sex workers on AdultWork are overwhelmingly heterosexual. Only 1.3% of profiles on AdultWork specify sexual orientation as “gay”. Homosexual sex workers both male and female are therefore missing from our previous revised estimates. In order to get a good measure of the number of homosexual sex workers in the UK we would have to look at data from additional web sites that focus specifically on these communities. It is interesting to note that women on AdultWork are much more likely to advertise themselves as bi-curious or bi-sexual than men. Indeed bi-sexual is the most popular advertised sexual orientation for female sex workers.</p><h3>Female sex workers are younger</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*L2jN4f7_aTVJgxyW.png" /></figure><p>Female sex workers are, on average 3 years younger than male sex workers. The average age for female sex workers is 30, while the average age for male sex workers is 33. The biggest age group across both genders is 24-year-old females. As sex workers get older, it appears that women stop working at a younger age than men.</p><h3>Female sex workers stop working sooner</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*XvxUybtb0gSHJSKP.png" /></figure><p>Female sex workers close their accounts at a greater rate than male sex workers. Over a period of 90 days, double the number of women will close their profiles compared to men.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*vNYOfrIAhKnropHp.png" /></figure><p>A female sex worker’s profile is most likely to be less than a year old, whereas a male sex worker’s profile is most likely to be between one and two years old.</p><h3>Female sex workers are more active</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*zeqk8FAv4RuvrBLg.png" /></figure><p>Women join AdultWork at a greater rate. This is reflected in the fact that there are more female profiles overall despite the increased rate of female account closure. In addition, while they are working, women are much more active than men. Women are twice as likely as men to have logged in to AdultWork in the last day.</p><h3>There is more demand for female sex workers</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*ISFb7ZcxWrSHC6Bc.png" /></figure><p>The total number of profile views for female sex workers is 38 times greater than the total number of profile views for male sex workers.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*wkDYkta6n975Vb7c.png" /></figure><p>In addition, the total number of reviews for female sex workers is much greater than that of male sex workers. But the difference in reviews is not as large as the difference in profile views. The total number of reviews for female sex workers is only 5 times greater than the total number of reviews for male sex workers.</p><p>Another way of putting this result is to say that male sex workers get many more reviews than would be expected based upon the total number of profile views for male sex workers.</p><h3>Female sex workers charge more</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*oxq7_SPZEt5KdBkl.png" /></figure><p>On average, female sex workers charge £120 for incall work and £150 for outcall work. This is much greater than male sex workers who charge around £70 regardless of whether the work is incall or outcall.</p><p>Looking at these pricing distributions, it is very clear that they are not <a href="http://en.wikipedia.org/wiki/Normal_distribution">normally distributed</a>. They do not fit a bell curve. But if we lay a normal distribution over the top of each pricing distribution, then an interesting pattern emerges,</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*JuQ1qpyFLY2QY0nP.png" /></figure><p>The pricing distributions are <em>sort of </em>normally distributed apart from spikes at certain price points. It is most easy to see this in the distribution of female pricing, which is is evenly distributed around the average, apart from massive spikes at £100 and £120 with another smaller spike at £150. These spikes are also present in the distribution of male pricing: at £80, £100, £120 and £150 although the effect is less strong.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*TV7iawzASafMWAI2.png" /></figure><p>Sex workers appear to be deploying a psychological pricing strategy in order to maximise their revenues. The classic example of psychological pricing is <a href="http://en.wikipedia.org/wiki/Psychological_pricing">fractional pricing</a> whereby the price of a product is set at £1.99 rather than £2.00 because £1.99 seems cheaper to a consumer, which drives greater demand. What appears to be going on with sex workers is that they are taking advantage of consumers’ price indifference between, for example, £110 and £120 and rounding up services that might be charged at £110 to £120.</p><h3>So what is the impact on GDP?</h3><p>The ONS estimate for the contribution that prostitution makes to GDP is calculated as follows,</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*V5yXPEszFRJ-F3LS.png" /></figure><p>Let’s look at each of these numbers in turn to see how our gender difference analysis can further improve our revised estimate for prostitution’s GDP contribution.</p><p>We know that the ONS figures are only for female sex workers. In order to get an improved estimate of the contribution that prostitution makes to GDP we are going to have to add male sex workers into the calculations.</p><p>As for the number of clients per prostitute per week, 25 seems very high. The source that the ONS uses for this number is <a href="http://www.cbs.nl/NR/rdonlyres/3C62D796-A06D-4DBC-9F18-CC2045CD41BB/0/200505X10pub.pdf">a study conducted in the Netherlands</a>, where prostitution is both legal and regulated. Prostitution in the UK is not regulated and although legal, many of the activities associated with it are illegal. The market for sex work in the UK is therefore likely to be very different to the market for sex work in the Netherlands. However, given that this is the only number that we have got, we will have to stick with it. But we do know from our analysis of AdultWork profiles that female sex workers are twice as active as male sex workers, so it seems reasonable to half the number of clients per week for male sex workers.</p><p>The average price per visit used by the ONS is much less than the average hourly rates for female sex workers advertised on AdultWork. The ONS do not provide exact details about how they calculated average price per visit simply saying that it is “an estimate from Punternet supported by a 2004 journal article” – the journal article is not cited.</p><p>Punternet is a website where male sex work consumers write reviews of female sex work providers. We decided to try and validate the average price per visit from Punternet ourselves. We created an <a href="https://import.io/">Import.io</a> API for Punternet and extracted the last 12 months of review data. We found that the average price per visit over the last 12 months was £138. The average duration of a visit was 63 minutes which gives an average hourly rate of £131. This is consistent with the average advertised incall and outcall rates on AdultWork. It is closer to the incall rate (£120) than the outcall rate (£150), which makes sense as 95% of all reviews on Punternet are for incall work.</p><p>Taking these numbers and running them through the ONS calculations gives a total of £12.374bn sales of prostitution services. Our estimated price per visit for female sex workers is double that of the ONS which in turn doubles the total sale of female prostitution services. Our figure for the total sales of male prostitution services is down from our previous estimate due to the reduced rates that male sex workers charge and the reduced activity that they appear to display in the market.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*M8cdYnbWEwn6jO36.png" /></figure><h3>How we got the data</h3><p>In order to do the initial count of sex workers we built <a href="https://import.io/data/mine/?id=20591575-92ec-4bbf-8c43-d0bf5ee6d335">an Import.io connector to the search function on AdultWork</a> (WARNING linked materials contain sexual content) and used it to perform a search for sex workers in the UK who advertise “escorting” on their profile pages. The connector paged through all the results (37,717) and for each result pulled down the profile summary information including gender, age, sexual orientation and number of reviews. On AdultWork gender is listed as: Female, Male, Couple MF, Couple FF, Couple MM or Unspecified. From this we were able to count the number of female (22,622) and male (16,326) sex workers on AdultWork. We ignored profiles where the gender was Unspecified (355) and counted twice for Couple profiles (1,586). 42% of the sex worker profiles on AdultWork are male.</p><p>In order to look at gender differences in greater depth we needed more detailed information than is available on the search result pages. AdultWork profile pages are not directly accessible via a URL. All AdultWork profile pages sit behind a landing page that warns visitors that the site contains material of an adult nature and asks visitors to confirm the territory that they are from. A simple extractor would not get past this landing page. Instead we built <a href="https://import.io/data/mine/?id=f1dee747-33a2-4a60-bafe-c43d301ec0c7">an Import.io connector that takes a URL as an input</a> (WARNING linked materials contain sexual content). The connector first navigates to the homepage of AdultWork, clicks through the landing page and then navigates to the specified profile page URL. In this way we were able to get profile views, joining date, last login date and hourly rates. We performed the gender difference analysis on a random sample of 1,000 female and 1,000 male profiles from the entire population of AdultWork profiles advertising escorting services in the UK.</p><p>You can learn more about connectors that take URLs as inputs <a href="http://support.import.io/knowledgebase/articles/436561">here</a>.</p><p>In order to calculate the average price per visit on Punternet we created <a href="https://import.io/data/mine/?id=6b76ae9c-a308-4add-ad25-90e33dab2f3c">an Import.io extractor to the Punternet review pages</a> (WARNING linked materials contain sexual content). The URLs for Punternet reviews are sequentially ordered. We found the most recent published review and a review from 12 months ago, generated the URLs for all the reviews in between and fed those URLs into the extractor to access 12 months of review data.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=734dd22327c3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How much does prostitution contribute to the UK economy?]]></title>
            <link>https://medium.com/@andrewfogg/how-much-does-prostitution-contribute-to-the-uk-economy-e5b7fd672f4a?source=rss-3c9697a4199e------2</link>
            <guid isPermaLink="false">https://medium.com/p/e5b7fd672f4a</guid>
            <dc:creator><![CDATA[Andrew Fogg]]></dc:creator>
            <pubDate>Thu, 16 Oct 2014 23:57:21 GMT</pubDate>
            <atom:updated>2014-10-16T23:57:21.097Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qC_0I76JqY1UvaiuSHhK4A.jpeg" /></figure><p>How many prostitutes are there in the UK? According to the <a href="http://www.ons.gov.uk/">Office of National Statistics</a> the answer is 60<a href="http://www.ons.gov.uk/ons/publications/re-reference-tables.html?edition=tcm%3A77-360136">,87</a>9. In figures <a href="http://www.ons.gov.uk/ons/release-calendar/index.html?newquery=gdp&amp;newoffset=100&amp;pageSize=50&amp;pagetype=calendar-entry&amp;sortBy=releaseDate&amp;sortDirection=DESCENDING&amp;releaseDateRangeType=allDates&amp;applyFilters=true">due to be released next week</a> this number is being used to add<a href="http://www.ons.gov.uk/ons/publications/re-reference-tables.html?edition=tcm%3A77-360136">£5.314bn</a> to the official size of the UK economy. But the ONS only attempted to measure the number of female prostitutes. If male prostitutes are included in the count then the contribution that prostitution makes to the UK economy rises to £8.856bn.</p><p>From the 30th of September the UK’s national accounts will attempt to measure <a href="http://www.ons.gov.uk/ons/guide-method/method-quality/specific/economy/national-accounts/articles/2011-present/inclusion-of-illegal-drugs-and-prostitution-in-the-uk-national-accounts.pdf">illegal transactions to which all parties consent</a>, including the sale of illegal drugs and prostitution. Illegal transactions are difficult to measure because the participants, while willing, are anxious that their business goes unnoticed. As a result there are very few obvious ways to directly measure illegal transactions and the ONS have been forced to rely on 10-year-old survey data in order to try and estimate the level of prostitution activity in the UK.</p><p>But there is a better way of measuring the number of prostitutes than using survey data. While many of the activities associated with prostitution are illegal in the UK, paying for sex is actually legal and as a result, prostitution services are widely marketed on the web. We can use <a href="https://import.io/">Import.io</a>to directly count the number of prostitutes who are marketing on the web and attempt a better estimate of the number of prostitutes in the UK.</p><p>The ONS used a <a href="http://i1.cmsfiles.com/eaves/2012/04/Sex-in-the-City-1751ff.pdf">study</a> by the charity <a href="http://www.eavesforwomen.org.uk/">Eaves Housing For Women</a> published in 2004 as the basis of their estimation of the number of prostitutes in the UK. The Eaves study tried to count all the female prostitutes in London over a 6 month period by telephoning every brothel and escort agency that they could find advertised. There are two main problems with the ONS using the Eaves study in this way: Eaves only surveyed the sex industry in London and Eaves only surveyed women working in the sex industry. We looked at each of these problems in turn.</p><h3>But first, our choice of website</h3><p>In order to do the work we built an <a href="http://support.import.io/knowledgebase/articles/247564-create-an-extractor">extractor</a> to the website AdultWork. AdultWork is an online marketplace for adult service providers. We chose to perform our analysis on AdultWork because AdultWork is much more popular relative to other similar websites.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*1sYTroZkkwQ925wi_nY8aA.png" /></figure><h3>Problem 1: London only (not a problem)</h3><p>The ONS used population figures for London and the UK to extrapolate out from the Eaves estimate of the number of prostitutes in London to an estimate of the number of prostitutes in the UK. The first thing that we did was to test the validity of this extrapolation. We used our extractor to pull down the AdultWork profiles of all the adult service providers in the UK who offer escorting. We then divided the profiles into two groups: those from London and those from the rest of the UK and compared the ratio against current population statistics for London and the UK. The prostitution ratio matched the population ratio. Our data support the validity of the extrapolation from the number of prostitutes in London to the number of prostitutes in the UK. The fact that the Eaves study only surveyed the sex industry in London is not a problem.</p><h3>Problem 2: Women only (big problem)</h3><p>The Eaves study is quite clear in stating that “no information is included regarding men working in the sex industry”. This means that any estimate that the ONS makes of the number of prostitutes in the UK is only an estimate of the number of female prostitutes. We used the same set of AdultWork profiles to see how much of a difference including men would make to the total number of prostitutes. When we counted the number of male and female service providers on AdultWork it turns out that 42% of them are male. This is not a small proportion. The fact that the Eaves study only surveyed women working in the sex industry is a major problem.</p><h3>What’s the impact?</h3><p>If 42% of prostitutes are men and there are 60,879 female prostitutes then we would estimate that there are 44,085 male prostitutes and that the total number of prostitutes in the UK is 104,964. If you use this number in the ONS calculation for the amount that prostitution contributes to the UK economy then you get £8.856bn (0.6% GDP) rather than £5.314bn (0.4% GDP). A difference of £3.542bn (0.2% GDP).</p><p>Using web data for this kind of economic analysis has two main benefits. It means that our measures can be up to date, even close to real time and that our measures can be more complete and less reliant on scaling assumptions.</p><h3>Want to know more?</h3><p>For more information you can watch the 15 minute video of me presenting this story at our last Data Summit and access my slides below.</p><p>Be sure to join us for our <a href="https://import.io/data-summit">Data Summit in San Francisco</a> for more great data stories.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FoZ-u6vww2rA%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DoZ-u6vww2rA&amp;image=http%3A%2F%2Fi.ytimg.com%2Fvi%2FoZ-u6vww2rA%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/66a721ccebd2f806f2c66a60ff9309f7/href">https://medium.com/media/66a721ccebd2f806f2c66a60ff9309f7/href</a></iframe><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.slideshare.net%2Fslideshow%2Fembed_code%2F39562297&amp;url=http%3A%2F%2Fwww.slideshare.net%2Fandrewfogg%2Fhow-much-does-prostitution-contribute-to-the-uk-economy&amp;image=http%3A%2F%2Fcdn.slidesharecdn.com%2Fss_thumbnails%2Fhowmuchdoesprostitutioncontributetotheukeconomy-140926070916-phpapp01-thumbnail-4.jpg%3Fcb%3D1411733767&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=slideshare" width="425" height="355" frameborder="0" scrolling="no"><a href="https://medium.com/media/ad083d01f5d5912f75207d355ab608d2/href">https://medium.com/media/ad083d01f5d5912f75207d355ab608d2/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e5b7fd672f4a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Using data to create a personality test that will tell you how to vote in the Scottish referendum]]></title>
            <link>https://medium.com/@andrewfogg/using-data-to-create-a-personality-test-that-will-tell-you-how-to-vote-in-the-scottish-referendum-8adbdda7dbf4?source=rss-3c9697a4199e------2</link>
            <guid isPermaLink="false">https://medium.com/p/8adbdda7dbf4</guid>
            <dc:creator><![CDATA[Andrew Fogg]]></dc:creator>
            <pubDate>Thu, 18 Sep 2014 19:28:09 GMT</pubDate>
            <atom:updated>2014-09-19T19:35:32.744Z</atom:updated>
            <content:encoded><![CDATA[<h4>The Scottish referendum is happening <a href="http://en.wikipedia.org/wiki/Scottish_independence_referendum,_2014">today</a>.</h4><p>The date was set <a href="http://en.wikipedia.org/wiki/Edinburgh_Agreement_(2012)">two years</a> ago but it feels like the British public (English, Scottish, Welsh and Northern Irish alike) only just sat up to take notice in <a href="https://www.google.com/trends/explore#q=scotland&amp;date=1%2F2014%209m&amp;cmpt=q">the past 10 days</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*318gB1kMc67POBE7otsHNQ.png" /></figure><p>The political debate has all of a sudden erupted into noise and confusion and it made me wonder how people should vote.</p><p>I used <a href="http://www.panelbase.com/media/polls/F4108w15tables.pdf">the latest opinion poll data</a> to create a <a href="http://www.playbuzz.com/andrewf12/which-way-should-you-vote-on-scottish-independence">personality test</a> that tells people how they should vote in the Scottish referendum. If you have not done so already, you should <a href="http://www.playbuzz.com/andrewf12/which-way-should-you-vote-on-scottish-independence">take the quiz now</a> and share your result.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/644/1*BaYDyvztkykGj-1EVeHJLA.png" /></figure><p>There are nine questions in the quiz covering gender, age, place of birth, socio-economic status, party political affiliation, the economy, public spending, taxes and currency. The answer to each question determines whether you end up being told that you should vote Yes or No.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wqkdfjw1V4h4c_T0-Fc8VA.jpeg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*d9Ol-qYhV0xDeqw4cjd8wg.jpeg" /></figure><p>If you have taken the test and are wondering how you ended up with your result, the graphs below should help you. Each graph represents the data that sits behind each of the nine questions. By quickly scanning through each graph you should be able to work out how your result was calculated. And remember all this data is real and is based on the <a href="http://www.panelbase.com/media/polls/F4108w15tables.pdf">very latest opinion poll</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*dCEb5rhXTYe3lWUhUUFq1w.png" /></figure><ul><li>Men are more likely to vote <em>Yes</em></li><li>Women are more likely to vote <em>No</em></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*O7Z5nPoTnvgn8GQvG2KSlw.png" /></figure><ul><li>Younger people are more likely to vote <em>Yes</em></li><li>Older people are much more likely to vote <em>No</em></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*j58uovpxuAIRLWYPQ7g5cA.png" /></figure><ul><li>Scottish residents born in Scotland are more likely to vote <em>Yes</em></li><li>Scottish residents not born in Scotland are much more likely to vote <em>No</em></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*rCsFDrB8ohfoSUo0RMCi8w.png" /></figure><ul><li>People of a higher socio-economic group are more likely to vote <em>No</em></li><li>People of a lower socio-economic group are more likely to vote <em>Yes</em></li></ul><p>There are six <a href="http://en.wikipedia.org/wiki/NRS_social_grade">NRS Classifications</a> based on the occupation of the head of the household. In order to simplify things for the quiz I just made it about whether you work in an office or not.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*GqO2n-RM72zDYr9MmlpH_Q.png" /></figure><ul><li>People who voted for any of the three major parties (Conservative, Labour, Liberal Democrat) in the 2011 election are much more likely to vote <em>No</em></li><li>People who voted for either the Scottish National Party or other minority parties in the 2011 election are much more likely to vote <em>Yes</em></li><li>People who did not vote, did not remember who they voted for or were not eligible to vote in the 2011 election are more likely to vote <em>No</em></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*tjxvLzMkJ5pL4uqGJ89Fmg.png" /></figure><ul><li>People who think that an independent Scotland will be economically worse off are much more likely to vote <em>No</em></li><li>People who think that an independent Scotland will not be economically worse off are much more likely to vote <em>Yes</em></li><li>People who don’t know whether or not an independent Scotland will be economically worse off are more likely to vote <em>Yes</em></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*aLWJ85qC-xw1wXRTaASlvQ.png" /></figure><ul><li>People who think that an independent Scotland will cut public funding are much more likely to vote <em>No</em></li><li>People who think that an independent Scotland will not cut public funding are much more likely to vote <em>Yes</em></li><li>People who don’t know whether or not an independent Scotland will cut public funding are more likely to vote <em>Yes</em></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*j-KhC6_3YReZUlvavvZhZA.png" /></figure><ul><li>People who think that an independent Scotland will raise taxes are much more likely to vote <em>No</em></li><li>People who think that an independent Scotland will not raise taxes are much more likely to vote <em>Yes</em></li><li>People who don’t know whether or not an independent Scotland will raise taxes are more likely to vote <em>Yes</em></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*SkTBrYg1dC3iWQ5tYp2W-w.png" /></figure><ul><li>People who believe that an independent Scotland will be able to keep the pound are much more likely to vote <em>Yes</em></li><li>People who believe that an independent Scotland will not be able to keep the pound are much more likely to vote <em>No</em></li><li>People who don’t know whether or not an independent Scotland will be able to keep the pound are more likely to vote <em>No</em></li></ul><p>What is clear from the opinion poll data is that economic issues are the key factor in determining how people will vote.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/836/1*3yvPdcJ4Jjl0Wlt5N8dzVA.jpeg" /></figure><p>I have been using quizzes and personality tests a lot in my recent work here at <a href="http://blog.import.io/post/using-data-to-create-a-personality-test-that-will-tell-you-how-to-vote-in-the-scottish-referendum?utm_source=andrewfogg&amp;utm_medium=content&amp;utm_campaign=scotland">Import.io</a>. They are a great way of sharing and using data to inform and educate an audience because they change the relationship that the audience has with your data and your message.</p><p>Usually when we talk about data we are using it to tell big stories about general concepts and aggregate trends. As an individual these big-concept stories can sometimes be quite difficult to relate to.</p><p>A personality test changes that. It uses aggregate data to create something that is very personal to the individual. And the individual is left with something that they will want to share, which will help to spread your message further.</p><h4>Visit <a href="http://blog.import.io/post/using-data-to-create-a-personality-test-that-will-tell-you-how-to-vote-in-the-scottish-referendum?utm_source=andrewfogg&amp;utm_medium=content&amp;utm_campaign=scotland">Import.io</a> to learn more about what I do with data.</h4><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8adbdda7dbf4" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>