Data Analyst Applicants Expertise

From the Venn diagram regions:

• The number of candidates with expertise ONLY in Data Analysis & Database Handling is $2 - x \ge 0 \implies x \le 2$.
• The number of candidates with expertise ONLY in Database Analysis & Coding is $6 - x$.
• The number of candidates with expertise ONLY in Database Handling & Coding is $3 - x$.
• The number of candidates with expertise ONLY in Database Handling is $5 - (2-x) - (3-x) - x = x - 2 \ge 0 \implies x \ge 2$.

Since $x \le 2$ and $x \ge 2$, $x$ must be $2$ only.

With $x = 2$, the number of applicants in each region of the Venn diagram are:

• Only Data Analysis: $12 - (2-x) - (6-x) - x = 12 - 0 - 4 - 2 = 6$
• Only Database Handling: $x - 2 = 0$
• Only Coding: $7 - (6-x) - (3-x) - x = 7 - 4 - 1 - 2 = 0$
• Exactly two fields: $(2-x) + (6-x) + (3-x) = 0 + 4 + 1 = 5$
• All three fields: $x = 2$

Total applicants with at least one field of expertise $= 6 + 0 + 0 + 5 + 2 = 13 + x = 15$. Total shortlisted applicants $= 41$. Applicants without advanced expertise in any of the three fields $= 41 - 15 = 26$.