Create an Excel Workbook that has a different sheet for all of the following problems, which is due on the date listed on the Course Schedule.
Problem 1: Research and find fuel economy for at least 10 different, similarly sized cars and create a table of the data. Then calculate the cost associated with driving each of those cars 500 miles. Then select an appropriate graph style to represent the data.
Problem 2: Research the price of your ideal car to drive, then calculate the payments for a 60 month financing with interest rates ranging from 3 to 10% with 1% increments. Create a graph that represents the data.
Problem 3: Research the population of one country on 3 different continents for at least 4 different years spanning from 1950 to present. With this data create an exponential fit to the data using the trendline feature in Excel.
I am an expert in Ms excel and a professional financial analyst. Further, I also know advance financial modeling. Therefore, I can aptly undertake your work. For more details, contact me