/* Stata Do File to Test for Multicollinearity */

/* Import Excel Dataset */
import excel "C:\Documents\Classes\Econ4230\R_and_Stata\Data\hprice.xlsx", sheet("hprice") firstrow

/* Descriptive Statistics */
summarize

/* Multivariate OLS Regression */
regress price sqrft bedrooms lotsize

/* Pairwise Correlation Matrix */
pwcorr sqrft bedrooms lotsize

/* VIFs */
estat vif