Terrible Data Visualization

This Map is Crap.

I have noticed a popular link on Social Media sites that leads to an interactive map. This map shows colorful circles over a world map. With link titles like, “One map sums up the damage caused by the anti-vaccination movement,”it gives the illusion that these explosive circles are the recent result of reduced vaccinations.

I am extremely pro-vaccine, but this is not the type of chart we should look at for the subject of vaccines and preventable dissease. Here are some of the key issues with this map:

This chart is not about vaccination.

• Vaccination rates are not pictured at all on this chart.

This is a bad way to visualize data.

• The dots for 1 case are nearly the same size as the dots for 175. Even by sliding the slider through the years, you can’t see if the cases are increasing or not because the dot size is mis-leading. If the authors were more interested in isolated outbreaks than number cases, then it’s still a problem because there are dots for combined outbreaks, as explained below.


• Using the number of cases doesn’t take into account population in that region.

The downloaded data is sloppy and doesn’t match the map.

• The list of sources is various news articles, including articles about the country as a whole, as well as local articles that talk about breakouts in a specific county.

  “Leaders at the Centers for Disease Control and Prevention (CDC) are expected to hold a media tele-briefing at 12:30 p.m. Thursday to address the recent spike in measles cases in the U.S. As of November 30, there have been 175 cases reported in 2013.”--WXYZ Deroit News

  I believe that this is shown as a single dot in the center of the US, as if it was a single outbreak in Kansas.

  “4 Measles cases confirmed in Orange County: Orange County Health Officials are warning about a measles epidemic that they say is putting everyone in Central Florida at risk.”--WKMG local 6 Orlando

• The whole-country CDC numbers no doubt include the numbers from local municipalities, so they should not BOTH be listed.


• The CDC and the WHO report that there were nearly 2,000 cases of Mumps in the US in 2009, and yet the interactive map shows 12 cases.


• Good data on disease incidence is easily available from the World Health Organization and within the US, the CDC. I don’t know why the authors would use data-mined local news reports when there government departments who professionally tabulate this data.

A New Graph

I made my own chart to address the rates of vaccination and illness rates. I choose to use the US because I live here, and I choose the MMR vaccine because I think that Rubella, Measles, and Mumps are very serious diseases that should be eliminated. My mother contracted Rubella (German measles) while pregnant with my sister in the 1960’s, before the rubella vaccine was available. Beth Ann was born severely retarded, deaf, and nearly blind. This is an extremely serious disease that many young people haven’t even heard of.

For my graph, I used data collected by the CDC and WHO. I took into account the changing population of US by presenting the data as cases per million Americans. You can see my raw data and detailed list of sources here .

Click here to view a large PDF of this graph.

Reflections from this graph

• Based on my own anecdotal experiences, I expected to see a sharp recent increase in unvaccinated toddlers, but I don’t see that.


• I was also amazed to see how serious the Mumps outbreaks in 2006 and 2009 were.


• It’s hard to see a strong correlation in this data between vaccination rates and disease prevalence, but it’s hard to know what type of correlation to expect. I would guess that there would be a time-delay in decreased vaccination and then later an increase in disease. How long of a delay? Another complication is possibility of a threshold effect, where the slightest change in vaccination could have a huge effect for disease.

Future Directions

• Who are these ~10% of unvaccinated kids? Are they vaccine objectors, or are they parents who haven’t bothered to vaccinate their kids yet because they forgot, or because of the cost?


• It would be really informative to see vaccination rates for adults as well. This data is for kids who are past-due for their MMR vaccine, but do they eventually get vaccinated?


• I wish I had data for a longer time span.


• Small geographic areas of high non-vaccination could have a huge impact on disease. A friend sent me a link to this interesting peer-reviewed map made using highly localized data on both disease and vaccination in the Netherlands. I like this figure because it appears to be carefully and accurately drawn, with each circle representing an individual outbreak.

I made an educational Video about PCR using the paper tactile model I designed in 2009.  To the best of my knowledge, this is the only hands-on PCR learning tool around, so I decided to make a video showing how to use it.  



