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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock