The accompanying data le lists the average writing and math SAT scores for the 50 states as well as the District of Columbia, Puerto Rico, and the US. Virgin Islands for the year 2017 as reported by the College Board. Click here for the Excel Data File a. Sort the data by writing scores in descending order. Which state has the highest average writing score? What is the average math score of that state? State with the highest average writing score Average writing score Average math score b. Sort the data by math scores in ascending order. Which state has the lowest average math score? What is the average writing score of that state? State with the lowest average math score Average writing score Average math score c. How many states reported an average math score higher than 600? The number of states with an average math score higher than 600 :I d. How many states reported an average writing score lower than 550? The number of states with an average writing score lower than 550 l I A B C D E F G H 1 State Writing Math Alabama 759 696 - WN Alaska 698 491 Arizona 525 348 Arkansas 551 525 O UT California 528 543 Colorado 583 563 00 Connecticut 511 515 9 Delaware 564 593 10 District of Columbia 596 546 11 Florida 572 522 12 Georgia 584 547 13 Hawaii 556 518 14 Idaho 514 541 15 Illinois 516 586 16 Indiana 564 592 17 lowa 566 513 18 Kansas 554 509 19 Kentucky 579 541 20 Louisiana 519 503 21 Maine 565 547 22 Maryland 525 540 23 Massachusetts 535 597 24 Michigan 506 556 25 Minnesota 553 511 26 Mississippi 523 512 27 Missouri 571 520 28 Montana 554 570 29 Nebraska 520 552 30 Nevada 509 515 31 New Hampshire 564 565 32 New Jersey 512 574 33 New Mexico 552 544 34 New York 591 530 35 North Carolina 550 535 36 North Dakota 500 583 37 Ohio 531 595