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.

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?

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?

EXCEL DATA BELOW:

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

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...

Q:

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Q:

could you please help figure out this problem, the problem is on the excel Accounting Information Systems Excel 1 Assignment Background: Alpha Charlie Inc. (AC Inc.) is a wholesale distributor of...

Q:

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...

Q:

please explain 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, and the U.S. Virgin Islands for the...

Q:

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...

Q:

(8 PTS) 1. Accounts Receivable - Uncollectible Accounts Spacer Corporation's trial balance revealed the following balances in these selected accounts prior to any adjustments: Accounts Receivable...

Q:

The accompanying data file lists the average writing and math SAT scores for thie 50 states as well as the Disirict of Columbia, Puerto Rico, and the U.S. Virgin Islands for the year 2017 as leported...

Q:

The accompanying data file lists the average writing and math SAT scores for thie 50 states as well as the Disirict of Columbia, Puerto Rico, and the U.S. Virgin Islands for the year 2017 as leported...

Q:

Using RStudio d. How many states reported an average writing score average writing and math SAT scores for the 50 states as well as the C. How many states reported an average math score higher 11....

Q:

A parcel of land was acquired by Macy Corporation by issuing 200,000 ordinary shares with P 28 par value per share. In case the Corporation decided to acquire the parcel of land through cash, they...

Q:

-English Version- Q4 Table 4 indicates various cost associated with two different water pump brands. Table 4: Various cost for the two pumps. Description Hitachi Initial cost (RM) Rebuilt cost (RM)...

Q:

Question 5 0 of 1 0 0 . Which of the following statements is TRUE about the Child Tax Credit for 2 0 2 5 ? The Child Tax Credit may benefit either the custodial or the noncustodial parent. The Child...

Q:

Multiple Choice Questions Identify the best answer for each of the following: 1. Which of the following is a characteristic of a Special Revenue Fund that differentiates it from a General Fund? a. A...

Q:

Which of the following amounts paid by an employer to an employee is not subject to withholding? a. Salary b. Bonus c. Commissions d. Reimbursement of expenses under an accountable plan e. All of the...

Q:

Global Corporation distributed property with an $850,000 fair market value and a $415,000 adjusted basis to Kang, one of its shareholders. The property was subject to a $230,000 mortgage, which Kang...

Q:

Dahlia is in the 28 percent tax rate bracket and has purchased the following shares of Microsoft common stock over the years: Microsoft common stock Date Purchased ________________Shares...

Q:

Ken Johnston, the data processing manager for Stanley Morgan Bank, is planning a project to install a new management information system. He now is ready to start the project, and wishes to finish in...

Q:

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Q:

3. A ball is in any one of *n* boxes. It is in the *i*th box with probability *P i *. If the ball is in box *i*, a search of that box will uncover it with probability * i *. Show that the conditional...

Q:

2. If the odds ratio of the event *A* is equal to **, what is *P(A)*?

Q:

1. Consider a school community of *m* families, with *n i * of them having *i* children, *i* = 1, ..., *k*, *k* *i*=1 *n i * = *m*. Consider the following two methods for choosing a child.