1. Suppose you are given the following spreadsheet containing student names, the

Question

1. Suppose you are given the following spreadsheet containing student names, their status, scores for an exam, and the number of absences. 1 Student Status 2Lorraine Rowe sunior Calvin Moss Freshman Burton Ser 7Sonja George Freshman 8 Stella Moore Sunior 9 Stuart Barber Senicr 10 Janis Flowers Freshman 11 Cristina Morris Junior 12 For each task below, give the formula that we would need using COUNTIF, SUMIF, or AVERAGEIF. For each formula, also state the output of the formula formatted to 2 decimal places (2.5 Points Each) a. Calculate the number of seniors. b. Calculate the average exam score for all juniors. c. Calculate the average exam score for all students who missed at most 2 classes. d. Calculate the number of students who scored less than 60 on the exam.

Explanation / Answer

Hi,
1. To count number of seniors, we can use
COUNTIF(B2:B11,"Senior")
2. to calculate average score of all juniors
AVERAGEIF(C2:C11, "junior")

3. calculate average score for students who missed atmost 2 classes

AVERAGEIF(C2:C11,D2:D11,"<=2")
4.number of students with score less than 60
COUNTIF( B2:B11 , "<60")

Thumbs up if this was helpful, otherwise let me know in comments

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.