Stata Basics

Question 1

How to import excel spreadsheet in stata

Answer 1

File, import, excel spreadsheet, then click import first row as variable name (as first row of workshop 1 has all the variables we use e.g consumption (dependent) , income etc)

Question 2

How to analyse data

Answer 2

//analyse

Question 3

How to get summary of statistics on variables e.g use consumption and income

Answer 3

Type
Sum consumption income

Question 4

How to see how 2 variables are correlated

Answer 4

Type
Pwcorr consumption income (or 2 variables you look for)

Remember it is important to choose import first row as variable name, so the programme has identified the variables in order to analyse

Question 5

How to do a graph plot of 2 variables (use consumption and income)

Answer 5

Type
Twoway (line consumption year) (line income year)

Question 6

How to do a scatter plot of the 2 variables

Answer 6

Scatter consumption income

Question 7

How to estimate a regression function (parameters)1

Answer 7

Type
Reg consumption income