Question #$1(12$ Points$)$:

Consider the Excel "Homework $2\_$Dataset.xlsx$"$ which lists watermains of an existing network. Prepare an

inventory figures that would summarize the water pipeline inventory of the network. Provide the following:

Figure "Length $($Miles$)$ by Pipeline Material Types"

a$.$ Include the figure any gaps in the data as "Unknown"

Figure "Length $($Miles$)$ by Decades of Installation"

a$.$ Include the figure any gaps in the data as "Unknown"

Figure "Length $($Miles$)$ by Material and Decades of Installation

a$.$ Include the figure any gaps in the data as "Unknown"

The $\%$of length of pipelines with missing installation years $($up to two decimal places$)$

The total $\%$ of length of pipelines with missing diameters $($up to two decimal places$)$

The total $\%$ of length of pipelines with missing material types $($up to two decimal places$)$

Make sure to produce figures that are readable in PDF format. Do not forget to include legends in your

figure.

Question #$2(8$ Points$)$

List $6$ assets or more in your house $($recall the difference between an inventory and a hierarchy$)$

Don't include furniture

Group assets into categories based on different levels considering any classification system

$($choose your preferred system$).$ I added some resources in CANVAS.

Describe the type of assets

Record other information that is useful for life cycle costing including condition $($Very Good, Fair,

or Very Poor$)$

You can build a chart for the asset hierarchy and show the inventory in a table $($similar to below$).$