Question: The accompanying data file lists the average writing and math SAT scores for the 50 states as well as the District of Columbia, Puerto Rico,
The accompanying data file lists the average writing and math SAT scores for the 50 states as well as the District of Columbia, Puerto Rico, and the U.S. Virgin Islands for the year 2017 as reported by the College Board.
Click here for the Excel Data File
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?
| State | Writing | Math |
| Alabama | 707 | 247 |
| Alaska | 465 | 271 |
| Arizona | 551 | 251 |
| Arkansas | 580 | 504 |
| California | 599 | 503 |
| Colorado | 581 | 588 |
| Connecticut | 596 | 585 |
| Delaware | 535 | 586 |
| District of Columbia | 589 | 510 |
| Florida | 537 | 544 |
| Georgia | 549 | 574 |
| Hawaii | 528 | 520 |
| Idaho | 577 | 577 |
| Illinois | 515 | 571 |
| Indiana | 567 | 568 |
| Iowa | 556 | 520 |
| Kansas | 589 | 592 |
| Kentucky | 509 | 587 |
| Louisiana | 505 | 516 |
| Maine | 589 | 557 |
| Maryland | 569 | 514 |
| Massachusetts | 579 | 503 |
| Michigan | 541 | 581 |
| Minnesota | 583 | 595 |
| Mississippi | 578 | 531 |
| Missouri | 545 | 567 |
| Montana | 503 | 594 |
| Nebraska | 569 | 530 |
| Nevada | 504 | 536 |
| New Hampshire | 537 | 579 |
| New Jersey | 593 | 573 |
| New Mexico | 554 | 593 |
| New York | 549 | 522 |
| North Carolina | 541 | 502 |
| North Dakota | 551 | 531 |
| Ohio | 551 | 535 |
| Oklahoma | 593 | 501 |
| Oregon | 576 | 502 |
| Pennsylvania | 524 | 563 |
| Puerto Rico | 600 | 599 |
| Rhode Island | 572 | 530 |
| South Carolina | 528 | 515 |
| South Dakota | 503 | 590 |
| Tennessee | 588 | 561 |
| Texas | 517 | 505 |
| Utah | 550 | 526 |
| Vermont | 558 | 512 |
| Virgin Islands | 591 | 599 |
| Virginia | 500 | 596 |
| Washington | 544 | 568 |
| West Virginia | 572 | 572 |
| Wisconsin | 543 | 513 |
| Wyoming | 587 | 574 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
