Challenge No. 104: Monte Carlo simulation is a technique used to predict the outcome of decisions by simulating a process multiple times.
Solved using:Excel, Power Query, Python, Python in Excel, and R.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Companies with Positive Growth
Challenge No. 99: List the companies which have positive annual growth rate during all 3 period years and their Average Annual Growth Rate (AAGR) .
Solved using: Python.
Pair clubs so each team
Challenge No. 27: There are 9 clubs and every club has to play with remaining 8 clubs once only.
Solved using: Power Query (Table.AddColumn).
Pivoting Data
Challenge No. 22: Pivot the Customer’s table
Create a Total for each Month
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
If in a group of
Challenge No. 25: If in a group of IDs, first occurrence of event Z appears with a category of Temporary, then all Values should be Yes otherwise No.
Solved using: Power Query.
Subjects Taught Exclusively
Challenge No. 85: Column A lists down subjects taught by Female and Male Teachers.
Solved using: SQL.
Random Selection! Part 2
Challenge No. 99: Randomly select 4 unique staff members using the following procedure:
1- Randomly select a department out of 5 departments with equal probability.
Solved using:Excel, Power Query, and R.
List 1st, 3rd, 5th Saturdays
Challenge No. 80: List the 1st, 3rd and 5th Saturdays of all months for a given year in A1.
Solved using: Power Query.
Two-Way approximate Lookup with multiple criteria
Challenge No. 18: Lookup the Approximate Milk Purity
Dynamic array function allowed but Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Best and Worst Rank Changes
Challenge No. 77: — This week will be FIFA World Cup week.
Solved using: SQL.