How to calculate different types of averages in Excel

1 year ago
2

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

Loading comments...