Challenge No. 503: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Calculate the sum, average, maximum value, minimum value, count, and payment amount for products purchased by each customer.
Solved using: Python in Excel.
AVERAGE
Returns the average (arithmetic mean) of a range in Excel.
Average Between Blank Groups
Challenge No. 203: Prepare the groups which lie between two blank Amount1s and give the average of numbers appearing in those groups (groups shaded in light red).
Solved using: R.
List words longer than average word length
Challenge No. 330: Extract all the words which are greater than average length of the words in that sentence.
Solved using: R.
Top 3 employees nearest to average salary
Challenge No. 322: Find the top 3 employees whose salary is nearest to average salary.
Solved using: DAX.
Avg Cooperation Time!
Challenge No. 108: Calculate the average cooperation time in months for those who are still with the company (do not have value on column leave date) as of 16/08/2024, categorized by their respective levels.
Solved using:Excel (AVERAGE, FILTER, HSTACK), Google Sheets, Power Query (Date.Month, Date.Year), Python, Python in Excel, and R.
Custom Average!
Challenge No. 103: Today is 20/08/2024, and we’re calculating the average delivery time per product in days.
Solved using:Excel (AVERAGE, CHOOSECOLS, FILTER), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Avg Cost Between City Pairs
Challenge No. 92: Find the average cost between the pair of cities.
Solved using: Python in Excel.
Knn Missing Value!
Challenge No. 86: K-nearest neighbors (KNN) is a simple technique for replacing missing values with the average of the nearest values.
Solved using:Excel, Power Query, and VBA.
Duration Since Last Visit!
Challenge No. 38: In the question table, the visiting dates for all 4 agents are provided.
Solved using:Excel (AVERAGE, DROP, EOMONTH), Power Query (List.Transform, Table.AddColumn, Table.Group), Python, and R.
Sales Calendar Extraction!
Challenge No. 18: Dynamically generate a sales calendar for the month entered in F3, based on data from the given table.
Solved using:Excel, Power Query, and R.