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
    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
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 Min Read
    pexels pavel danilyuk 8112119
    Data Analytics Is Revolutionizing Medical Credentialing
    8 Min Read
    data and seo
    Maximize SEO Success with Powerful Data Analytics Insights
    8 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

business Data and AI
How to Prepare Your Business Data for Artificial Intelligence
Is My Data Really Mine?
Watson’s Linguistic Struggles
7 Powerful Open Source Tools For Your Data Projects
Putting your ultimate asset to work with decision management

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

Generative AI models
Thinking Machines At Work: How Generative AI Models Are Redefining Business Intelligence
Artificial Intelligence Business Intelligence Exclusive Infographic Machine Learning
image fx (2)
Monitoring Data Without Turning into Big Brother
Big Data Exclusive
image fx (71)
The Power of AI for Personalization in Email
Artificial Intelligence Exclusive Marketing
image fx (67)
Improving LinkedIn Ad Strategies with Data Analytics
Analytics Big Data Exclusive Software

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

3 Big Data Myths for Enterprises

5 Min Read

Top 5 Reasons R is Good for you

4 Min Read

Igniting the New Intelligence

0 Min Read

Learning SPSS for SAS users

4 Min Read

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

ai chatbot
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots
data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data

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?