Solutions to "Just KNIME It!" Challenge 16 - Season 2

Hi Everyone :slight_smile:

Here is my solution this week:

I decided to start by filtering the data and keeping only the most recent year as this is most relevant to know the possible cost for this year. I also decided to calculate the Expense Values per year, so that a mean value could be calculated using both the 2-year and 4-year data.

In the interactive component, the user can select the Type of University using the -Single Selection Widget- node:

This filters the data, which is then displayed for both the Fees/Tuition and the Room/Board using separate -Choropleth Map- components:

Also as a simple Bar Chart:

I have also displayed unfiltered data using the -Conditional Box Plot- node, showing the Fees/Tuition for each type of University and each length of study. I have also repeated this for the Room/Board:

On average, private Universities are more expensive than public, but the states with the cheapest tuition fees are not necessarily the cheapest to live in and vice versa. For example, California has a high mean living cost but low tuition fees if going to a Public In-State University. Therefore, both choropleth maps should be reviewed when making a decision.

You can find my workflow on the hub here:

Best wishes
Heather

5 Likes