Data exploration $(9$ pts$.)$

$1.(1$ pt$.)$ What is the most common JOB$\_$CATEGORY for which permits have been issued in $2018-$

$2019?$

$2.(1$ pt$.)$ How many permits of the BUILDING$\_$TYPE $$Single Detached House$$ have been issued in

$2019($i$.$e$.,$ on or after $2019-01-01,$ inclusive$)?$

$3.(1$ pt$.)$ On what date was the permit with the largest CONSTRUCTION$\_$VALUE issued?

$4.(1$ pt$.)$ Report the total number of permits issued between $2018-05-15$ and $2019-05-14$

$($inclusive$).$

$5.(1$ pts$.)$ Determine the proportion of all permits issued for $$Apartment Condos$$ that the work

involved $$Exterior Alterations$?$ Note that "Apartment Condos" is a BUILDING$\_$TYPE and that

$$Exterior Alterations$$ is a WORK$\_$TYPE.

$6.(4$ pts$.)$ Determine the average, sample standard deviation, minimum, and maximum for the

CONSTRUCTION$\_$VALUE of the $$House Combination$$ permits? Note that $$House Combination$$

is a JOB$\_$CATEGORY.

Note $1$: For Questions $1-5,$ you may find some of the following Excel functions useful: COUNT,

COUNTIF, AVERAGE, AVERAGEIF, MIN, MAX, INDEX, MATCH. You may also find filtering and pivot