We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #331: Time for College!

MarieC
Moderator
Moderator

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
11 - Bolide
Spoiler
MilindG_0-1659974199358.png

 

TonyAndriani
8 - Asteroid

Nice warmup to start the week...

Spoiler
TonyAndriani_0-1659974227360.png

 

joelmiller66
9 - Comet
Spoiler
Screenshot 2022-08-08 090001.jpg
binuacs
17 - Castor
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
11 - Bolide
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
8 - Asteroid

My Solution:

Spoiler
Annotation 2022-08-08 133707.jpg