Vanguard Mortgage Company

You are an analyst for the Vanguard Mortgage Company has been using a spreadsheet created by you in the past which functions well. The current worksheet you created currently contains the customer’s account, the cost of the house, down payment, amount financed, mortgage rate, loan years (e.g. 30 year), % financed, date financed and payoff year. You have been tasked with enhancing the worksheet to include noted basic summary statistics. Which sorts of summary statistical methods would you include in the updated workbook? Describe at least six statistical measures that you would use so that you could explain them to your supervisor.

Assignment Solutions