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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!