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:

AutoSave OFF Ce IF_example.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Arial 10 ~ = = ab Wrap Text General TV A Mo ru O Paste B I U Av E Merge & Center -28 Insert $ %) Delete Conditional Format Cell Formatting as Table Styles Format Sort & Filter Find & Select Analyze Data H9 - 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 #3A 8 generated Group? 9 A1 CA F 45 Yes $ 6,412.00 Yes 10 B1 MA F 26 No $ 6,870.00 Yes 11 C1 co F 40 Yes $ 2,061.00 No 12 A2 AK F 51 Yes $ 12,598.50 Yes 13 B2 MA F 29 No $ 8,698.25 Yes 14 C2 LA 25 Yes $ 778.05 No 15 A3 CA 35 Yes $ 5,250.60 Yes 16 B3 MA 36 Yes $ 26.85 No 17 C3 CO M 49 Yes $ 340.10 No 18 A4 AK 44 No $ 31,248.75 No 19 B4 MS 19 Yes $ 22,948.65 Yes 20 C4 LA 20 Yes $ 28,048.35 Yes 21 A5 AK 55 No $ 12,598.50 No 22 23 24 25 26 27 28 29 377337 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