How To Do A Basic Data Analysis In Excel (CHART INCLUDED!)
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!
• Can’t Do Data Analysis In Excel? Just...
🔥WHY I DON'T USE EXCEL TABLES
• Why I Don't Use Excel Tables
🔥HAVE EXCEL DYNAMIC ARRAYS CHANGED THE GAME?
• Excel Dynamic Arrays 3 Years On - Hav...
🔥EXCEL VBA BEGINNER BUILDING BLOCKS
• How To Write Your First Excel VBA Mac...
🔥MAKE EXCEL BEAUTIFUL: 14 EXCEL FORMATTING TIPS
• 14 Excel Formatting Tips (Make Excel ...
🔥WHEN YOU SHOULD USE INDIRECT
• When You SHOULD Use INDIRECT
🔥THE 72 THINGS YOU NEED TO KNOW IN EXCEL
• The 72 Things You Need To Know In Exc...
🔥STOP FILTERING EXCEL
• Don't Use Excel Filters! Use This Inc...
🔥LEARN EXCEL VBA WITH THIS 5-HOUR WALKTHROUGH PROJECT
• Learn Excel VBA From Beginner Level W...
🔥READ MORE ABOUT OUR PROFESSIONAL EXCEL DEVELOPMENT COMMUNITY: MEMBERS MONDAY
https://tinyurl.com/2p8wy5dr
Смотрите видео How To Do A Basic Data Analysis In Excel (CHART INCLUDED!) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Tiger Spreadsheet Solutions 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,619 раз и оно понравилось 46 людям.