Riders VS Collisions by State

Using the data provided I created a Tree map to display the data as best I could.

Click here to view my Tableau Public worksheet.

Unfortunately due to the sytem i use to for my block embeding the worksheet does not work.

I created a tree map sorted by year and city to look at ridership and comparing that to collision for each area visualized. The bigger areas on the chart are the areas with higher vehicle revenue miles. I had orginally used ridership but really was unable to undesstand what that column ment. I could of looked it up but for the sake of this excersie, vehcile revenue miles seemed to make a little bit more sense. The graphic above shows ridership while the one below shows revenue miles.

This changed adjusted how the chart looks. This made it a little easier to determine a corelation between miles ridden and accidents occured. Both charts however do not show causation. While the bigger boxes show more miles riden they do not always mean that there is more collisions when more miles is ridden. It seems to be some cities over the years just seem to have more crashes than other. Based on what i know about each city I would assume that the more crowded or densely populated the city/region the more likely a collision will occur.

This was an interesting excersie and while treemap may not be the most effective way to show this data it definitely helped me get ideas for how this data can be used and other forms of charts that it can be used with.