Tables in Stata - Econometrics - Lecture Slides, Slides of Econometrics and Mathematical Economics

Download Tables in Stata - Econometrics - Lecture Slides and more Slides Econometrics and Mathematical Economics in PDF only on Docsity!

1

TABLES IN STATA Tables for Exploration and Summary

2

Objectives

The Objectives of this lecture are:Use of tables & their importanceMaking

different

tables

to

answer

some

basic

questions

One-way tables (frequency tables)Multiple one-way tablesMultiple Two way tablesTable for continuous data

4

Tables for Exploration

The Table Menu is given as follows:

5

Tables for Exploration

The majority of variables ina survey data are usually

categorical

ANDA major part of the information is just the number of

observations that fall into each category.

How many children are there of school age?How many people get their water from rivers, wells or

boreholes?

These questions are simply and directly answered with

a frequency table.

7

Frequency Tables

The main tool in Stata for creating frequency tables is the tabulate

command. Go to Statistics Menu

Æ

Summaries, tables & tests

Æ

Tables

Æ

One-way tables

8

Frequency Tables

Select

the

Categorical

variable:

marital_c Select

‘Treat

missing

values

like

other values’. Select

‘Display

the

table

in

descending order of frequency’. The last option Sorts the categories

so^

that

you

can

see

at

a

glance

which

types

of^

categories

are

most

command

and

which

are

The following dialogue box appears: less common.

10

Multiple One Way Tables

With the help of ‘Frequency tables

’, we can explore a number of

(more than one) variables in our data set. Go to Statistics Menu

Æ

Summaries, tables & tests

Æ

Tables

Æ

Multiple one-way tables

11

Multiple One Way Tables

A dialogue box appears:Select Categorical variables as‘marital_c & sex’.Check the box: ‘treat missingvalues like other values’.Check

the

box:

‘Display

the

table

in^

descending

order

of

frequency’.Click OK.

13

Comparing Two Categorical VariablesHaving found the numbers of observations in each value of our

single

categorical

variables,we

may

wish

to^

refine

our

questions.

-^

Are different types of marital status in rural areas comparedto urban areas?

-^

Which district has the most unemployment?

-^

Are more men than women able to read? The

answers

to

these

questions

can

be

obtained

from

cross-

tabulation tables. When two variables are cross tabu

lated,

these

tables

are

often

called two-way tables.

Docsity.com

14

Two-way Cross-tabulation tables

Let us look at the relationship between sex and marital status.Select ‘Two-way tables with measure of association’ from the

menu.

16

Two-way Cross-tabulation tables

The following output is shown:The Stata command for doing this is:tabulate marital_c sex, miss

17

Two-way Cross-tabulation tables

The results in previous slide begin to answer our question but we

can go further. There are more never married men (1755) than never married

women (1556). But note that the number of men are more than the number f

women in the data. So this comparison is not meaningfulWe

can

make

the

comparison

meaningful

by

comparing

the

percentages of men & women who are never married.

Docsity.com

19

Two-way Cross-tabulation tables

comparing ‘Percentages’

The output is shown:Now

you

have

a^

clear

answer: 1755/3311=53.01%

of

male household headsare

never

married

while

only

1556/3311=46.99%of^

female

household

heads

are

never

married. The stata command is;tabulate marital_c sex, row

20

Two-way Cross-tabulation tables

comparing ‘Percentages’

You can choose ‘within column relative frequencies’ to answer“Among

those

households

whom

are

never

married,

what

percentages are women?” If you want to ask:“Out

of

all

household

heads

interviewed,

what

percentage

are

both female and never married”, Then use the ‘relative frequencies’ option to get the percentage

of total observations in each cell. The corresponding commands for these options are: tabulate marital_c sex, coltabulate marital-c sex, cell

Docsity.com