Question: LAB 1 ASSIGNMENT BIAM110 Create a new worksheet at the end and name it Step 3. In cell A1, enter Number of customers without any
LAB 1 ASSIGNMENT BIAM110 Create a new worksheet at the end and name it Step 3. In cell A1, enter "Number of customers without any mortgages" and calculate the number of customers without any mortgage accounts in cell B1. Hint: you will want to utilize the count command in cell B1. Calculate the percentage of in C1 based on the 50 customers. In cell A2, enter "Number of customers without any car loans" and calculate the number of customers without any car loans in cell B2. Hint: you will want to utilize the count command in cell B2. Calculate the percentage of in C2 based on the 50 customers. In cell A3, enter "Number of customers without any investment accounts" and calculate the number of customers without any investment accounts in cell B3. Hint: you will want to utilize the count command in cell B3. Calculate the percentage of in C3 based on the 50 customers. In rows 4 through 6, repeat the previous two items (item 6 and 7) to determine the number of customers without direct deposit, number of customers with a deposit balance greater than $200,000, and number of customers with a deposit balance less than $10,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
