Editor's Note: This blog post first appeared in August 2011, at the end of blogger Jennifer Baulier's summer internship. We are republishing her blog post now that JMP 10 has been released and the Micromaps add-in discussed in the post is now available in the JMP File Exchange. JMP 10 is the minimum version required to create Micromaps using this add-in. Download of the add-in requires a free SAS profile.
My name is Jennifer Baulier, and I am a summer student at JMP. I attend college at WPI (Worcester Polytechnic Institute), and applied for my internship at SAS through the R3 program. I am going into my sophomore year and am studying both computer science and video game development. I have really loved my time here and have learned a lot especially while working on my Micromap project, which is explained below.
In June, Xan Gregg blogged about a Micromaps presentation by Dan Carr. At the time, Graph Builder could approximate Conditional Micromaps minus a few key features. My project adds on to what Graph Builder was already doing in order to recreate several types of Micromaps (Comparative, Conditional, and Conditional with Percent Difference).
The main point of Conditional Micromaps is to allow the user to look at trends between regions and three additional variables set to X, Y, and Color. The image above is an example report. My Conditional Micromaps are different from what Graph Builder already does because 1) the user chooses three ranges for the X, Y and Color groupings, and 2) the user can modify ranges on the fly with slider bars. In my Micromaps, the color groupings always increase from blue, to grey, to red. In the example shown above (where X is expenditures, Y is student/faculty ratio, and color is ACT scores), Texas has low expenditures, a low student/faculty ratio, and medium ACT scores. A few trends in the image above:
Unlike Conditional Micromaps, Comparative Micromaps are not very close to anything that already exists in Graph Builder. The center panel is a set of maps organized by an X grouping and split into three color ranges chosen by the user, which can be updated with the slider. The top and bottom panels show changes from one color to another between groupings. The top panel shows increases while the bottom shows decreases. In the example, the states shown are colored by average unemployment rate across a set of years. If you look at Florida, you can see that in 2007 it was blue, but in 2008 it increased to gray. Since it changed to a higher category, Florida is colored gray in the top panel map for 2007 to 2008. Several major trends appear:
Comparative with Percent Difference (shortened to “Percent Difference” later in this description) is a variation on Comparative Micromaps that I implemented. Like Comparative, the center panel shows the data over some X grouping, and the top and bottom show increases and decreases. Instead of displaying the color in terms of three ranges, the color is displayed in a continuous gradient. Also, instead of the top and bottom panels showing increases or decreases between color ranges, they show increases or decreases for which the change is at least N percent different. N is chosen by the user and can be interactively changed with the slider. The image above shows Triangle (North Carolina) real estate values over time. The shapes shown on the map are based on ZIP codes (I created custom shape files using data from the US Census Bureau). The slider is set to a fairly low percent so that most changes will show up on the map. Note the following:
Both types of maps are useful, but there are certain situations where using one opposed to the other would make a significant difference.
Comparative is most useful when:
Percent Difference is most useful when:
Micromaps are a clear and concise way to view both regional trends and correlations in data. Furthermore, the interactive nature of the maps makes it easy to adjust the report in order to find helpful information. Comparative and Percent Difference Micromaps focus on deltas while Conditional Micromaps focus on correlations.
The slider bars in this project are not a standard display box item and were my design. You may see two-prong as a display box item in future versions of JMP as a result of this project.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.