Name Box Department Information Systems Marketing Finance Marketing Finance Mark
ID: 364625 • Letter: N
Question
Name Box Department Information Systems Marketing Finance Marketing Finance Marketing Finance Marketin Finance GPA 75 85 GMAT score 567 553 645 741 experience Experience Level average Applicant id School based Finacial aidDepartment based Finacial aid Domestic Internationa Domestic International International Internationa International International International International International Domestic Domestic Domestic Domestic Domestic International Domestic Domestic Domestic IVALUE! 10 10 95 92 87 607 619 97 85 90 10 a nformation Systems 611 691 628 average Finance Marketing Information Systems Marketin Finance Information Systems Finance Marketing Information Systems Marketing 12 13 723 627 655 631 670 590 87 96 average average 15 16 17 18 10 83 89 91 20Explanation / Answer
a) D24 =(COUNTIFS(C2:C21,"Marketing",E2:E21,">650"))+(COUNTIFS(C2:C21,"Finance",E2:E21,">650"))
Use "countifs" function for counting 1st the marketing gmat score above 650 then Finance gmat score above 650
b) E24 =(SUMIF(C2:C21,"Marketing",D2:D21)+SUMIF(C2:C21,"Finance",D2:D21))/(COUNTIF(C2:C21,"Marketing")+COUNTIF(C2:C21,"Finance"))
1st use sumif function to calculate total gpa for marketing and finance, then divide it by countif function to have the denominator for average
2) =IF(F2<3,"Low",IF(F2<5,"Average","High")
SImilarly use for all other cells from F3:F21 to find the low average or High experience level. Tisis nested IF function, If less than 3 it will return Low, else It will again check IF it is less than 5 and return Average if true else return High.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.