Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applied Linear Algebra

Authors: Peter J. Olver, Cheri Shakiban

1st edition

131473824, 978-0131473829

More Books

Students also viewed these Mathematics questions

Question

2 6 . .

Answered: 1 week ago

Question

3 Why do you think positive psychology is needed in todays society?

Answered: 1 week ago

Question

The scope and aim of positive psychology.

Answered: 1 week ago