Question

1 Approved Answer

Posted on Jul 10, 2024

Question Completion Status: The Problem 2 excel sheet provides the section-wise SAT performance data for 100 schools in New York City. a. Find the total

Question Completion Status: The Problem 2 excel sheet provides the section-wise SAT performance data for 100 schools in New York City. a. Find the total score for each school in the table. Total score is sum of the three sectional scores combined. b. Based on the total scores calculated, categorize the schools according to the following criteria: RATINGS SCORE RANGE Unsatisfactory 0-1100 Satisfactory 1101 - 1400 Exceeding Expectations 1401 - 1600 Outstanding 1601 - 2100 c. Count the number of schools in each rating category Question: What is the Average SAT Total Score for New York City? 1268.09 1642.44 1496.54 1021.98 QUESTION 5 Choose the correct LOOKUP function used for the categorization in Problem 2 =LOOKUP(G2/0,1101,1401,16011. "Unsatisfactory":"Satisfactory":"Exceeding Expectations", "Outstanding" nd Submit to save and submit. Click Save All Answers to save all answers, Excel Fle Edit View Insert Format Tools Data Window Help AutoSave OFF FinalExam_V2 Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) EE 12 General insert (5 - A A A Conditional Formatting Formatas Table Cell Styles DX Delete Paste B 7 U $ % ) 8:28 Format K9 x Bacanding pecto 5 D 0 1 DAN School Name Numbw of Test Takers Chica Reading Mean Moms Men Wing Mentor DIM292 Henry Street School formation des 31 435 > DIM44 University behoed School GO 394 419 4 DIM45 East Side Coche 69 418 402 501M4S SATELLITE ACADEMYFORSYTH ST 2 385 320 338 6 DIMSIS Lowest Prep School 154 314 314 7 01MS Newportions in SiTech and MS 47 568 53 SER BOIMAS CASCADES HIGH SCHOOL 401 401 9 01MGEBARD HIGH SCHOOL EARLY COLLEGE 112 630 10 M04AMERICAN SIGN LANG ING DUAL 405 385 11 OM FOOD AND FRANCE HIGH SCHOOL 50 412 40) 12 OMOPHIGH SCHOOL FOR HIST AND COMM 51 32 364 166 13 OIM296 School of Hospitality Management 43 397 415 391 14 OU PACE HIGH SCHOOL 71 424 441 423 15 OMS Urban Assembly School of Design and Construction 49 405 4.46 415 16 M303 The Facing History School 59 981 323 177 17 OMOS Urban Assembly Academy of Government and Law 406 411 18 OMSOR LOWER MANHATTAN ARTS ACADEMY 35 400 412 19 OM The Barnes Bad School 45 41 419 394 20 OM316 ben Assembly School of Business for Young Women 52 401 409 191 21 OIM374 GRAMERCY ARTS HIGH SCHOOL 49 376 386 22 OMLOO HIGH SCHOOL EVENMINTL STUDIES 216 480 448 23 02M407 Institute for Colaborative Education 42 484 478 472 24 M408 Professional Perfogarts School 69 465 25 02411 Baruch College Camous School 96 523 583 58 100 26 2M412 New York City Laboratory School Colab Studies 567 561 27 OMA SCHOOL OF THE FUTURE 79 48 28 OMAI NEW YORK CITY MUSEUM SCHOOL 90 435 454 29 OIM416 ELEANOR ROOSEVELT HIGH SCHOOL 122 555 596 567 140 30 OM41 Minum High School 512 554 523 47 369 370 31 O2M419 LANDMARK SCHOOL 359 2:50 458 446 32 02M420 HIGH SCHOOL HLTH PROF HUMAN 440 419 429 496 33 M425 HIGH SCHOOL LEADERS PUB SVC Problem 1 Problem 2 Problem 3 + COM a Poste BIU DIM44 University behoed School GO 394 419 4 DIM45 East Side Coche 69 418 402 501M4S SATELLITE ACADEMYFORSYTH ST 2 385 320 338 6 DIMSIS Lowest Prep School 154 314 314 7 01MS Newportions in SiTech and MS 47 568 53 SER BOIMAS CASCADES HIGH SCHOOL 401 401 9 01MGEBARD HIGH SCHOOL EARLY COLLEGE 112 630 10 M04AMERICAN SIGN LANG ING DUAL 405 385 11 OM FOOD AND FRANCE HIGH SCHOOL 50 412 40) 12 OMOPHIGH SCHOOL FOR HIST AND COMM 51 32 364 166 13 OIM296 School of Hospitality Management 43 397 415 391 14 OU PACE HIGH SCHOOL 71 424 441 423 15 OMS Urban Assembly School of Design and Construction 49 405 4.46 415 16 M303 The Facing History School 59 981 323 177 17 OMOS Urban Assembly Academy of Government and Law 406 411 18 OMSOR LOWER MANHATTAN ARTS ACADEMY 35 400 412 19 OM The Barnes Bad School 45 41 419 394 20 OM316 ben Assembly School of Business for Young Women 52 401 409 191 21 OIM374 GRAMERCY ARTS HIGH SCHOOL 49 376 386 22 OMLOO HIGH SCHOOL EVENMINTL STUDIES 216 480 448 23 02M407 Institute for Colaborative Education 42 484 478 472 24 M408 Professional Perfogarts School 69 465 25 02411 Baruch College Camous School 96 523 583 58 100 26 2M412 New York City Laboratory School Colab Studies 567 561 27 OMA SCHOOL OF THE FUTURE 79 48 28 OMAI NEW YORK CITY MUSEUM SCHOOL 90 435 454 29 OIM416 ELEANOR ROOSEVELT HIGH SCHOOL 122 555 596 567 140 30 OM41 Minum High School 512 554 523 47 369 370 31 O2M419 LANDMARK SCHOOL 359 2:50 458 446 32 02M420 HIGH SCHOOL HLTH PROF HUMAN 440 419 429 496 33 M425 HIGH SCHOOL LEADERS PUB SVC Problem 1 Problem 2 Problem 3 + COM a Poste BIU