Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
By only using Excel functions (no scratch work or pivot tables), create new columns of data to indicate customers who meet the following criteria: Customers
By only using Excel functions (no scratch work or pivot tables), create new columns of data to indicate customers who meet the following criteria:
- Customers whose checking account has more than $10,000
- Customers who local branch is Mesa and own their own houses with no mortgage
- Customers with either more than $12,000 in their checking or more than $16,000 in their savings
Please let me know what formulas used, in which cells they are placed in and any other potent information using only excel
DATA
| Local Branch | Checking Total | Savings Total | Membership full years | Housing Type | Cust. savings less than $1,000? (1 = Yes, 0 = No) |
| Phoenix | $ 14,532.02 | $ 3,730.26 | 5 | Rent | 0 |
| Mesa | $ 5,872.79 | $ 4,441.84 | 2 | Other | 0 |
| Flagstaff | $ 10,745.51 | $ 35,711.40 | 6 | Other | 0 |
| Flagstaff | $ 1,374.56 | $ 8,227.38 | 4 | Other | 0 |
| Flagstaff | $ 339.99 | $ 61.03 | 21 | Own (Mortgage) | 1 |
| Tucson | $ 1,279.72 | $ 16,734.61 | 3 | Own (No Mortgage) | 0 |
| Tucson | $ 4,293.68 | $ 3,653.68 | 2 | Other | 0 |
| Flagstaff | $ 5,366.53 | $ 29,107.18 | 0 | Other | 0 |
| Tucson | $ 1,912.55 | $ 2,148.95 | 1 | Own (Mortgage) | 0 |
| Phoenix | $ 4,332.41 | $ 1,561.38 | 6 | Rent | 0 |
| Flagstaff | $ 18,638.92 | $ 321.97 | 5 | Other | 1 |
| Mesa | $ 15,764.68 | $ 6,518.29 | 4 | Rent | 0 |
| Mesa | $ 10,963.35 | $ 552.45 | 1 | Own (Mortgage) | 1 |
| Mesa | $ 6,051.82 | $ 4,810.80 | 3 | Own (No Mortgage) | 0 |
| Mesa | $ 8,197.35 | $ 6,326.65 | 0 | Own (No Mortgage) | 0 |
| Tucson | $ 13,938.41 | $ 2,497.00 | 14 | Other | 0 |
| Phoenix | $ 2,214.99 | $ 3,083.23 | 2 | Rent | 0 |
| Tempe | $ 1,210.75 | $ 25,779.19 | 2 | Rent | 0 |
| Flagstaff | $ 8,756.57 | $ 290.42 | 2 | Own (No Mortgage) | 1 |
| Phoenix | $ 4,031.87 | $ 1,289.22 | 15 | Own (Mortgage) | 0 |
| Tempe | $ 321.44 | $ 1,990.10 | 9 | Own (Mortgage) | 0 |
| Mesa | $ 6,248.68 | $ 241.92 | 1 | Other | 1 |
| Phoenix | $ 5,728.17 | $ 18,797.67 | 1 | Rent | 0 |
| Tempe | $ 6,002.61 | $ 7,359.45 | 10 | Own (No Mortgage) | 0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started