Question $1$: HW$3.$xls is provided in the uploaded media folder under files in canvas. This is data for one subdivision of located defects using Ultrasonic Testing for a number of years. Please answer the following:

Determine the span of years for which data is provided, i$.$e$.N=9$ years

a$.$ Hint: create a new data column using the $=$YEAR$()$ function fron DATE$\_$FOUND field

Create a table with four columns and N rows. Columns: Year of defect number of total defects, number of TDDs$,$ an percentage of TDDs compared to total. The rows in the table should be one for each year in the span of the $N$ years of data.

a$.$ Hint: use the $=$ COUNTIFS $)$ statement

b$.$ Note this is relatively easy to do $($minutes$).$ May take you some time if you need to read the help section and find an example of the $=$ COUNTIFS $)$ statement.

Create a plot of TDDs and Total defects $($ordinate$)$ versus Tear $($abscissa$)$