My Life in a Tree Map

Grand Teton, WY. Photo: Amie

How does my life compare to the average American’s? What does my ideal day look like? With data from the Bureau of Labor Statistics (BLS), Google spreadsheets, and problem-solving skills, let’s conduct some analysis with Tree Maps.

Continue reading “My Life in a Tree Map”

How to Track & Analyze Spending

Where does your money go? This is an important question, because it gets to the heart of basic money management and personal finance. Let’s discover and create a spreadsheet application that tracks and analyzes your spending!  Continue reading “How to Track & Analyze Spending”

How to Visualize Data

Is the typical New Yorkers’ overall “well-being” better than that of the national average? Nope! How did we quickly conclude this? Check out the graph to the right. Data visualization is an effective (and fun) way to understand information!

Too much information can be overwhelming. But there are ways to channel the desired data and convey it in a way that makes it quick and easy to understand. Let’s discover the power of data visualization by creating a flexible, automatic tool shown below. To see this tool live in action, see our 2-minute video below:

Continue reading “How to Visualize Data”

How to Create Charts in Google Spreadsheets

"How I Met Your Mother."  Source: YouTube
“How I Met Your Mother.” Source: YouTube

Charts are everywhere – books, newspaper articles, magazines, ads, and even TV shows [Click here for a video clip of How I Met Your Mother]. Valuable, practical, and fun, charts enable us to visualize and understand data. In 3 steps, you can build any chart in Google spreadsheets. Continue reading “How to Create Charts in Google Spreadsheets”

ABCD: Analyzing Big College Data

© Photographer Daniel Gilbey|Agency:

The college decision is a big one. Are you deciding which college(s) to apply to or which one to attend? Or are you in middle or high school and interested in attending college someday? Or have you already graduated from college?

For all, let’s explore essential skills by analyzing data across 202 U.S. colleges! Continue reading “ABCD: Analyzing Big College Data”

Pampered Pooches: Is Pet Spending Recession-Proof?

Sushi (Photo: May Ko)

When asked which child she adores most, my mom would remark without hesitation, “Sushi is my favorite.” Sushi is an adorable 7-year-old schnauzer. As many may relate, pets are a part of the family, with a few lucky ones elevated to “favorite child” status. Continue reading “Pampered Pooches: Is Pet Spending Recession-Proof?”

NYC Subway Passenger Habit Charts

© Photographer Oscar1319 | Agency:

The Metropolitan Transportation Authority (MTA) recently published an observational study of subway rider seating behavior. Collecting data over three weeks in late winter 2012, the researchers published their findings on rider seating preferences in a draft report: who finds seats when the train is crowded? Do standing riders prefer vertical bars or graspable handles?  Which seat type do sitting riders take:  seats near a door or bench spots?

Based on some of the data from the report, let’s create visuals – charts that offer us a glimpse into some questions: Continue reading “NYC Subway Passenger Habit Charts”

Pivot Table & National Volunteering Month

April is National Volunteering Month, so let’s celebrate!  What better way is there to celebrate than to honor those who devote themselves to their communities while simultaneously mastering a pivot table?  That’s right – you heard me!

Continue reading “Pivot Table & National Volunteering Month”

How many languages do you speak?

[polldaddy poll=6994482]

Over the past several months – or years for that matter – there has been a rush among American parents to teach kids Mandarin.  After-school language classes have emerged, immersion programs are gaining popularity, and videos and phone apps focused on languages have sprung up!

A recent Economist article, “Valued-Added Remodeling” (March 16, 2013) even noted that Jack Markell, Delaware’s governor, plans to expand immersion programs, such as those seen in the kindergarten classroom of Mcllvaine Early Childhood Center, where children are taught solely in Mandarin for half of each day.

Now, what’s the connection between our language skills and a spreadsheet? Continue reading “How many languages do you speak?”

Employment Patterns by Gender since 1948

In honor of Women’s History Month in March, check out our poll below:  what percentage of the work force consisted of women in 1948?  Keep in mind that just 28 years prior to 1948, women were first granted the right to vote.   How have employment patterns by gender changed over time?  Let’s use our spreadsheet problem solving skills to figure this out!

[polldaddy poll=6991261]

Continue reading “Employment Patterns by Gender since 1948”