I need help with a logical test below. I need to find missing data using the existing ones, I tried to do it through Excel but I'm stuck.

Can someone help me with how to do it through Excel or otherwise, with step by step instructions please?

The table contains all of the possible channels and combinations of channels that individuals could have been exposed to. Using the info in cells, infer the values of all of the remaining cells in rows and compute the value for the Total Unique Individuals Exposed.

Note: Maybe means info can include the respective value (i.e. maybe TV) or not include

Community Answer

We can solve this problem using a venn diagram.{:[P rarr" Point "],[T rarr TV],[D rarr" Digital. "]:}If we know the values of all i.e. (1) to (4), we can find any problem ori question asked from it.from given information, individuals exposed to P,T,epsi D=>(7)=9543.In the same way, (2) =75099^(@)(3) =13,581,759(5) =4,219,763.(2) =78,695,594Given, (6) ((6)=113,292=> (6) =113292-9543=103749.Given, lotal individuals in Point =2,165,359.[(1+theta+(6)+theta)].Individuals only exposed to point = (1) =[2165359-(4) -(6) -(7) ]=1976968.Individuals exposed to Pont and not digital (may be TV) =(1)+(4)=2052067.Individuals ceppsed to ... See the full answer