← Back to course

Extracting Information from Data

You’ll be able to

From raw data to information

Data on its own is just recorded values; information is the knowledge we extract from it. Because modern data sets are enormous, we use programs to search for patterns, trends, and correlations — regularities that would be invisible to a person scanning rows by hand. Sorting, filtering, summarizing (counts, averages), and visualizing data as charts all help patterns emerge. The goal is to turn a pile of numbers into an insight a human can act on.

Metadata and clean data

Metadata is data about data — a photo’s timestamp and location, a file’s size and author, a song’s length. Metadata does not describe the content directly but makes data far easier to organize, search, and analyze. Before analysis, data usually must be cleaned: removing duplicates, fixing inconsistent formats (dates written three different ways), and handling missing or erroneous values. Filtering then narrows a large set to the relevant rows. Analysis on messy data yields misleading results — "garbage in, garbage out."

Correlation is not causation

A correlation means two variables tend to change together — as one rises, the other rises (or falls). It is tempting but wrong to assume one causes the other. Ice-cream sales and drowning deaths rise together, but neither causes the other; a third factor, hot weather, drives both. Finding a correlation is valuable — it points to relationships worth investigating — but establishing causation requires more, typically a controlled experiment. Confusing the two leads to false conclusions.

Worked example

An analyst finds that cities with more firefighters at a blaze also report more fire damage, and concludes that firefighters cause damage. Explain the error.

  1. 1.Identify the claim: more firefighters → more damage, stated as cause and effect.
  2. 2.The data shows only a correlation: the two numbers rise together across many fires.
  3. 3.Look for a hidden third variable: larger fires both draw more firefighters and cause more damage. The fire size drives both figures.
  4. 4.So the correlation is real, but the causal direction is wrong — firefighters respond to big fires, they do not cause the damage.
Answer: The analyst mistook correlation for causation. A confounding variable — the size of the fire — independently increases both the number of firefighters and the amount of damage, so the two are correlated without one causing the other.
Checkpoint

A study finds that students who own more books tend to score higher on reading tests. Which conclusion is best supported?

On the exam

A correlation in data never by itself proves causation. On the exam, the safe reading of "X and Y rise together" is that they are associated — a possible hidden variable or reversed direction must be ruled out before claiming cause.

Checkpoint

Which of the following is an example of metadata rather than the primary data itself?

Tip

Before trusting any analysis, ask whether the data was cleaned and whether a claimed cause might really be a correlation with a hidden variable. Both traps produce confident-sounding but wrong conclusions.

Answer the 2 checkpoints as you read.

Sign in to save your progress