Jim is a real estate analyst for the Canada Housing & Mortgage Corporation

$($CHMC$)$ tasked with conducting a simple analysis of $30$ detached units in the

inner$-$city area of Calgary, Alberta. Support Jim by doing the following:

a$.$ Open the worksheet entitled $$Real Estate$.$

b$.$ Define the data range as a data table. Ensure banded rows are enabled.

c$.$ Create another table below the data that includes the following. Ensure

your table is formatted $($bolding or borders$)$ and has row and column

headers to make clear what each calculation refers to$.$

I. Calculate the mean, median, mode, min, and max of transaction

price, living area, lot area, closing date, and year built. If one or

more of these summary statistics is not possible to calculate

explain why.

d$.$ Create a scatter chart showing the correlation between transaction price

and living area. Include a title, labelled axes, trend line, and the equation of

the trend line. What is the slope and how could it be interpreted?