https://1drv.ms/x/s!AmhwsT40-eCoih5A_3n6WFvRqtmV?e=e9or32

1. In the U.S, Taxpayers are allowed to deduct mortgage interest (USD) from their incomes before calculating the amount of income tax they are required to pay. They sampled 400 tax returns that had a mortgage interest deduction and recorded the amounts. The amount of mortgage interest and house size categories (small. medium and large) can be found in the Excel file AS1.XLSX (Mortgage interest).

a) Sort mortgage interest (USD) in a appropriate number of classes and give the frequency distribution. Draw a histogram. What does the shape of histogram tell you?

b) Consider the mortgage interest (USD) and compute the population standard deviation and the coefficient of variation. Compare the standard deviation for individual data and grouped data in part a.

c) Find the mode of mortgage interest (USD). What does this tell you?

!!!!!N.B: The Excel data spreadsheet for resolution are copied on the first line and underlined !!!!!!!!!