Question: 3 a ( 5 pts ) . Find car loans ( new or used ) by males who have been employed for at least 3

3a (5 pts ). Find car loans (new or used) by males who have been employed for at least 36 months.
3b (5 pts). Based on your answer to (3a), use Excel functions to compute the number of loans on the shortlist and the average months employed by the loan applicants.
Just need help with 3b
3 a ( 5 pts ) . Find car loans ( new or used ) by

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

Students Have Also Explored These Related Programming Questions!

Q:

Q1. The Excel file MBA Motivation and Salary Expectations provides data on students' pre- MBA salary and post-MBA salary expectations. Define range names for each of these ranges and then use the...

Q:

QUESTION 1 Answer following questions based on the Excel le Credit Risk Data. You can download the CreditRiskData.xlsx from the book datasets in the course content. How many individuals with new-car...

Q:

Apply the advanced filter to the credit risk data ( Base Data Worksheet ) to find the following: A ) All new car loans obtained for single females. B ) All furniture loans obtained for single...

Q:

Apply the Advanced Filter to the Credit Risk Data (Base Data worksheet) to find the following: a. All new car loans obtained for single females. b. All furniture loans obtained for single individuals...

Q:

Apply the advanced filter to the credit risk data ( Base Data Worksheet ) to find the following: A ) All new car loans obtained for single females. B ) All furniture loans obtained for single...

Q:

Apply the advanced filter to the credit risk data ( Base Data Worksheet ) to find the following: A ) All new car loans obtained for single females. B ) All furniture loans obtained for single...

Q:

Question 11 pts Damian shares a small food truck with his sister. His share of the expenses is $500 per month. He has decided to get his own, newer food truck which he will not have to share with...

Q:

excel Use the given data to classify the record below using the k-NN algorithm for k=1 to 5. Click the icon to view the table of classified records. Distance Complete the table below for the nearest...

Q:

If you could please help me out with these questions i will appreciate it a lot. #1 A random sample of 305 car buyers was asked about the reason that they chose the car that they did. The results are...

Q:

STAT 1222 Spring 2012 Common Final Exam May 3, 2012 Please print the following information: Instructor: Name: Student ID #: Section/Time: THIS EXAM HAS TWO PARTS PART I. Consists of 30 multiple...

Q:

How is psychological egoism supposed to provide support for an argument for ethical egoism? What is one problem for this argument?

Q:

Debra has operated a family counseling practice for a number of years as a sole proprietor. She owns the condominium office space that she occupies in addition to her professional library and office...

Q:

19 If the Budget at Completion (BAC) is $500,000 and the Variance at Completion (VAC) is -$50,000, what is the Estimate at Completion (EAC)? $550,00 $600,00 $450,000 $500,000

Q:

B: Use the following to answer questions 26-29: Estimated demand for gold-filled lockets at Sam's Bargain Jewelry and Housewares is 3,000 lockets a year. The ordering cost is $40, and that the