DDI-CDI Exercise: Roles for Data Points

The following exercise shows a data set expressed in two different ways, and asks you to identify the roles played by the data points.

Scenario

Two people have taken a survey, and a data set has been collected. It is for a study of education and income, looking at age and sex differences over time. Each response is validated before the data are accepted. It can be formatted as a Wide Data Set or as a Long Data Set.

    Robert Murphy: a 25-year-old male university graduate who makes 12.000 EUR per year

    Antonia Esperanza: a 12-year-old female school child who makes 250.000 EUR per year (she has an extremely popular YouTube channel!)

Instructions

Drag the "roles" (colored boxes) from the left-hand panel onto the cells of the table. Some cells need more than one box!

If the role is correct, the box will stay where you put it. If it does not, it will refuse to drop!

(Note that you do not need to use all the boxés.)

Wide Format

Name Date Age Sex Education Level Income (EUR/Year) Validated
Murphy, Robert 2020 25 M BA 12000 Yes
Esperanza, Antonia 2020 12 F N 250000 Yes

Long Format

Name Date Measure Value Validated
Murphy, Robert 2020 Age 25 Yes
Murphy, Robert 2020 Sex M Yes
Murphy, Robert 2020 Education BA Yes
Murphy, Robert 2020 Income 12000 Yes
Esperanza, Antonia 2020 Age 12 Yes
Esperanza, Antonia 2020 Sex F Yes
Esperanza, Antonia 2020 Education N Yes
Esperanza, Antonia 2020 Income 250000 Yes