As guided through the videos, please make sure that data for all years is saved in Excel format, and in each year of data the variables have been reduced from $99$ to $27.$ Make sure this has been done for all files: $2005,2007,2009,2011,$ and $2013.$

First, let$$s take a look at the data file for year $2005.$ You should have a total of $46854$ rows in this file $($including the header row$).$

Without doing any $$data cleaning$$ for $$missing$$ or $$suspect$$ data, please calculate the average market value $($in $$)$ across all housing units for year $2005,$ rounding to two decimal places.