Here are a few common issues people are running into:
- When creating Dummy variables in Excel many are using the IF function but not getting it to work. You need to format the statement with double quotes around the neighborhood name like the following: =IF(G2=”Eastside”,1,0)
- Non-numeric data found and LINEST() errors seem to be related to the use of Filters in combination with the Regression function. To remedy, follow these steps.
- Copy your data
- Paste (values only) into a brand new worksheet
- Re-run regression
Please let me know if there are other issues to post here.