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.
Excel Challenges
Challenges related to Excel formulas.
Connected People!
Challenge No. 37: In the question table, the IDs of 20 people who call each other are provided.
Solved using:Excel (FILTER, HSTACK, LAMBDA), Power Query (List.Transform, Text.Combine), Python, and R.
Pareto Line
Challenge No. 36: In Multi-Objective Models, Instead Of A Single Solution, We Encounter A Pareto Front That Includes All Non-Dominant Solutions, And In This Quesion We Want To Extracth All Non Dominant Solutions.
Solved using:Excel (BYROW, FILTER, LAMBDA), Power Query (List.Transform, Table.SelectRows), Python, and R.
P & Down Grades!
Challenge No. 35: In our company, we utilize a grading system to evaluate the technical performance of our agents, assigning grades of C, B, A, and A+.
Solved using:Excel (DROP, FILTER, HSTACK), Power Query (Table.AddColumn, Table.Group), and R.
Customer Return Cycle!
Challenge No. 34: In the question table, sales data for different customers are provided.
Solved using:Excel (DROP, FILTER, HSTACK), Power Query (Table.Group), Python, and R.
Remove Outlier Questionnaires!
Challenge No. 33: Questionnaires are a common method for collecting data, but they are susceptible to noise from respondents who fill them out randomly.
Solved using:Excel, Power Query, Python, and R.
Table Transformation! Part 4
Challenge No. 32: In the question table, monthly sales and the percentage of total annual sales are provided.
Solved using:Excel (CHOOSECOLS, CHOOSEROWS, DROP), Power Query (Table.Column, Table.ColumnNames, Table.Sort), Python, and R.
From-To Matrix
Challenge No. 31: In the question table, the distances between various cities are provided.
Solved using:Excel (HSTACK, LAMBDA, LET), Power Query (Table.Column, Table.ColumnNames), Python, and R.
Risk Analysis
Challenge No. 30: In risk analysis, activities are categorized into various groups according to their likelihood of occurrence and their impact.
Solved using:Excel, Power Query, Python, and R.
Identifying Customers Staple Products!
Challenge No. 29: In the question table, sales transactions are listed.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Power Query (Text.Combine, Table.Group), Python, and R.