The novel concept behind the paper model is that the primer has a string hanging off the 3' end, and the dNTPs are beads.  So, to start making a strand of DNA, you need to start with a primer (because it has the string).  DNA replication also has to start with a primer.  Watch the video if you want to learn more about it.

I taped the video in my living room using a webcam and a headset microphone.  I edited the video in Adobe Premiere.  Finding music for your videos is real challenge these days.  I chose fan-recorded music from a live Grateful Dead concert, because it’s my understanding is that the Grateful Dead allows people to use that.  You Tube puts ads over your video if you use regular music, and I didn’t think that ads coving the video was in the spirit of a free educational tool.

I recently received a welding helmet as a gift and I decided to make sure people would know it was mine by painting it with Posca paint markers.
Thus far I have not done any type of clear coating over it.  If you scrape the paint with your finger nail you can remove it, so a shellac might be required for long term preservation.  I am going to try it out as-is and see how it wears.

Roots Music Christmas!

Consider giving your holiday mix a warm-up with these Christmas songs that you aren't tired of.
I heard many of these for the first time on the Root Music Project Radio Program.



God Rest Ye Merry Gentlemen - The Legendary Shack Shakers iTunes
Got to Get You Under my Tree - Sonny Landreth iTunes
Last Month of the Year - Tarbox Ramblers (recently removed from iTunes, so get the Chris Isaak version instead)
March of the Toys - Tommy Dorsey and His Orchestra iTunes
Merry Christmas from the Family - Robert Earl Keen iTunes
O! Santa - Chathum Country Line iTunes
Pimp My Sleigh - Houseman iTunes
Sugar Rum Cherry - David Berger and the Sultans of Swing iTunes
(There's no Place like) Home for the Holidays - Leon Redbone iTunes
We Three Kings - Los Straitjackets iTunes
White Christmas - The Ravens iTunes
You're a Mean One, Mr. Ginch - Thurl Ravenscroft iTunes
Zat You Santa Claus - Ingrid Lucia iTunes

How to calculate the area of an object and length of a path in Adobe Illustrator using Scripts.

I have needed to calculate the area of a shape in order to determine the acreage of a perspective property plot, and to measure the length of a pen-tool-traced transgenic seedling root. Measuring area, perimeter, and length is not built into Illustrator, but there is an easy work around.

This technique should work for all recent (perhaps all) versions of Adobe Illustrator. Telegraphics makes a nice plug-in for finding area and lengthlength in Illustrator, but it doesn’t work for the lastest versions: Adobe Illustrator CS6 nor Adobe Illustrator CC. The technique I will describe here is just as easy to use, and more universal.

• Step 1: Either download this file, or make one yourself.
To make it yourself, paste this text into a simple text file (like notepad):

alert("Area & Length (inches)\nArea: " + (Math.abs(app.activeDocument.selection[0].area/5184).toFixed(3)) + "\nLength: " + (app.activeDocument.selection[0].length/72).toFixed(3));

Save the file as AreaLength.JS


• Step 2: Open your file in Illustrator and select the path or object that you want to measure.


• Step 3: Click on “FILE” and scroll down to ‘scripts.’ Select “Other Script.” A file dialog window should open up. Find and select AreaLength.JS. A small window will pop up that states the area and length/perimeter in inches.





Some details & options

Do you plan to use it often?

Then you might want this script to appear on the quick menu within illustrator so that you don’t have to navigate through your files every time you use it.

Here is where I put it on my PC to successfully make it show up in the menu:

C:\Program Files\Adobe\Adobe Illustrator CC (64 Bit)\Presets\en_US\Scripts

Rounding

This script rounds the decimal points to 3. If you want more or less, you can open AreaLength.JS in notepad/text editor and change “toFixed(3)” to a different number. I would like to thank the Adobe community for the tips on rounding.

Units

Would you like to measure your paths in other units instead?

Change the text in the file.

Centimeters

alert("Area & Length (centimeters)\nArea: " + (Math.abs(app.activeDocument.selection[0].area/803.521617).toFixed(3)) + "\nLength: " + (app.activeDocument.selection[0].length/28.346567).toFixed(3));

Millimeters

alert("Area & Length (millimeters)\nArea: " + (Math.abs(app.activeDocument.selection[0].area/8.03521617).toFixed(3)) + "\nLength: " + (app.activeDocument.selection[0].length/2.8346567).toFixed(3));

You can change it other units too. The default would give you the units in px, and there are 72 px per inch. Thus, in the ‘inch’ unit script we take the length is divided by 72, and the area is divided by 5184, which is 72 squared. If you make a new script, I recommend testing it on a shape of known size. You can do this by selecting the rectangle tool, single clicking once on the canvas. A dialog will pop up. Type in “1 cm” for width and “1 cm” for height (for example).

How to add color to a grey-scale/black & white microscope image

Using Adobe Photoshop (any version)

Show your true colors

These steps work in any version of Adobe Photoshop.  The interface looks very slightly different in different versions, but I think you will be able to follow this just fine.

Step 1: Open your black and white image in Photoshop
Step 2: On the lower side of the layers pallet, click on the small round button that looks like a black and white cookie (see photo below with arrow pointing to it).

Can't see your layers pallet?  Never fear, you can find all pallets under the menu at the top called "WINDOW."  (It's in the same row as File, Edit, Image, Layer, Type, etc.)  Look down the list under WINDOW and check Layers.



