Monthly Archives: August 2017

Database Fun – Art Collection

I’ve posted quite a bit regarding my love for Excel and Pivot Tables, but I haven’t actually mentioned my other source for data-crunching fun – Microsoft Access. Occasionally, I’ll come across some data structure or method of viewing that can’t be accomplished using Excel (or can’t be accomplished well). That’s when I’ll jump into database design. One example of this

Read more

Mass Shooting Research Part 3; State Comparisons, GVA Data

I mentioned in a previous article on this topic that I also wanted to explore the state-by-state numbers, but needed to finish processing data from Census.gov. Well, that is now done, so I’m going to explore what I found. I think this will be my last post on mass shooting data analysis, unless something new surfaces. Previous articles: Part 1,

Read more

Cryptocurrency Exploration

Prior to this week, I honestly didn’t know too much about cryptocurrency. I knew the basics, mostly hearing or reading about Bitcoin. I knew there were other types, but had no clue how many. I’ve even got a “if only I would have” story about it; I considered buying some for fun around 2010-2011, but didn’t care enough about it

Read more

Airline & Airplane Seat Comparisons

Updated research on this topic can be found here: Airline Fleet Totals, Leg Room Analysis Revisited. This more recent article integrates fleet totals for a more complete view of seat pitch distribution across airlines. Research on the topic of airline and airplane seat size comparisons was triggered by an article I read recently. Unfortunately, I can’t remember where the article

Read more

Mass Shooting Research Part 2 & Rampage Events

In the previous post, I explored Mother Jones’ data on mass shooting events in the U.S. What they collected was impressive in depth, but only seems to cover a small subset of violence that falls under the “mass shooting” definition (four or more shot and/or killed in a single event [incident], at the same general time and location, not including

Read more