Name: How To Do A Basic Data Analysis In Excel (CHART INCLUDED!) | Videos | Gan Jing World
Uploaded: 2023-12-08T23:02:44.553Z
Duration: 29 min 6 s
Description: Welcome back to Day 9 of 30 Day Excel Analyst – transforming your analytical skillset in 30 days. Today’s session is the first in data analysis week. Excel da... | Videos | Gan Jing World

Tiger Spreadsheet Solutions

https://video2-us-west.cloudokyo.cloud/video/v6/51/67/d8/5167d879-c64a-434e-9058-5b5f832b1ea8/master.m3u8

Welcome back to Day 9 of 30 Day Excel Analyst – transforming your analytical skillset in 30 days.  Today’s session is the first in data analysis week.  Excel data analysis is something every professional must do at some point, and it’s an absolute must for the Excel Analyst.  So, let’s get to it!

💻DOWNLOAD THE RESOURCES
https://tinyurl.com/2tb2sbst
🔥30 DAY EXCEL ANALYST PLAYLIST
https://tinyurl.com/4439xtnb
🔥FIRST VIDEO IN THE COURSE
https://youtube.com/live/CF-Y46c829Q

In this session, I show you how to analyse a continuous numerical dataset in Excel.  Stats terminology alert!  What on earth is ‘continuous numerical data’?  As we will learn this week, the key to easy and powerful data analysis in Excel is to understand the nature of the data you are analysing.  A simple starting point: is the data text-based, or is it numerical?  And, if it’s numerical, does it comprise one of a limited number of options (rating a service from 1 to 5, for example)?  Or, is it better described as ‘any number in a range’ – with no (or few) numbers in the dataset being the same?

If your dataset falls into the last category, you’re dealing with ‘continuous’ numerical data.  One example is the fictional ‘Dogbit’ app that we feature in this session.  The Dogbit app records how far your dog walks each day.  That means lots of different numbers since even the best trained dog is unlikely to walk exactly the same distance each day!  It’s a continuous numerical dataset, so how to get started analysing it in Excel?

I’ve been surprised over the years how few professionals can do this kind of analysis with confidence.  I’ll take you through it step-by-step by step in this video, and we’ll see how applying averages only can create a misleading picture.  We’ll examine two datasets that might look similar at first glance but are actually very different.  To really understand what’s going on, you need go beyond averages, applying concepts of central tendency and dispersion via Excel formulae.  We’ll apply one of my Excel secret weapons to really convey the nature of the two datasets with a beautiful visual – you might be surprised by what we discover.

Most importantly, however, the session will equip you with an easy method to tell the full story of continuous numerical data in Excel.  Welcome back to 30 Day Excel Analyst, and welcome to data analysis week!

FOLLOW UP RESOURCES
🔥30 DAY EXCEL ANALYST PLAYLIST
https://tinyurl.com/4439xtnb
🔥CAN'T DO DATA ANALYSIS IN EXCEL? JUST DO THIS!
https://youtu.be/zGOx8NcRrXw
🔥WHY I DON'T USE EXCEL TABLES
https://youtu.be/fJ-cKbJs1Nc
🔥HAVE EXCEL DYNAMIC ARRAYS CHANGED THE GAME?
https://youtu.be/cD0cCcmSpkA
🔥EXCEL VBA BEGINNER BUILDING BLOCKS
https://youtu.be/O6zfwuCr1cg
🔥MAKE EXCEL BEAUTIFUL: 14 EXCEL FORMATTING TIPS
https://youtu.be/E6el9uIJphQ
🔥WHEN YOU SHOULD USE INDIRECT
https://youtu.be/L_EZ7k05vpY
🔥THE 72 THINGS YOU NEED TO KNOW IN EXCEL
https://youtu.be/Xp3aTZ2nO2I
🔥STOP FILTERING EXCEL
https://youtu.be/Qi1nfN5F8F4
🔥LEARN EXCEL VBA WITH THIS 5-HOUR WALKTHROUGH PROJECT
https://youtu.be/igeLpQtDBUE

🔥READ MORE ABOUT OUR PROFESSIONAL EXCEL DEVELOPMENT COMMUNITY: MEMBERS MONDAY
https://tinyurl.com/2p8wy5dr