Category Archives: Charts & Data Visualization

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 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

ABCD: Analyzing Big College Data

© Photographer Daniel Gilbey|Agency: Dreamstime.com

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

Pampered Pooches: Is Pet Spending Recession-Proof?

sushi

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

NYC Subway Passenger Habit Charts

© Photographer Oscar1319 | Agency: Dreamstime.com

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

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

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

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