Challenge #201: Wage Ain't Nothin' but a Number

[AYXAcademy]

This challenges focuses on charting the changes in the minimum wage over time since 1968.

For those not familiar, the minimum wage is the lowest hourly wage allowed by law. In the United States, there is a federally mandated minimum, but each state is allowed to enforce their own minimums. Below, you will find a file containing minimum wage data from 1968 - 2017 by state. The Text Input tool classifies each state into a region.

Use the inputs to create a()n (interactive) chart showing each region's average minimum wage by year.

 Source: GIPHY

[Blake]

Go Chiefs! 

Not quite sure how to check this against the result we were given to make sure everything is correct.... 

Spoiler

[Aaron_Harter]

Spoiler

 Fun practice with the interactive chart tool.

[TonyA]

Here's my solution

Spoiler

The actual challenge was relatively easy. The time consuming part was figuring out exactly how the averages were calculated. I started out assuming that NA was converted to null (which appears to be correct) and that the average of high and low was used (apparently wrong - it looks like the average was taken on the high value only). Following up on @RolandSchubert's comment, it would make more sense if 0 and NA values were replaced with the Federal Rate.

[Sylvana]

First time using interactive charts. Nice tool 🙂

Spoiler

Wasn't so easy to find out which average is taken for the graph. I used the average of "High".

[RolandSchubert]

My solution.

Spoiler

The problem was to find out how averages were calculated. Once you realize that only [High.Value] is used and missing values are not replaced by Federal rates, it's quite simple.

[RichoBsJ]

Hi! Here my solution 🙂

[BenMoss]

I guess the purpose of this exercise wasn't to get the exact output, but to get us playing with the interactive charting tool, in which case mission accomplished, and definitely better from the last time I used it!

[patrick_digan]

Spoiler