• Go to Zillow and find 20 houses in a city or zip code that you like.
• Copy the url (website address) into column A in an excel sheet
• Put the house price on column B
• Put the square feet of the house in column C
• Put the year the house was built in column G
• Calculate the Age of the house by subtracting Column G from "2020" and put it in column D
• Put the "walk score" in column E. If there is no walk score, you can't use this house in your data.
• Calculate the mean and standard deviations for columns B, C, D, and E
  • You can use the =average() and =stdev()
  • You can put them on the bottom of the data
• Run a regression with house price as the dependent variable and Size, Age, Walk Score as the independent variables

For each of the regressions, (there's 2), answer these questions below the output (like I do in the example)

• What is this model telling us?
• Which of these variables are individually significant at 5%?
  • Give your reason
• How much of the variation in house price is explained by the variation in the independent variables?
• Is the overall model significant at 5%?
• Tell me what b1, b2, and b3 mean
• Run another regression but this time only on variables Size, and Age
  • Is this model significant?
  • Is this model better or worse than the first one (the one with size, age, and walk score)?
    • How do you know?
• Turn in your answers in your excel sheet like in my example.