Question 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 2,165,359 83,000,000 17,914,814 78,695,594 13,581,759 + All individuals exposed to Print All individuals exposed to TV All individuals exposed to Digital Individuals ONLY exposed to Print Individuals ONLY exposed to TV individuals ONLY exposed to Digital individuals exposed to Print_and NOT Digital (but maybe TV) individuals exposed to TV and NOT Digital (but maybe Print) Individuals exposed to Digital and NOT Print_(but maybe TV) Individuals exposed to Print and NOT TV (but maybe Digital) Individuals exposed to TV and NOT Print_(but maybe Digital) individuals exposed to Digital and NOT TV (but maybe Print) Individuals exposed to both Print and Digital (and maybe TV) individuals exposed to both TV and Digital (and maybe Print) individuals exposed to both Print_and TV (and maybe Digital) Individuals exposed to both Print_and Digital (and NOT TV) individuals exposed to both TV and Digital (and NOT Print) Individuals exposed to both Print and TV (and NOT Digital) Individuals exposed to Print, TV, Digital Total Unique Individuals exposed 113,292 4,219,763 75,099 9,543

FJIOED The Asker · Advanced Mathematics

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

Transcribed Image Text: 2,165,359 83,000,000 17,914,814 78,695,594 13,581,759 + All individuals exposed to Print All individuals exposed to TV All individuals exposed to Digital Individuals ONLY exposed to Print Individuals ONLY exposed to TV individuals ONLY exposed to Digital individuals exposed to Print_and NOT Digital (but maybe TV) individuals exposed to TV and NOT Digital (but maybe Print) Individuals exposed to Digital and NOT Print_(but maybe TV) Individuals exposed to Print and NOT TV (but maybe Digital) Individuals exposed to TV and NOT Print_(but maybe Digital) individuals exposed to Digital and NOT TV (but maybe Print) Individuals exposed to both Print and Digital (and maybe TV) individuals exposed to both TV and Digital (and maybe Print) individuals exposed to both Print_and TV (and maybe Digital) Individuals exposed to both Print_and Digital (and NOT TV) individuals exposed to both TV and Digital (and NOT Print) Individuals exposed to both Print and TV (and NOT Digital) Individuals exposed to Print, TV, Digital Total Unique Individuals exposed 113,292 4,219,763 75,099 9,543
More
Transcribed Image Text: 2,165,359 83,000,000 17,914,814 78,695,594 13,581,759 + All individuals exposed to Print All individuals exposed to TV All individuals exposed to Digital Individuals ONLY exposed to Print Individuals ONLY exposed to TV individuals ONLY exposed to Digital individuals exposed to Print_and NOT Digital (but maybe TV) individuals exposed to TV and NOT Digital (but maybe Print) Individuals exposed to Digital and NOT Print_(but maybe TV) Individuals exposed to Print and NOT TV (but maybe Digital) Individuals exposed to TV and NOT Print_(but maybe Digital) individuals exposed to Digital and NOT TV (but maybe Print) Individuals exposed to both Print and Digital (and maybe TV) individuals exposed to both TV and Digital (and maybe Print) individuals exposed to both Print_and TV (and maybe Digital) Individuals exposed to both Print_and Digital (and NOT TV) individuals exposed to both TV and Digital (and NOT Print) Individuals exposed to both Print and TV (and NOT Digital) Individuals exposed to Print, TV, Digital Total Unique Individuals exposed 113,292 4,219,763 75,099 9,543
Community Answer
JVQE7N

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