* -------------------------------------------------------------------
* Online Stats Training
* Stata: how to get started
* By Lion Behrens and Rens van de Schoot, Utrecht University
* -------------------------------------------------------------------

* Loading the datafile popular_regr_1.xlsx
cd "C:\Uyour working directory"
import excel "C:\your working directory\popular_regr_1.xlsx", sheet("test") firstrow

* Exercise 1a
pwcorr sd covert overt, sig

* Exercise 1b
regress sd covert overt