Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #343: Average App Cost

AYXAcademy
Alteryx
Alteryx

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

 

Do you have to work with messy data?image-343.png

 

The provided dataset is Messy with a capital M. For this challenge, calculate the average cost of an app (Application Fee and Cost) based on the 10 most expensive apps.


Guidelines:
- You must use the values of the creator whose last name starts with S.
- Calculate the cost of each app (application fee + cost).
- Round up the cost of each app; for example, if an app costs $67.03, round up to $68.
- Determine the cost at X.99; for example, if an app costs $68, the final cost will be $67.99.
- Then you will calculate the average cost based on the 10 most expensive apps.

 

Start by cleaning the messy dataset.

 

 

Thank you for your comments. This Weekly Challenge was updated.

peter_gb
9 - Comet

Hmm I think I've followed the steps as described but my answer is off - $69.69 vs the given solution of 69.273 - can anyone point out what I've done wrong?

Spoiler
challenge_343_pgb.png

patrick_digan
17 - Castor
17 - Castor

 

Spoiler
patrick_digan_0-1667223317169.png

 

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Getting a bit of a different answer than the one given
Kenda_0-1667223371729.png

 

harrame
8 - Asteroid

I'm also getting a different answer from the provided solution.

Spoiler
There are two ways I can see to approach the final answer. One, you do a unique on the parsed name of the product, and one without the unique. I got $69.69 and $68.99, respectively.
harrame_0-1667223584233.png

 

Luke_C
17 - Castor
Spoiler
Luke_C_0-1667224273775.png

 

Different than solution but consistent with everyone else's answer

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

I also reached a different result.

 

Spoiler
AkimasaKajitani_0-1667224207651.png

 

AkimasaKajitani_1-1667224334467.png

 

binuacs
20 - Arcturus
Spoiler
binuacs_0-1667224443287.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
343.png

Different result ... as all others

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1667225991968.png