Create a new worksheet titled "Waterfront". Copy the waterfront column from the main dataset to thi worksheet to the new worksheet.

Now, create a table and a pie chart which gives the percentage of all homes which are waterfront

The output could look like the following screenshot. $[$HINT: Sort waterfront column for $0$ and $1$ and use the COUNTIF formula first to calculate number of houses with $0($not waterfront$)$ or $1($waterfront$)].$

Also make sure your name appears in cell F$2.$

$$

$$

$$

$4$

$5$

$\backslash$table$[[,$A$,B,$C$,$D$,E,$F$,$G$,H$