Challenge #492: Trends in Medical Review Decisions

[tammybrown_tds]

On the second task, it seemed like it would be necessary to calculate a percentage of all male/female before determining "most commonly overturned decisions", to consider it at a percentage rather than a straight up number.  Doing so didn't appear to change the outcome though.

Spoiler

[annbriceAB]

This was a fun challenge, thanks!

[aatalai]

C492

[TyCollins297]

My Solution...

Spoiler

[josephmadigan]

For question 2, I calculated using the ratio instead of the total count since this seemed more appropriate for "association" (as opposed to asking for the "number of" like in question 3). To get the official answer in 2 quick vectorized steps, replace "determination: average" to "determination: sum" in the summarize tool (same logical flow as answer 3)

Also, question 4 asks for the percentage of overturned decisions by year, but the chart displays count of each type of decision instead. Made a cute chart to show it by percentage :3

Spoiler

 Spoiler

[Joseph_Peterson]

My solution mostly used summarize and filter tools:

Spoiler

[patrick_digan]

Spoiler

[Salum0405]

Here's my solution, this one was kinda hard for me!

[SteveY02]

Done. There are minor mistake in referce answer:

Task 1: The sum of percent should be 100, but the reference answer Row1 is 33.5 + 67 = 100.5, which is incorrect.

Task 4: Question is about visualizing the percentage of decision, but the reference answer provided is line chart of count number. Besed on my understanding, I provided 3 types of chart:

- Area Chart: display the differnce of percetage of decisions(Overtruned and Upheld)

- Line Chart: another way to compare the percetage of decisions(Overtruned and Upheld)

- Dual Chart: Comparison the actual count of each dicision, meanwhile adding a reference line showing the trends of percentage of overtuned by year.