Step 3: The black and white cookie button (formally known as the the "create new fill or adjustment layer" button) will open a list of options.  Choose "solid color."



Step 4: Pick a color.  Click OK.



Step 5: Your entire image is now just solid color.  Don't panic.  Again, look to your layers pallet and find the pull-down menu that currently says normal.  This is the blending mode menu. Change it from "Normal" to "Color".



Theory behind blending modes: Blending mode changes how the pixels on this layer will interact with the layers below.  "Normal" means that they will just stack on top, thereby covering the layers below.  Each of the other blending modes are different algorithms.  For example, "darken" means only the dark pixels on this layer would show and the light pixels won't show.  For this tutorial, you probably want to stick with "color."



Step 6: Your image should be colorized now.  In addition to saving as a JPEG or whatever format you want to use this image as, also save as a Photoshop file (.PSD) so that you can retain a record of how the colorizing was done, and also so that you can change the color later with ease.





Whenever you open your PSD file, you will still see your color layer in the layers pallet above your black and white original image.



You can always click off the 'eye' on the colorizing layer to see your grey-scale image below.  Re-click it to turn the eye back on.

Changing the Color

It's easy to change the color later if you save the file as a PSD.  Just double click on the colorful part of your colorizing layer and pick a new color.  Click OK.

DIY Business Card Edge Painting

Works on white cards too

I recently ordered some business cards from Card Sox.  I got 500 square, rounded corner, spot UV (2 sided) cards for less than $100 including delivery.  However, Card Sox does not offer edge painting.  The cards I received look good, but there is a more wobble on the cutting than I am used to.  Because my cards have a boarder, it’s noticeably uneven on many.  I recommend Card Sox if your cards do not a boarder.

Here are the cards before edge painting:


Edge painting is when the thin side of the card is painted a bright color.  Traditionally, this process can only be done to black cards because some bleeding-in of the paint is enviable and would show up on white cards.

After reading some great blogs (This one recomends sponge brush, and this one details how spray paint doesn't work, this one recomends sharpie, that didn't work well for me.), I decided to give it a try with my new cards.  I found a type of paint (Viva Metallic Rub)  at JoAnn’s craft store ($6.5) that did a great job.  I even tested it on some older white cards I had laying around, and it works great.  This paint does not bleed in.  



You don’t need the clamp but it’s handy.  Don’t over tighten it or it will actually make the edges fan out.  You definitely want to use a sponge brush.  It’s tempting to rub it on with your fingers, but that results in too much product being applied and unnecessary flacking off.  Although expect some flakes of paint when you first ‘shuffle’ the cards no matter how you apply the paint.  I un-stacked them immediately to prevent the cards from sticking.  This rub-paint is not runny, so if you separate them right away it won’t be too messy.  It seems to dry within an hour or so.