Hello,

Can someone help me with this problem ? I will include excel link. Can you provide formulas please and step by step solution. Thank you ?

https://drive.google.com/file/d/1bY1hiHWotL8a1uCLiX9yYzHwiZ3NMHIP/view?usp=sharing

The Problem 2excel 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

What is the Average SAT Total Score for New York City?

1642.44, 1268.09, 1496.54, 1021.98

1. Choose the correct LOOKUP function used for the categorization in Problem 2

=LOOKUP(G2,{0,1100,1101,1400,1401,1600,1601,2500},{"Unsatisfactory","Satisfactory","Exceeding Expectations","Outstanding"})

=LOOKUP(G2,(0,1101,1401,1601),("Unsatisfactory","Satisfactory","Exceeding Expectations","Outstanding"))

=LOOKUP(G2,{0,1101,1401,1601,2500},{"Unsatisfactory","Satisfactory","Exceeding Expectations","Outstanding"})

=LOOKUP(G2,{0,1100,1400,1600,2500},{"Unsatisfactory","Satisfactory","Exceeding Expectations","Outstanding"})