The data needs to be parsed and trimmed and formulas need to be created to get the headers from the labels tab. Add the headers to the top of the clean data sheet.

Show the formulas used in excel that were used to parse the data

1. Price: price, in dollars

2. Value: assessed value, in dollars

3. Rooms: number of bedrooms

4. Lotsize: size of lot, square feet

5. Housesize: size of house, square feet

6. Colonial: dummy =1 if home is colonial style

7. ln_Price: log(price)

8. ln_Value: log(assessed value)

9. ln_Lotsize: log(lotsize)

10. ln_Housesize: log(sqrft)

300000. 349100. 4.00000 6126.00 2438.00 1.00000 12.6115 12.7631 8.72030 7.79893

370000. 351500. 3.00000 9903.00 2076.00 1.00000 12.8213 12.7700 9.20059 7.63820

191000. 217700. 3.00000 5200.00 1374.00 0.000000 12.1600 12.2909 8.55641 7.22548

195000. 231800. 3.00000 4600.00 1448.00 1.00000 12.1808 12.3536 8.43381 7.27794

373000. 319100. 4.00000 6095.00 2514.00 1.00000 12.8293 12.6733 8.71522 7.82963

466275. 414500. 5.00000 8566.00 2754.00 1.00000 13.0525 12.9348 9.05556 7.92081

332500. 367800. 3.00000 9000.00 2067.00 1.00000 12.7144 12.8153 9.10498 7.63385