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.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Reverse Words in String
Challenge No. 82: Reverse the Words in the string.
Solved using: SQL.
Swap Alternate Rows
Challenge No. 81: Interchange the position of 1st row with 2nd, 3rd with 4th, 5th with 6th and so on.
Solved using: SQL.
Extract Min and Max From
Challenge No. 79: Extract the maximum and minimum numbers from the strings.
Solved using: SQL.
Data Cleaning! Part 1
Challenge No. 98: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, but in a disorganized order.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Contains, Text.Split), Python, Python in Excel, and R.
Top 4 Winner and Runner-up
Challenge No. 78: — This week will be FIFA World Cup week.
Solved using: SQL.
Best and Worst Rank Changes
Challenge No. 77: — This week will be FIFA World Cup week.
Solved using: SQL.
Top 5 Goal Scoring Teams
Challenge No. 75: — This week will be FIFA World Cup week.
Solved using: SQL.
Linear Interpolation!
Challenge No. 97: In the question table, the population data for cities A, B, and C are provided for different years.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Avg Interval Between Wins
Challenge No. 74: — This week will be FIFA World Cup week.
Solved using: SQL.