Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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 #331: Time for College!

MarieC
Alteryx Alumni (Retired)

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

image_331.png

 

Congratulations, class of 2026!

 

For many new college students, now is the time to pay tuition for college, and sometimes their college decision is based on financial data.

This dataset contains information about private and public colleges in the US, where these institutions often offer different tuition for

 in-state and out-of-state students.

 

Using the provided data:
- Create a list of 4-year colleges by state that includes the total payment (tuition plus room and board) in 2020 for private colleges and public colleges for in-state and out-of-state students.
- Find the top 10 schools that give the most significant discounts for in-state students.

MilindG
12 - Quasar
Spoiler
MilindG_0-1659974199358.png

 

TonyAndriani
9 - Comet

Nice warmup to start the week...

Spoiler
TonyAndriani_0-1659974227360.png

 

joelmiller66
9 - Comet
Spoiler
Screenshot 2022-08-08 090001.jpg
binuacs
21 - Polaris
Spoiler
binuacs_0-1659975036588.png

 

MuralidharAreti
8 - Asteroid

Did a simple step-by-step approach to answer the question at hand. 

Spoiler
MuralidharAreti_0-1659975051079.png

 

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT_Solution_331.jpg

Short one to warm up for the week. 

c7fobrie
7 - Meteor

Response file attached.

RyanG45
7 - Meteor
Spoiler
Solution 

RyanG45_1-1659979013001.png

 

 

 

Clifford_Coon
11 - Bolide

My Solution:

Spoiler
Annotation 2022-08-08 133707.jpg