Practice Problem #3A
Company want to conduct a focus groups and want to identify a group customer based on the following rule:
If the customer has children and has generated revenue of more than $10,000, then the customer is
in the focus group, otherwise the customer is not in focus group.
If the customer does not have children, then if the customer is from CA or MA and has generated revenue of
more than $5,000, then the customer is in focus group, otherwise, not in the focus group.

Answers: But how do I get here?

AutoSave OFF Ce IF_example-2 (1).xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 10 ~ = = ab Wrap Text General A Mo O 0 Paste B I U Av E Merge & Center $ % ) -28 Insert Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data G9 fx B C D E F G H | J K L . N 0 P C 1 Practice Problem #3A 2 Company want to conduct a focus groups and want to identify a group customer based on the following rule: 3 If the customer has children and has generated revenue of more than $10,000, then the customer is 4 in the focus group, otherwise the customer is not in focus group. 5 If the customer does not have children, then if the customer is from CA or MA and has generated revenue of 6 more than $5,000, then the customer is in focus group, otherwise, not in the focus group. 7 Revenue Focus Name State Gender Age Children 8 generated Group? 9 A1 CA F 45 Yes $ 6,412.00 10 B1 MA F 26 No $ 6,870.00 11 C1 co F 40 Yes $ 2,061.00 12 A2 AK F 51 Yes $ 12,598.50 13 B2 MA F 29 No $ 8,698.25 14 C2 LA F 25 Yes $ 778.05 15 A3 CA F 35 Yes $ 5,250.60 16 B3 MA F 36 Yes $ 26.85 17 C3 CO M 49 Yes $ 340.10 18 A4 AK M 44 No $ 31,248.75 19 B4 MS F 19 Yes $ 22,948.65 20 C4 LA F 20 Yes $ 28,048.35 21 A5 AK M 55 No $ 12,598.50 22 23 24 25 26 27 28 29 Exercise AND OR IF_Example Practice Problem 1 Practice Problem #2 Practice Problem #3 + Ready 155% O 5. IF_example_SOLUTION - Excel File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do X X Cut Arial - 10 - AA - ab Wrap Text . General Copy LE Paste BIU... DA- A Merge & Center - $ - % & - 4.0.00 Conditional Format as Cell Format Painter Insert Delete Format .00.0 Formatting Table Styles Clipboard Font Alignment Number Styles Cells 19 X fix =IFS(AND(E9="YES",F9>10000), "Yes", AND(OR(B9="CA",B9="MA"),F9>5000), "Yes",TRUE,"No") B D E F G H J J K L M M 1 Practice Problem #3 2 3 Company want to conduct a focus groups and want to identify a group customer based on the following rule: 4 If they have children and have generated revenue of more than $10000, then they are in focus group. 5 If not, then if they are from CA or MA and have revenue generated of more than $5,000, then they are in focus group. Otherwise, not in focus group 6 7 Revenue Name State Gender Age Children Focus Group? IFS? Easier way #3 Nes generated No 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 252882883732 CA MA CO AK MA LA CA MA AK MS LA AK F F F F F F F F F M M F F F M 45 26 40 51 29 25 35 36 49 44 19 20 55 Yes No Yes Yes No Yes Yes Yes Yes No Yes Yes No NT$ 6,412.00 NT$ 16,870.00 NT$ 2,061.00 NT$ 12,598.50 NT$ 8,698.25 NT$ 778.05 NT$ 5,250.60 NT$ 26.85 NT$ 340.10 NT$ 31,248.75 NT$ 22,948.65 NT$ 28,048.35 NT$ 12,598.50 Yes Yes No Yes Yes No Yes No No No Yes Yes No Yes Yes No Yves Yes No Yes No No No Yes Yes No Yes Yes No Yes Yes No Yes No No No Yes Yes No Yes No Yes Yes No No No No No Yes Yes No Yes Yes No Yes Yes No Yes No No No Yes Yes No Practice Problem 1 Solution Practice Problem #2 Soln Practice Problem #3 Ready