Old MathJax webview

Old MathJax webview

So I'm stuck on step 15, using the averageifs to average score that meets the two conditions.

*correction* step 17.

Grader - Instructions Excel 2019 Step Instructions Poin: Possit 17 5 4 In cell 15, insert the AVERAGEIFS function to calculate the average SAT score that meets two conditions. Scores in the range 111.167 are greater than or equal to 3500 and Final Decisions in the range J11:J67 are Early Admissions (cell E3). Use mixed references appropriately 18 5 In cell 16, insert the AVERAGEIFS function to calculate the average SAT score that meets two conditions: Residences in the range B11 B67 are In State and Final Decisions in the range J11:J67 are Early Admissions (cell E3). Use mixed references appropriately. 19 Copy the functions from the range 15:16 to the range J5 J6. 2 5 20 You want to insert a map that depicts admissions by state. Display the Map worksheet. Create a map chart from the range A1.B5. Change the chart title to Admissions by State Display the Format Data Series task pane and select Only regions with data as the map area 5 21 You want to place the top-left corner of the map in cell C1 and change the map size. Cut the map and paste it in cell C1. Set 3.12" height and 3.26" width for the map 1 22 Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side on all sheets 0 23 Save and close Exp19_Excel Ch07 ML1_Admissions. x/sx. Exit Excel. Submit the file as directed. Total Points 100 Formula Auditing AVERAGEIFS X ft = D H J K Counts Average SAT 1561 9 B C 1 Admission Criteria 2. Standard Early Admit Early Reject 3 SAT 1400 800 4 GPA 3.80 1.80 5 Input Area 6 Threshold Score 2900 7 Multiplier 600 8 Initial Deadline 3/1/2021 9 F G Summary Data Description Early Admission Admit (regular admission) Score >= 3500 and Early Admissions In State Early Admissions Highest In-State Score Early Admissions Average In-State Score All Admissions Average GPA 3.97 3.51 33 1321 9 4 4000 3588 Date Received Days Before Deadline 10 ID Residence SAT GPA Score Admit Early Reject Early Yes No Final Decision 11 106 1525 4.00 12 106 3925 3721 No No 1483 874 13 3.73 3.26 3.53 Early Admission Admit Reject Admit No 106 91 No 2830 14 1163 No No 15 91 3.58 No 11/15/2020 11/15/2020 11/15/2020 11/30/2020 11/30/2020 11/30/2020 11/30/2020 11/30/2020 11/30/2020 11/30/2020 No 3281 3373 2749 Admit 16 91 3.04 No No 1225 925 1545 1397 17 91 4.00 Yes No 3945 18 91 No No 3389 3.32 3.39 19 91 855 No No 2889 91 3.26 No No 3356 20 21 22 2020005 Out State 2020035 In State 2020040 In State 2020330 In State 2020335 In State 2020340 Out State 2020345 In State 2020350 In State 2020355 In State 2020360 Out State 2020395 In State 2020460 Out State 2020465 In State 2020470 Out State 2020515 In State 2020520 In State 2020530 Out State 2020570 Out State 2020600 In State 2020605 Out State Applicants Map 1400 725 11/30/2020 91 2.42 No Yes 2177 Reject Early Admission Admit Reject Admit Early Rejection Reject Admit Early Admission Reject Admit 90 855 2.75 No No 2505 23 90 1341 3.61 No No 3507 24 90 1585 3.98 Yes No 3973 25 90 950 2.60 No No 2510 26 12/1/2020 12/1/2020 12/1/2020 12/1/2020 12/1/2020 12/1/2020 12/5/2020 12/14/2020 12/14/2020 90 1529 3.63 No No 3707 27 90 1431 3.54 No No 3555 3127 86 1105 3.37 No No 28 29 30 Admit Admit Admit 77 1245 3.50 No No 3345 3566 77 1400 3.61 No No Admit Edit