Problem for Assignment 1: Part A (Mini-project A) Jenny, a micro-entrepreneur, has a small business which sells products or applications which improve online viewing experience. She is considering borrowing money from a crowdlending platform to expand her start-up business. You happen to be Jennys friend. She discussed her business idea with you and would like to seek help from you about things she was eager to know. Essentially, Jenny would like you to help collect the data from a crowdlending platform, analyze the data, and share the insights from data analysis with her. These insights would help her understand how the platform operates and determines initiators loan interest rates. With this, she may be able to better prepare before posting her loan request on the platform. Suppose you have collected a dataset Assessment1_data1.xlsx which includes the information about the loan listings on an online platform and initiators demographics on an online crowdlending platform. Note that you can download the data file from the Assessment folder on Cloud Deakin. Using what you have learned from MMK 365 so far to conduct data analysis in Excel and prepare a business report which may be helpful for Jenny. Please follow the structure outlined above to prepare your report. Note that you need to discuss how your analysis framework can be used to generate insights in other scenarios (contexts). Hints: Answers for the following questions may be helpful for to obtain insights which Jenny needs

(1) What is the overall pattern of the loan interest rate in the collected data? How do the current initiators on the platform look like? (i.e., you need to summarize the variables related to the characteristics of current initiators on the platform).

(2) What is the relationship between credit score and loan interest rate?

(3) Except for credit score, what else may affect the loan interest rate? How do these factors affect loan interest rate? What do these effects imply?

(4) What will you suggest Jenny do based on your data analyses? For example, what matters to her at the beginning to seek the fund efficiently on the platform? Should she start with short-term loan or long-term loan? Why that might help?