Question: Write a function/formula in cell E24 that returns the average GPA of applicants who are from the department of finance or the department of marketing
Write a function/formula in cell E24 that returns the average GPA of applicants who are from the department of finance or the department of marketing
| Applicant id | Origin | Department | GPA |
| 1 | Domestic | Information Systems | 75 |
| 2 | International | Marketing | 85 |
| 3 | Domestic | Finance | 90 |
| 4 | International | Marketing | 95 |
| 5 | International | Finance | 92 |
| 6 | International | Marketing | 87 |
| 7 | International | Finance | 77 |
| 8 | International | Marketing | 80 |
| 9 | International | Finance | 97 |
| 10 | International | Information Systems | 85 |
| 11 | International | Finance | 90 |
| 12 | Domestic | Marketing | 90 |
| 13 | Domestic | Information Systems | 86 |
| 14 | Domestic | Marketing | 87 |
| 15 | Domestic | Finance | 96 |
| 16 | Domestic | Information Systems | 77 |
| 17 | International | Finance | 83 |
| 18 | Domestic | Marketing | 88 |
| 19 | Domestic | Information Systems | 89 |
| 20 | Domestic | Marketing | 91 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
