you need to combine three log logistic model(picture 1) Singh-maddala model(picture 2) dagum four-parameter model（picture 3) in one excel and graph. picture 4 is the datas that you will use in all three modelshere is value you need use for log logistic modelchi-sqrd=0.00119280969201685mu=3.107508k=0.28804here is the value you need for Singh-maddala modelchi-sqrd=0.329437686793337A1=5.732659E-05A2=3.0727A3=1.2095here is the value you need for dagum four-parameter modelchi-sqrd=7.34883388622251alpha=8.904737E-14lambda=25.177delta=2.147801beta=19.08809example of excel is the what you can use as reference, final version must be similar to it, I need both graphs and excel.

Do these problems in a single MS-Excel document1- "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."

I am currently stuck on these assignments and need help. I dont know where to begin. HELP! Below are the instructions and Excel docs. Thanks.