Researching and understanding hypothetical situations involving math

1.) Using an appropriate spreadsheet package provide an amortization schedule for the car loan you intend to buy. Describe the spreadsheet/software you used and the mathematical formula used in computing monthly payment . Create a table that includes Payment #, Monthly Payment, Interest, Unpaid Balance Reduction and Unpaid Balance.
2.) Using a mathematical software with a regression capability, find the regression equationI(x) for Interest payments as a function of payment number (x) from your amortization table.
3.) Using a mathematical software with a regression capability, find the regression equationU(x) for Unpaid Balance Reduction a function of payment number (x) from your amortization table. Round your figures to two decimal places.
4.) Create the graphs ofI(x) and U(x) on separate coordinate planes using appropriate technology. Your plots should be clear with appropriate axes, labels, scaling and titles.
5.) Compare both graphs (i.e. discuss some relationships between the two graphs).
6.) You would like to pay off the car faster. Give at least three options that may be available. Order these options in terms of practicality and explain how you decided upon such ordering. Be specific about how much the loan period is shortened.
7.) Technology Considerations: Discuss what technology you chose to use for your displays of quantitative data (scatter plots
and graphs) and why. Discuss what technology you chose to create your scatterplots, graphs, linear regression equations and to generate your amortization table. Also provide reasons why you chose a particular technology instrument. For full credit be sure to discuss what technology options you considered, the pros and cons of each, and what considerations or concerns led you to make the choice you made.