Quite tough for me as I don't spend a lot of time in spatial or reporting functions. My reports aren't quite as pretty but I managed to get to each of the answers conceptually I think.
Had a little difficulty getting the correlation values to match, but that was due to using the summed values instead of the percentages. My map also uses a slightly different colour scheme as I chose the "vibrant" theme, but other than that, I believe my solution matches.