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. of Atnences Calvin McsFreshman sephomore Sonja George Freshman 12 For each task below, give the formula that we would need using COUNTIE, SUMIF, or AVERAGEIF. For each formula, also state the output of the formula formatted to 2 decimal places (2.5 Points Each) c. Calculate the total number of absences for all freshman students. f. Calculate the number of students who missed 4 or more classes. g. Calculate the total number of absences for all students who scored at least a 70 on the exam. h. Calculate the average exam score for the students who missed exactly 3 classes 2. For each scenario below, state whether it would be better to use a column chart or a line chart to represent the data. (2 Points Each) a. Display a company's quarterly profits from the past two years. b. Display a company's profit for a single quarter and comparing the contribution of each division. c. Display and compare the total number of products sold in a company's electronics department. d. Display the projected revenue of a company for the next five years. e. Display and compare the product sales of all regional stores of a company.

Explanation / Answer

Please give the thumbs up, if it is helpful for you!!. Let me know if you have any doubts.

Solution 1)

e) =SUMIFS(D2:D11,B2:B11,"f")

f) =COUNTIFS(D2:D11,">=4")

g) =SUMIFS(D2:D11,C2:C11,">=70")

h) =AVERAGEIFS(C2:C11,D2:D11,"=3")

Solution 2)

a) Line chart

b) Column chart

c) Column chart

d) Line chart

e) Column chart

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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