Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    sales and data analytics
    How Data Analytics Improves Lead Management and Sales Results
    9 Min Read
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Exploratory Analysis with Excel
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Exploratory Analysis with Excel
Big Data

Exploratory Analysis with Excel

Alex.Matthew
Alex.Matthew
5 Min Read
SHARE

When it comes to data science, we often find that people first start out learning using Microsoft Excel.  Inevitably, as students progress, Excel starts to appear quaint as they transition to more powerful systems like R or Python. After a while, however, a lot of people end up coming back and realizing that maybe Excel isn’t so bad after all. 

When it comes to data science, we often find that people first start out learning using Microsoft Excel.  Inevitably, as students progress, Excel starts to appear quaint as they transition to more powerful systems like R or Python. After a while, however, a lot of people end up coming back and realizing that maybe Excel isn’t so bad after all. 

Although data scientists sometimes look down their nose at Excel, we’ve put together a tutorial, along with data scientist David Taylor, that shows that you can do a suprising amount of complex analysis just using basic Excel fucntions. 

We set out to to prove this by walking folks through an analysis of baby names from California based on the United States Social Security Baby Names Database. The Social Security database, which goes back to 1880, has some weird and wonderful anomalies.

More Read

Publicly Traded Companies + Empire Avenue = Very. Bad. Idea.
Why AI Cannot Survive Without Big Data
Recommendations Lose Their Luster
How Artificial Intelligence is Transforming the Corporate World
Cloud Metadata Is Making Waves with Business Intelligence

For example, David uncovered an interesting (and bizarre) trend of boys’ first names ending in the letter “n” during the latter half of the 20th century.  This is reflected in the provided GIF, which also covers the tragic rise and fall of the letter “d.”  “N”s truly meteoric ascent is one of many fun, and telling, insights that can uncovered through applying some simple Excel functions to a large data set. 

The rise of the letter "n" in boys' last names.

Also, if you explore the names, you’ll notice a trend that impacts girls names far more than boys: a quick rise from obscurity to popularity, then as the name becomes too trendy, a descent to obscurity again.  With boys, you generally see more steady patterns (like the letter “n” at the end of names). Look up names like Mason, Ethan and Jayden, you’ll see them all rise from obscurity to prominence in the 2000s, and many of them are just starting to dip again as of 2013.

Did you know that babies only started routinely having social security numbers starting in 1986? You can see this in the data too. For example, a baby would be much more likely to have the name “Peter” on his official documents than the nickname “Pete”. But if, when a young man or older filled out a tax return or applied for Social Security, he would be more likely to use the name he went by in day-to-day life, which might be a nickname he’d been called since he was a boy.

Finally, as one would expect from anecdotal experience, there is more diversity in names now than there was fifty years ago. In addition, female names are more diverse than male names. Perhaps parents want their girls to stand out more? The changes in diversity track pretty closely between the sexes. This suggests that the difference is due to something intrinsic to the difference between girls’ and boys’ names, not momentary trends. Perhaps the explanation is simple: there is more diversity in girls’ names because there are more spelling variations in girls’ names, like ‘Ann’ and ‘Anne’ and ‘Anna’.

All of these insights were uncovered using intermediate Excel functions like pivot tables, pivot charts, ratios, and filters. We hope this tutorial will help beginners (and experienced data scientists alike) learn some basic steps to take when they first confront a huge chunk of data and want to do some exploratory analysis.  

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

sales and data analytics
How Data Analytics Improves Lead Management and Sales Results
Analytics Big Data Exclusive
ai in marketing
How AI and Smart Platforms Improve Email Marketing
Artificial Intelligence Exclusive Marketing
AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

big data and retirement
Big DataExclusive

How Big Data Could Spare Seniors From A Terrifying Retirement Crisis

6 Min Read

Short-term “Trouble for Big Business Intelligence Vendors” may lead to longer-term advantage

5 Min Read

Twitter @ddata Discuss Data bot

1 Min Read
Protect Customer Information
Big DataSecurity

Practical Ways to Protect Customer Information

5 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?