This test took me a while to complete. I see that I did not get the correct information for the states and that is what caused me to calculate different results.  Also I did not fully understand what question 2 was asking which lead to more work than needed.

https://drive.google.com/open?id=1YKIa-5zTyHDeJxh8R3fL0L95wWU7DvwO