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. Glick here for the Excel Data File 0. Sort the data by writing scores in descending order. Which state has the highest average witing score? What is the average math score of that state? 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? c. Hrw manv states redorted an average math score higher than 600 ? d. How manv states reported an average writing score lower than 550 ? File Home insent Draw Page Layout Ch2_a11_13_Datafile (1) PROTICIED VIEW Re rareful-fileffom the lntemet can contain vinuses, Un CH 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. Glick here for the Excel Data File 0. Sort the data by writing scores in descending order. Which state has the highest average witing score? What is the average math score of that state? 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? c. Hrw manv states redorted an average math score higher than 600 ? d. How manv states reported an average writing score lower than 550 ? File Home insent Draw Page Layout Ch2_a11_13_Datafile (1) PROTICIED VIEW Re rareful-fileffom the lntemet can contain vinuses, Un CH
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
