Round Functions: CEILING, FLOOR, ROUND |
ฝัง
- เผยแพร่เมื่อ 25 ส.ค. 2024
- 🎬 Full Tableau Course: • Complete HR Tableau Pr...
⬇️ Free Materials (Downloads): datawithbaraa....
👉 Support & Subscribe to Channel: bit.ly/3GiCVUE
☕ Stay connected
► Subscribe: bit.ly/3GiCVUE
► Join: / @datawithbaraa
► Newsletter: bit.ly/BaraaNe...
► LinkedIn: / baraa-khatib-salkini
► Website: www.datawithba...
📚 Free Courses
✅ Tableau: • Complete HR Tableau Pr...
✅ Tableau Project: • Complete HR Tableau Pr...
✅ SQL Basics: • SQL Tutorial for Begin...
✅ SQL Advanced: • How I'd Learn Advanced...
✅ ChatGPT: • ChatGPT Tutorial for B...
🎓Other Platforms (Certifications)
► Udemy: bit.ly/BaraaUdemy
► Skillshare (1 Free Month): bit.ly/BaraaSk...
⭐ My favorite books: kit.co/DataWit...
💻 My gear: kit.co/DataWit...
⏱️ Timestamp
00:15 Introduction To Number Functions
00:35 Concept & Syntax: CEILING, FLOOR, ROUND
04:36 CEILING Example
06:25 FLOOR Example
07:06 ROUND Example
09:26 CEILING vs FLOOR
#tableau #data #analytics #datascience
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
Excellent example
Crazy explaination.!!! You nailed it :)
chatgpt :
Here are scenarios with explanations for choosing FLOOR or CEILING:
1. Financial Calculations
Scenario: Display product prices as whole dollars on a storefront.
Use: FLOOR
Reason: To round down prices and ensure they don't exceed advertised amounts (e.g., a price of $19.99 becomes $19).
2. Inventory Management
Scenario: Determine the number of storage bins needed for items.
Use: CEILING
Reason: To ensure enough bins, rounding up to cover all items (e.g., 15 items with 10 items per bin requires 2 bins, as 1.5 bins would be rounded up to 2).
3. Scheduling
Scenario: Calculate the number of whole hours worked when a person works part of an hour.
Use: FLOOR
Reason: To round down to full hours worked for payroll (e.g., 7.8 hours worked would be rounded down to 7 hours).
4. Event Planning
Scenario: Determine the number of full tables needed for guests at an event.
Use: CEILING
Reason: To ensure enough tables for all guests, rounding up to avoid shortages (e.g., 85 guests at tables of 10 requires 9 tables, as 8.5 would be rounded up to 9).
5. Data Binning for Visualization
Scenario: Group ages into 10-year bins starting from zero.
Use: FLOOR
Reason: To round down ages to the nearest bin's lower bound (e.g., age 27 falls into the 20-29 bin by flooring the value to 20).
6. Capacity Planning
Scenario: Determine the number of full trucks needed for shipping products.
Use: CEILING
Reason: To ensure sufficient trucks, rounding up to cover all products (e.g., 93 products with 10 products per truck requires 10 trucks, as 9.3 would be rounded up to 10).
7. Service Allocation
Scenario: Calculate total service charges by rounding to nearest full service units.
Use: CEILING
Reason: To ensure charges cover full services provided, rounding up to nearest service unit (e.g., 3.2 service units billed as 4 units).
8. Resource Allocation
Scenario: Calculate the number of workers needed for partial-day shifts.
Use: CEILING
Reason: To ensure adequate workers are available, rounding up to cover all shifts (e.g., 5.6 workers needed rounded up to 6 workers).
9. Fitness Tracking
Scenario: Log the number of full kilometers run during a workout.
Use: FLOOR
Reason: To record completed kilometers without overestimation (e.g., 5.8 km run rounded down to 5 km).
10. Housing Development
Scenario: Determine the number of full floors for building height.
Use: FLOOR
Reason: To design building floors conservatively within height limits (e.g., building height of 5.9 floors rounded down to 5 floors).
Summary
Choose FLOOR: When rounding down to the nearest integer to avoid exceeding or overestimating (conservative estimates).
Choose CEILING: When rounding up to the nearest integer to ensure adequacy or coverage (ensuring sufficient resources or capacity).