How to calculate different types of averages in Excel
How to calculate different types of averages in Excel #12 إتعلم حيل إكسل مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video we use the Average, Median and the Mode functions in Excel
The average median mode are measurements of central tendency. In other words, it tells you where the “middle” of a data set it. Each of these statistics defines the middle differently:
1- The average is the average of a data set.
2- The mode is the most common number in a data set.
3- The median is the middle of the set of numbers.
Of the three, the mean is the only one that requires a formula. I like to think of it in the other dictionary sense of the word (as in, it’s “mean” as opposed to nice!). That’s because, compared to the other two, it’s not as easy to work with because of the formula.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3Rh81Pf
SUPPORT THE CHANNEL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👉Teespring Merch&Books 👉 https://bit.ly/3S1fa7n
Social Media / Contact us
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🤳Dexcelo on TikTok 👉 https://bit.ly/3JgslNU
📥 Business Inquiries 👉 dexcelo03@gmail.com
📊 In this course you will learn how to:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Use three types of averages
- Name a range and use it in the average functions
- Use the AVERAGE Function to return the average value
- Use the MEDIAN Function to return the the value in the middle
- Use the MODE Function to return the most frequent value
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:01:10 Intro & Objectives
0:01:10 - 0:02:18 Hiding the Ribbon
0:02:18 - 0:04:27 Naming a data range
0:04:27 - 0:06:30 Average Function
0:06:30 - 0:07:40 Median Function
0:07:40 - 0:11:07 Difference between average and median
0:11:07 - 0:13:00 Mode Function
0:13:00 - 0:17:00 Three types of averages
0:17:00 - 0:18:58 Practice case objectives summary
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#Howtocalculatedifferenttypesofaverages #excel #اكسل #concatenate
-
2:17
Nerdalific
3 years agoAverageif Formula in Excel / Excel Tutorial
4 -
4:56
Kaceli TechTraining
3 years agoExcel 2019 Tutorial: Calculating the Max, Min, Average and Count
83 -
2:33
Excelliott Technology
1 year agoExcel - AverageIF Function
1 -
29:57
Microsoft Excel Full Course
3 years agoExcel 365 Part 9 – Standard Formula Features
62 -
1:42
syeduddin1786
1 year agoUsing Sumproduct Formula in Excel.
12 -
1:55
Minute Math
2 years agoHow to Calculate the Mean of a Set of Numbers | Minute Math
56 -
1:26
Nerdalific
3 years agoAverage Formula in Excel / Excel Tutorial
-
1:42
GodsTiming
1 year agoMean on Excel
90 -
38:06
Microsoft Excel Full Course
3 years agoExcel 365 Part 11 – Logical Functions
58 -
7:25
The Excel Zone
1 year agoEXCEL SUMIF AND SUMIFS FORMULAS: HOW TO SUM DATA BASED ON CONDITIONS
67