Credit Risk Data, Excel problems

Do these problems in a single MS-Excel document

1- “The Excel file Credit Risk Data provides information about bank customers who had applied for loans.6 The data include the purpose of the loan, checking and savings account balances, number of months as a customer of the bank, months employed, gender, marital status, age, housing status and number of years at current residence, job type, and credit-risk classification by the bank.”

2-“Use the COUNTIF function to construct a frequency distribution of the types of loans in the Excel file Credit Risk Data and develop a column chart to express the results visually.”

3-“A community health-status survey obtained the following demographic information from the respondents: Age Frequency 18 to 29 297 30 to 45 743 46 to 64 602 65 + 369”

4-“Use the Histogram tool to develop a frequency distribution and histogram with six bins for the age of individuals in the Excel file Credit Risk Data. Compute the relative and cumulative relative frequencies and use a line chart to construct an ogive.”

5-“Use the Histogram tool to develop a frequency distribution and histogram with six bins for the age of individuals in the Excel file Credit Risk Data. Compute the relative and cumulative relative frequencies and use a line chart to construct an ogive.”

 

"Is this question part of your assignment? We Can Help!"