write a formula in cell d15 to calculate the average verbal scores for each type
ID: 3753825 • Letter: W
Question
write a formula in cell d15 to calculate the average verbal scores for each type (t/r) of student application. write the formula so that it may be copied down the column and across the row into cells d15:f16 to calculate the average for regular students verbal sat and then for each catagory math sat ect D15 Evaluation of Candidates 2 Weight in final score 20% 40% 40% Verbal Math SCi Weighted SAT SAT SATI score 4 Mary Keck 5 Alex Jones 6 Mark Wale 7 Timoty Watkins 8 Scott Sharp 9 Brent Smith 10 AVERAGE 11 MINIMUM 12 MAXIMUM 580 640 670 660 710 730 70167 73167 66500 680 770 700 590 690 780 670 690 730 780 800 720 636 686 700 694 742 736 699.00 636.00 742.00 R 590.00 600 580.00636 78000 80000 73000 #of AVG AVG students (verbal)(math) (SCI) AVG 14 15 transfer students T 16 regular students R 3.00 3.00 Sheet1 Sheet2 Sheet3Explanation / Answer
=AVERAGEIF(C4:C9,"T",B4:B9);
=AVERAGEIF(C4:C9,"R",B4:B9);
Above formulas are used to calculate average of verbal for T students and second formula calculates for R students
For average of math the formula is :
=AVERAGEIF(D4:D9,"T",B4:B9);
=AVERAGEIF(D4;D9,"R",B4:B9);
For average of science the formula is :
=AVERAGEIF(E4:E9,"T",B4:B9);
=AVERAGEIF(E4:E9,"R",B4:B9);
PASTE THESE FORMULAS IN D15 TO F16 as needed.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.