Test the following hypotheses and provide your conclusion (in excel):

b) Older houses have lower price. (You will have to create the "age" variable with respect to 2014 and 2015 using yr_built data).

-How do I make a "age" variable using the data below in excel and how do I test this hypothesis?

E7 X V A B C D price yr_built Year 221900 1955 2014 538000 1951 2014 180000 1933 2015 604000 1965 2014 510000 1987 2015 1225000.0000 2001 2014 257500 1995 2014 291850 1963 2015 229500 1960 2015 323000 2003 2015 662500 1965 2015 468000 1942 2014 310000 1927 2014 400000 1977 2014 530000 1900 2015 650000 1979 2015 395000 1994 2014 485000 1916 2014 189000 1921 2014 230000 1969 2015 385000 1947 2014 2.006+06 1968 2014 285000 1995 2014 252700 1985 2014 329000 1985 2014 233000 1941 2014 8 937000 1915 2014 667000 1909 2014 438000 1948 2014 719000 2005 2015 580500 2003 2014 280000 2005 2014 687500 1929 2014 535000 1929 2014 322500 1981 2014 7 696000 1930 2014 kc house_data Sheet4