Going missingSome calculations involving blank values may give different results to what you might expect. For example, when you pass a blank value into the AND() function, it is treated as TRUE. This is often unhelpful. To make blanks behave in a sensible way in calculations, you must first convert them to be "not available" using NA(). This function takes no inputs, and returns a missing value. To convert a blank value to a missing value, use this pattern.=IF(ISBLANK(cell), NA(), cell)InstructionIn column H, use AND() to find women who have kids and get benefits.In column I, convert the blanks in column G to missing values.In column J, again find women who have kids and get benefits, this time using column I rather than G.please show the formula used to "has kids and gets benefits" , "gets benefits with missing values", has kids and gets benefits". Thank you Is non-whiteHas over 12 years of school?Is married?Has kids?Has young kids?Is head of household?Gets unemployment insurance benefits?Has kids and gets benefits?Gets benefits with missing valuesHas kids and gets benefits? TRUEFALSEFALSETRUEFALSETRUETRUE FALSEFALSEFALSEFALSEFALSEFALSEFALSE TRUEFALSEFALSETRUEFALSETRUE FALSEFALSETRUEFALSEFALSEFALSEFALSE FALSEFALSEFALSETRUETRUETRUETRUE FALSEFALSETRUETRUETRUEFALSEFALSE FALSEFALSEFALSEFALSEFALSETRUE FALSEFALSEFALSEFALSEFALSETRUE FALSEFALSETRUETRUEFALSEFALSETRUE FALSEFALSEFALSEFALSEFALSEFALSETRUE FALSEFALSEFALSEFALSEFALSEFALSETRUE FALSEFALSETRUETRUETRUEFALSEFALSE FALSETRUEFALSEFALSEFALSEFALSETRUE FALSEFALSEFALSEFALSEFALSETRUE FALSEFALSETRUETRUETRUEFALSE FALSEFALSETRUETRUETRUEFALSETRUE TRUEFALSEFALSETRUETRUETRUEFALSE FALSEFALSETRUETRUEFALSEFALSEFALSE FALSEFALSEFALSETRUETRUETRUE FALSEFALSETRUETRUEFALSEFALSETRUE FALSEFALSEFALSEFALSEFALSEFALSETRUE FALSEFALSETRUETRUEFALSEFALSEFALSE FALSEFALSETRUETRUEFALSEFALSE FALSEFALSETRUETRUETRUEFALSEFALSE

column H: We need to find women who have kids and get benefits women who have kids are available…

Answered: In column H, use AND() to find women…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Going missing

Some calculations involving blank values may give different results to what you might expect. For example, when you pass a blank value into the AND() function, it is treated as TRUE. This is often unhelpful. To make blanks behave in a sensible way in calculations, you must first convert them to be "not available" using NA(). This function takes no inputs, and returns a missing value. To convert a blank value to a missing value, use this pattern.

=IF(ISBLANK(cell), NA(), cell)

Instruction

In column H, use AND() to find women who have kids and get benefits.
In column I, convert the blanks in column G to missing values.
In column J, again find women who have kids and get benefits, this time using column I rather than G.

please show the formula used to "has kids and gets benefits" , "gets benefits with missing values", has kids and gets benefits". Thank you

Is non-white	Has over 12 years of school?	Is married?	Has kids?	Has young kids?	Is head of household?	Gets unemployment insurance benefits?	Has kids and gets benefits?	Gets benefits with missing values	Has kids and gets benefits?
TRUE	FALSE	FALSE	TRUE	FALSE	TRUE	TRUE
FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
TRUE	FALSE	FALSE	TRUE	FALSE	TRUE
FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE
FALSE	FALSE	FALSE	TRUE	TRUE	TRUE	TRUE
FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	FALSE
FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	TRUE
FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	FALSE
FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	TRUE
FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
FALSE	FALSE	TRUE	TRUE	TRUE	FALSE
FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE
TRUE	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE
FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	FALSE
FALSE	FALSE	FALSE	TRUE	TRUE	TRUE
FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	TRUE
FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	FALSE
FALSE	FALSE	TRUE	TRUE	FALSE	FALSE
FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	FALSE