Question: The Local representative of the community is concerned that there is a growing gap in the number and amount of loans given to small business owners among different ethnic groups . Use the data in the attached Excel file (MINOR_LOANS) describe the differences in the trend in the number and amount among different ethnic groups. a. In order to resolve the issue raised by the manager, you need to plot a time series chart of the number of loans given to African, Hispanic and Asian small business owners. b. You should calculate the Average Amount of Loans given to each ethnic group between 1980 and 2005 and plot a chart comparing the trends in the differences in the average amount loans by Ethnicity.