In column H, find women who are white or have over 12 years of school   In column I, find women who match the previous condition and get unemployment insurance benefits.   In cell A28, define a filter to return only the rows that match conditions in column I. please show the excel solution of "is white or has over 12 years experience"and " is white or has over 12 years experience) and gets unemployment insurance benefits?",thank you :)

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...
icon
Related questions
Question

The third logical operator is OR(). This returns TRUE when any of its inputs is TRUE.

 

For example, OR(FALSE, TRUE, FALSE) returns TRUE since the second input is TRUE, but OR(FALSE, FALSE, FALSE) returns FALSE since all its inputs are FALSE.

 

In column H, find women who are white or have over 12 years of school

 

In column I, find women who match the previous condition and get unemployment insurance benefits.

 

In cell A28, define a filter to return only the rows that match conditions in column I.

please show the excel solution of "is white or has over 12 years experience"and " is white or has over 12 years experience) and gets unemployment insurance benefits?",thank you :) 

Has young kids? Is head of household? Gets unemployment insurance benefits? Is white or has over 12 years experience? (Is white or has over 12 years experience) and gets unemployment insurance benefits?
FALSE TRUE TRUE    
FALSE FALSE FALSE    
FALSE TRUE TRUE    
FALSE FALSE FALSE    
TRUE TRUE TRUE    
TRUE FALSE FALSE    
FALSE TRUE FALSE    
FALSE TRUE FALSE    
FALSE FALSE TRUE    
FALSE FALSE TRUE    
FALSE FALSE TRUE    
TRUE FALSE FALSE    
FALSE FALSE TRUE    
FALSE TRUE FALSE    
TRUE FALSE TRUE    
TRUE FALSE TRUE    
TRUE TRUE FALSE    
FALSE FALSE FALSE    
TRUE TRUE TRUE    
FALSE FALSE TRUE    
FALSE FALSE TRUE    
FALSE FALSE FALSE    
FALSE FALSE TRUE    
TRUE FALSE FALSE    
         
Has young kids? Is head of household? Gets unemployment insurance benefits? Is white or has over 12 years experience? (Is white or has over 12 years experience) and gets unemployment insurance benefits?

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

In cell I2, define a filter on the whole dataset (columns A to G), 

 

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY