Data basics

Section 1.2 Data basics

You collect data on dozens of questions from all of the students at your school. How would you organize all of this data? Effective presentation and description of data is a first step in most analyses. This section introduces one structure for organizing data as well as some terminology that will be used throughout this book. We use loan data from Lending Club and county data from the US Census Bureau to motivate and illustrate this section’s learning objectives.

🔗

Objectives: Learning objectives

Identify the individuals and the variables of a study.
🔗

🔗
Identify variables as categorical or numerical. Identify numerical variables as discrete or continuous.
🔗

🔗
Understand what it means for two variables to be associated.
🔗

🔗

🔗

Subsection 1.2.1 Observations, variables, and data matrices

Table 1.2.2 displays rows 1, 2, 3, and 50 of a data set for 50 randomly sampled loans offered through Lending Club, which is a peer-to-peer lending company. These observations will be referred to as the loan50 data set.

🔗

Each row in the table represents a single loan. The formal name for a row is a case or observational unit. The columns represent characteristics, called variables, for each of the loans. For example, the first row represents a loan of $7,500 with an interest rate of 7.34%, where the borrower is based in Maryland (MD) and has an income of $70,000.

🔗

Guided Practice 1.2.1.

What is the grade of the first loan in Table 1.2.2? And what is the home ownership status of the borrower for that first loan? For these Guided Practice questions, you can check your answer in the footnote.

The loan’s grade is A, and the borrower rents their residence.

🔗

In practice, it is especially important to ask clarifying questions to ensure important aspects of the data are understood. For instance, it is always important to be sure we know what each variable means and the units of measurement. Descriptions of the loan50 variables are given in Table 1.2.3.

🔗

Table 1.2.2. Four rows from the loan50 data matrix.

🔗


	`loan_amount`	`interest_rate`	`term`	`grade`	`state`	`total_income`	`homeownership`
1	7500	7.34	36	A	MD	70000	rent
2	25000	9.43	60	B	OH	254000	mortgage
3	14500	6.08	36	A	MO	80000	mortgage
$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$
50	3000	7.96	36	A	CA	34000	rent

Table 1.2.3. Variables and their descriptions for the loan50 data set.

🔗


variable	description
`loan_amount`	Amount of the loan received, in US dollars.
`interest_rate`	Interest rate on the loan, in an annual percentage.
`term`	The length of the loan, which is always set as a whole number of months.
`grade`	Loan grade, which takes values A through G and represents the quality of the loan and its likelihood of being repaid.
`state`	US state where the borrower resides.
`total_income`	Borrower’s total income, including any second income, in US dollars.
`homeownership`	Indicates whether the person owns, owns but has a mortgage, or rents.

🔗

The data in Table 1.2.2 represent a data matrix, which is a convenient and common way to organize data, especially if collecting data in a spreadsheet. Each row of a data matrix corresponds to a unique case (observational unit), and each column corresponds to a variable.

🔗

When recording data, use a data matrix unless you have a very good reason to use a different structure. This structure allows new cases to be added as rows or new variables as new columns.

🔗

Guided Practice 1.2.4.

The grades for assignments, quizzes, and exams in a course are often recorded in a gradebook that takes the form of a data matrix. How might you organize grade data using a data matrix?

There are multiple strategies that can be followed. One common strategy is to have each student represented by a row, and then add a column for each assignment, quiz, or exam. Under this setup, it is easy to review a single line to understand a student’s grade history. There should also be columns to include student information, such as one column to list student names.

🔗

Guided Practice 1.2.5.

We consider data for 3,142 counties in the United States, which includes each county’s name, the state in which it is located, its population in 2017, how its population changed from 2010 to 2017, poverty rate, and six additional characteristics. How might these data be organized in a data matrix?

Each county may be viewed as a case, and there are eleven pieces of information recorded for each case. A table with 3,142 rows and 11 columns could hold these data, where each row represents a county and each column represents a particular piece of information.

🔗

The data described in Guided Practice 1.2.5 represents the county data set, which is shown as a data matrix in Table 1.2.6. These data come from the US Census, with much of the data coming from the US Census Bureau’s American Community Survey (ACS). Unlike the Decennial Census, which takes place every 10 years and attempts to collect basic demographic data from every residents of the US, the ACS is an ongoing survey that is sent to approximately 3.5 million households per year. As stated by the ACS website, these data help communities “plan for hospitals and schools, support school lunch programs, improve emergency services, build bridges, and inform businesses looking to add jobs and expand to new markets, and more.”

⁴

https://www.census.gov/programs-surveys/acs/about.html

A small subset of the variables from the ACS are summarized in Table 1.2.7.

🔗

Table 1.2.6. Eleven rows from the county data set.

🔗


	`name`	`state`	`pop`	`pop_change`	`poverty`	`homeownership`	`multi_unit`	`unemp_rate`	`metro`	`median_edu`	`median_hh_income`
1	Autauga	Alabama	55504	1.48	13.7	77.5	7.2	3.86	yes	some_college	55317
2	Baldwin	Alabama	212628	9.19	11.8	76.7	22.6	3.99	yes	some_college	52562
3	Barbour	Alabama	25270	-6.22	27.2	68.0	11.1	5.90	no	hs_diploma	33368
4	Bibb	Alabama	22668	0.73	15.2	82.9	6.6	4.39	yes	hs_diploma	43404
5	Blount	Alabama	58013	0.68	15.6	82.0	3.7	4.02	yes	hs_diploma	47412
6	Bullock	Alabama	10309	-2.28	28.5	76.9	9.9	4.93	no	hs_diploma	29655
7	Butler	Alabama	19825	-2.69	24.4	69.0	13.7	5.49	no	hs_diploma	36326
8	Calhoun	Alabama	114728	-1.51	18.6	70.7	14.3	4.93	yes	some_college	43686
9	Chambers	Alabama	33713	-1.20	18.8	71.4	8.7	4.08	no	hs_diploma	37342
10	Cherokee	Alabama	25857	-0.60	16.1	77.5	4.3	4.05	no	hs_diploma	40041
$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$
3142	Weston	Wyoming	6927	-2.93	14.4	77.9	6.5	3.98	no	some_college	59605

Table 1.2.7. Variables and their descriptions for the county data set.

🔗


variable	description
`name`	County name.
`state`	State where the county resides, or the District of Columbia.
`pop`	Population in 2017.
`pop_change`	Percent change in the population from 2010 to 2017. For example, the value `1.48` in the first row means the population for this county increased by 1.48% from 2010 to 2017.
`poverty`	Percent of the population in poverty.
`homeownership`	Percent of the population that lives in their own home or lives with the owner, e.g. children living with parents who own the home.
`multi_unit`	Percent of living units that are in multi-unit structures, e.g. apartments.
`unemp_rate`	Unemployment rate as a percent.
`metro`	Whether the county contains a metropolitan area.
`median_edu`	Median education level, which can take a value among `below_hs`, `hs_diploma`, `some_college`, and `bachelors`.
`median_hh_income`	Median household income for the county, where a household’s income equals the total income of its occupants who are 15 years or older.

🔗

Subsection 1.2.2 Types of variables

Examine the unemp_rate, pop, state, and median_edu variables in the county data set. Each of these variables is inherently different from the other three, yet some share certain characteristics.

🔗

First consider unemp_rate, which is said to be a numerical variable since it can take a wide range of numerical values, and it is sensible to add, subtract, or take averages with those values. On the other hand, we would not classify a variable reporting telephone area codes as numerical since the average, sum, and difference of area codes doesn’t have any clear meaning.

🔗

The pop variable is also numerical, although it seems to be a little different than unemp_rate. This variable of the population count can only take whole non-negative numbers (0, 1, 2, ...). For this reason, the population variable is said to be discrete since it can only take numerical values with jumps. On the other hand, the unemployment rate variable is said to be continuous.

🔗

The variable state can take up to 51 values after accounting for Washington, DC: AL, AK, ..., and WY. Because the responses themselves are categories, state is called a categorical variable, and the possible values are called the variable’s levels.

🔗

Finally, consider the median_edu variable, which describes the median education level of county residents and takes values below_hs, hs_diploma, some_college, or bachelors in each county. This variable seems to be a hybrid: it is a categorical variable but the levels have a natural ordering. A variable with these properties is called an ordinal variable, while a regular categorical variable without this type of special ordering is called a nominal variable. To simplify analyses, any ordinal variable in this book will be treated as a nominal (unordered) categorical variable.

🔗

Figure 1.2.8. Breakdown of variables into their respective types.
🔗

Example 1.2.9.

Data were collected about students in a statistics course. Three variables were recorded for each student: number of siblings, student height, and whether the student had previously taken a statistics course. Classify each of the variables as continuous numerical, discrete numerical, or categorical.

🔗

Solution.

The number of siblings and student height represent numerical variables. Because the number of siblings is a count, it is discrete. Height varies continuously, so it is a continuous numerical variable. The last variable classifies students into two categories — those who have and those who have not taken a statistics course — which makes this variable categorical.

🔗

Guided Practice 1.2.10.

An experiment is evaluating the effectiveness of a new drug in treating migraines. A group variable is used to indicate the experiment group for each patient: treatment or control. The num_migraines variable represents the number of migraines the patient experienced during a 3-month period. Classify each variable as either numerical or categorical.

⁵

The group variable can take just one of two group names, making it categorical. The num_migraines variable describes a count of the number of graines, which is an outcome where basic arithmetic is sensible, which means this is a numerical outcome; more specifically, since it represents a count, num_migraines is a discrete numerical variable.

🔗

Subsection 1.2.3 Relationships between variables

Many analyses are motivated by a researcher looking for a relationship between two or more variables. A social scientist may like to answer some of the following questions:

If homeownership is lower than the national average in one county, will the percent of multi-unit structures in that county tend to be above or below the national average?
🔗

🔗
Does a higher than average increase in county population tend to correspond to counties with higher or lower median household incomes?
🔗

🔗
How useful a predictor is median education level for the median household income for US counties?
🔗

🔗

🔗

To answer these questions, data must be collected, such as the county data set shown in Table 1.2.6. Examining summary statistics could provide insights for each of the three questions about counties. Additionally, graphs can be used to visually explore the data.

🔗

Scatterplots are one type of graph used to study the relationship between two numerical variables. Figure 1.2.11 compares the variables homeownership and multi_unit, which is the percent of units in multi-unit structures (e.g. apartments, condos). Each point on the plot represents a single county. For instance, the highlighted dot corresponds to County 413 in the county data set: Chattahoochee County, Georgia, which has 39.4% of units in multi-unit structures and a homeownership rate of 31.3%. The scatterplot suggests a relationship between the two variables: counties with a higher rate of multi-units tend to have lower homeownership rates. We might brainstorm as to why this relationship exists and investigate the ideas to determine which are the most reasonable explanations.

🔗

Figure 1.2.11. A scatterplot of homeownership versus the percent of units that are in multi-unit structures for US counties. The highlighted dot represents Chattahoochee County, Georgia, which has a multi-unit rate of 39.4% and a homeownership rate of 31.3%. Explore this scatterplot and dozens of other scatterplots using American Community Survey data on Tableau Public Click to see
⁶
`public.tableau.com/profile/openintro#!/vizhome/Chapter1_36/Youchoose`
🔗

The multi-unit and homeownership rates are said to be associated because the plot shows a discernible pattern. When two variables show some connection with one another, they are called associated variables. Associated variables can also be called dependent variables and vice-versa.

🔗

Guided Practice 1.2.12.

Examine the variables in the loan50 data set, which are described in Table 1.2.3. Create two questions about possible relationships between variables in loan50 that are of interest to you.

⁷

Two example questions: (1) What is the relationship between loan amount and total income? (2) If someone’s income is above the average, will their interest rate tend to be above or below the average?

🔗

Example 1.2.13.

This example examines the relationship between a county’s population change from 2010 to 2017 and median household income, which is visualized as a scatterplot in Figure 1.2.14. Are these variables associated?

🔗

Solution.

The larger the median household income for a county, the higher the population growth observed for the county. While this trend isn’t true for every county, the trend in the plot is evident. Since there is some relationship between the variables, they are associated.

🔗

Figure 1.2.14. A scatterplot showing `pop_change` against `median_hh_income`. Owsley County of Kentucky, is highlighted, which lost 3.63% of its population from 2010 to 2017 and had median household income of $22,736. Explore this scatterplot and dozens of other scatterplots using American Community Survey data on Tableau Public Click to see
⁸
`public.tableau.com/profile/openintro#!/vizhome/Chapter1_36/Youchoose`
.
🔗

Because there is a downward trend in Figure 1.2.11 — counties with more units in multi-unit structures are associated with lower homeownership — these variables are said to be negatively associated. A positive association is shown in the relationship between the median_hh_income and pop_change in Figure 1.2.14, where counties with higher median household income tend to have higher rates of population growth.

🔗

If two variables are not associated, then they are said to be independent. That is, two variables are independent if there is no evident relationship between the two.

🔗

Associated or independent, not both.

A pair of variables is either related in some way (associated) or not (independent). No pair of variables is both associated and independent.

🔗

Subsection 1.2.4 Section summary

Researchers often summarize data in a table, where the rows correspond to individuals or cases and the columns correspond to the variables, the values of which are recorded for each individual.
🔗

🔗
Variables can be numerical (measured on a numerical scale) or categorical (taking on levels, such as low/medium/high). Numerical variables can be continuous, where all values within a range are possible, or discrete, where only specific values, usually integer values, are possible.
🔗

🔗
When there exists a relationship between two variables, the variables are said to be associated or dependent. If the variables are not associated, they are said to be independent.
🔗

🔗

🔗

Exercises 1.2.5 Exercises

1. Air pollution and birth outcomes, study components.

Researchers collected data to examine the relationship between air pollutants and preterm births in Southern California. During the study air pollution levels were measured by air quality monitoring stations. Specifically, levels of carbon monoxide were recorded in parts per million, nitrogen dioxide and ozone in parts per hundred million, and coarse particulate matter

({PM}_{10})

μ g / m^{3} .

Length of gestation data were collected on 143,196 births between the years 1989 and 1993, and air pollution exposure during gestation was calculated for each birth. The analysis suggested that increased ambient PM

_{10}

and, to a lesser degree, CO concentrations may be associated with the occurrence of preterm births

⁹

B. Ritz et al. “Effect of air pollution on preterm birth among children born in Southern California between 1989 and 1993”.In: Epidemiology 11.5 (2000), pp. 502-511.

Identify the main research question of the study.
🔗

🔗
Who are the subjects in this study, and how many are included?
🔗

🔗
What are the variables in the study? Identify each variable as numerical or categorical. If numerical, state whether the variable is discrete or continuous. If categorical, state whether the variable is ordinal.
🔗

🔗

🔗

Solution.

“Is there an association between air pollution exposure and preterm births?”
🔗

🔗
143,196 births in Southern California between 1989 and 1993.
🔗

🔗
Measurements of carbon monoxide, nitrogen dioxide, ozone, and particulate matter less than $10 μ g / m^{3}$ (PM10) collected at air-quality-monitoring stations as well as length of gestation. Continuous numerical variables.
🔗

🔗

🔗

2. Buteyko method, study components.

The Buteyko method is a shallow breathing technique developed by Konstantin Buteyko, a Russian doctor, in 1952. Anecdotal evidence suggests that the Buteyko method can reduce asthma symptoms and improve quality of life. In a scientific study to determine the effectiveness of this method, researchers recruited 600 asthma patients aged 18-69 who relied on medication for asthma treatment. These patients were randomnly split into two research groups: one practiced the Buteyko method and the other did not. Patients were scored on quality of life, activity, asthma symptoms, and medication reduction on a scale from 0 to 10. On average, the participants in the Buteyko group experienced a significant reduction in asthma symptoms and an improvement in quality of life.

¹⁰

J. McGowan. “Health Education: Does the Buteyko Institute Method make a difference?” In: Thorax 58 (2003).

Identify the main research question of the study.
🔗

🔗
Who are the subjects in this study, and how many are included?
🔗

🔗
What are the variables in the study? Identify each variable as numerical or categorical. If numerical, state whether the variable is discrete or continuous. If categorical, state whether the variable is ordinal.
🔗

🔗

🔗

3. Cheaters, study components.

Researchers studying the relationship between honesty, age and self-control conducted an experiment on 160 children between the ages of 5 and 15. Participants reported their age, sex, and whether they were an only child or not. The researchers asked each child to toss a fair coin in private and to record the outcome (white or black) on a paper sheet, and said they would only reward children who report white.

¹¹

Alessandro Bucciol and Marco Piovesan. “Luck or cheating? A field experiment on honesty with children”. In: Journal of Economic Psychology 32.1 (2011), pp. 73-78.

Identify the main research question of the study.
🔗

🔗
Who are the subjects in this study, and how many are included?
🔗

🔗
The study’s findings can be summarized as follows: “Half the students were explicitly told not to cheat and the others were not given any explicit instructions. In the no instruction group probability of cheating was found to be uniform across groups based on child’s characteristics. In the group that was explicitly told to not cheat, girls were less likely to cheat, and while rate of cheating didn’t vary by age for boys, it decreased with age for girls.” How many variables were recorded for each subject in the study in order to conclude these findings? State the variables and their types.
🔗

🔗

🔗

Solution.

“Does explicitly telling children not to cheating affect their likelihood to cheat?”.
🔗

🔗
160 children between the ages of 5 and 15.
🔗

🔗
Four variables: (1) age (numerical, continuous), (2) sex (categorical), (3) whether they were an only child or not (categorical), (4) whether they cheated or not (categorical).
🔗

🔗

🔗

4. Stealers, study components.

In a study of the relationship between socio-economic class and unethical behavior, 129 University of California undergraduates at Berkeley were asked to identify themselves as having low or high social-class by comparing themselves to others with the most (least) money, most (least) education, and most (least) respected jobs. They were also presented with a jar of individually wrapped candies and informed that the candies were for children in a nearby laboratory, but that they could take some if they wanted. After completing some unrelated tasks, participants reported the number of candies they had taken.

¹²

P.K. Piff et al. “Higher social class predicts increased unethical behavior”. In: Proceedings of the National Academy of Sciences (2012).

Identify the main research question of the study.
🔗

🔗
Who are the subjects in this study, and how many are included?
🔗

🔗
The study found that students who were identified as upper-class took more candy than others. How many variables were recorded for each subject in the study in order to conclude these findings? State the variables and their types.
🔗

🔗

🔗

5. Migraine and acupuncture, Part 2.

Exercise 1.1.3.1 introduced a study exploring whether acupuncture had any effect on migraines. Researchers conducted a randomized controlled study where patients were randomly assigned to one of two groups: treatment or control. The patients in the treatment group received acupuncture that was specifically designed to treat migraines. The patients in the control group received placebo acupuncture (needle insertion at non-acupoint locations). 24 hours after patients received acupuncture, they were asked if they were pain free. What are the explanatory and response variables in this study?

🔗

Solution.

Explanatory: acupuncture or not. Response: if the patient was pain free or not.

🔗

6. Sinusitis and antibiotics, Part 2.

Exercise 1.1.3.2 introduced a study exploring the effect of antibiotic treatment for acute sinusitis. Study participants either received either a 10-day course of an antibiotic (treatment) or a placebo similar in appearance and taste (control). At the end of the 10-day period, patients were asked if they experienced improvement in symptoms. What are the explanatory and response variables in this study?

🔗

7. Fisher’s irises.

Sir Ronald Aylmer Fisher was an English statistician, evolutionary biologist, and geneticist who worked on a data set that contained sepal length and width, and petal length and width from three species of iris flowers (setosa, versicolor and virginica). There were 50 flowers from each species in the data set.

¹³

R.A Fisher.“The Use of Multiple Measurements in Taxonomic Problems”. In: Annals of Eugenics 7 (1936), pp. 179-188.

🔗

How many cases were included in the data?
🔗

🔗
How many numerical variables are included in the data? Indicate what they are, and if they are continuous or discrete.
🔗

🔗
How many categorical variables are included in the data, and what are they? List the corresponding levels (categories).
🔗

🔗

🔗

Figure 1.2.15. Photo by Ryan Claussen (http://flic.kr/p/6QTcuX
¹⁴
`flic.kr/p/6QTcuX`
) CC BY-SA 2.0 license
¹⁵
`CC BY-SA 2.0 license`
🔗

Solution.

$50 \times 3 = 150$
🔗

🔗
Four continuous numerical variables: sepal length, sepal width, petal length, and petal width.
🔗

🔗
One categorical variable, species, with three levels: setosa, versicolor, and virginica.
🔗

🔗

🔗

8. Smoking habits of UK residents.

A survey was conducted to study the smoking habits of UK residents. Below is a data matrix displaying a portion of the data collected in this survey. Note that “£” stands for British Pounds Sterling, “cig” stands for cigarettes, and “N/A” refers to a missing component of the data.

¹⁶

National STEM Centre,Large Datasets from stats4schools.

🔗


	sex	age	marital	grossIncome	smoke	amtWeekends	amtWeekdays
1	Female	42	Single	Under £2,600	Yes	12 cig/day	12 cig/day
2	Male	44	Single	£10,400 to £15,600	No	N/A	N/A
3	Male	53	Married	Above £36,400	Yes	6 cig/day	6 cig/day
$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$	$⋮$
1691	Male	40	Single	£2,600 to £5,200	Yes	8 cig/day	8 cig/day

What does each row of the data matrix represent?
🔗

🔗
How many participants were included in the survey?
🔗

🔗
Indicate whether each variable in the study is numerical or categorical. If numerical, identify as continuous or discrete. If categorical, indicate if the variable is ordinal.
🔗

🔗

🔗

9. US Airports.

The visualization below shows the geographical distribution of airports in the contiguous United States and Washington, DC. This visualization was constructed based on a dataset where each observation is an airport.

¹⁷

Federal Aviation Administration, www.faa.gov/airports/airport_safety/airportdata_5010

🔗

List the variables used in creating this visualization.
🔗

🔗
Indicate whether each variable in the study is numerical or categorical. If numerical, identify as continuous or discrete. If categorical, indicate if the variable is ordinal.
🔗

🔗

🔗

Solution.

Airport ownership status (public/private), airport usage status (public/private), latitude, and longitude.
🔗

🔗
Airport ownership status: categorical, not ordinal. Airport usage status: categorical, not ordinal. Latitude: numerical, continuous. Longitude: numerical, continuous.
🔗

🔗

🔗

10. UN Votes.

The visualization below shows voting patterns the United States, Canada, and Mexico in the United Nations General Assembly on a variety of issues. Specifically, for a given year between 1946 and 2015, it displays the percentage of roll calls in which the country voted yes for each issue. This visualization was constructed based on a dataset where each observation is a country/year pair.

¹⁸

David Robinson. unvotes: United Nations General Assembly Voting Data.R package version 0.2.0. 2017. url: https://CRAN.R-project.org/package=unvotes.

🔗

List the variables used in creating this visualization.
🔗

🔗
Indicate whether each variable in the study is numerical or categorical. If numerical, identify as continuous or discrete. If categorical, indicate if the variable is ordinal.
🔗

🔗

🔗

You have attempted 1 of 1 activities on this page.

🔗

Prev Top Next