Challenge #419: Cost Analysis of Easter Baskets

[AYXAcademy]

Hi Maveryx,

A solution to last week’s challenge can be found here. 

This week, we have a special Easter challenge, and we want to express our gratitude to Jifeng Qiu (@Qiu)  for his enthusiastic participation in the Community and for suggesting another challenge idea for us. His submission was inspired by a Designer Desktop discussion about joining tables. Thank you, Qiu!

Your neighborhood's community outreach program plans to distribute 100 Easter baskets to local children during Easter. Each basket includes a stuffed animal and a candy treat. There are four variations of baskets, and the organization plans to make 25 of each basket combination. The group will be fundraising to buy the supplies and wants to estimate how much money they will need for the baskets in 2024.

The datasets provide information on the items each basket should contain and the prices of the contents for the years 2021, 2022, and 2023.

In this challenge, you have two tasks:

• Build a table that displays the percentage increase of the cost of each basket over the past 3 years (2021–2023).
• Use the percentage increase from 2022 to 2023 as a reference point to estimate the amount of fundraising required in 2024 to cover the cost of all 100 baskets.

If you need a little help, you can review these lessons in Academy:

• Summarizing Data
• Changing Data Layouts
• Blending Data with Unions

Have a wonderful Easter!

[Flo_P]

Thanks for the challenge and happy easter!

Spoiler

[aatalai]

some rounding difference in part 2 but got there

[ahsanaali]

Spoiler

 

[usmanbashir]

Spoiler

 

[alacoume]

My solution, not that smart, with minors differences with the solution

Spoiler

[Vinayp29]

Spoiler

Spoiler

Spoiler

[alexnajm]

EDIT: Fixed and attached!

Can't be bothered with the weird rounding difference 😂 (even if it does irk me a bit...)

Spoiler

[balajilolla2]

Spoiler

[nhardin]

Spoiler