← Development / Multilateral Sector
publisheddata

Data analysis & statistics

Turn census, household-survey, ward-level or programme data into a finding that can survive a policy or development review. This skill gives a B.Plan graduate the reasoning layer behind defensible analysis: decide what the data can support, classify variables, clean and summarise them, compare groups, chart findings, account for sampling and uncertainty, and interpret association or regression without claiming causation. It is tool-agnostic and complements Statistical tool (R), which teaches how to execute an analysis in R.

What you will be able to answer

A development-programme team gives you a household survey from two pilot districts and asks whether a sanitation intervention improved school attendance. What can you produce before the review meeting?

A short analytical note that first identifies the unit of observation, sampling frame, missing groups and variable types, then cleans and documents the table before calculating anything. It reports attendance and programme exposure with suitable summaries, cross-tabs and an honest chart; places intervals around sample estimates; and distinguishes a statistically detectable difference from a practically important one. Any correlation or regression result is stated in units and as an association, with plausible confounders such as household income and district selection named explicitly. Unless the study design supports causal inference, the note does not claim that the programme raised attendance.

Concepts
11
Selected clips
29m 49s
Employers use it
8

One payment

₹99

The videos are free

This is what you pay for

Compared → kept
32 → 11
Full videos → selected
1h 31m → 29m 49s
Concepts
11

Course outline

Learn from selected clips, concept by concept

Concept 1

What a dataset can and cannot tell you

free

Concept 1 · What a dataset can and cannot tell you

0:00 / 0:28

Concept 2

Types of variable, and why the type decides everything

locked

After: what-the-data-can-answer

Nominal, ordinal and interval/ratio, and how the type rules out summaries and charts before you pick one.

Selected range
▮▮:▮▮ → ▮▮:▮▮
Clip retained
3m 07s kept
Video review
3 compared

Video title and channel appear once unlocked.

Concept 3

Getting a messy dataset into shape

locked

After: variables-and-measurement

Messy phone numbers standardised with regex replacement, and the data-type problem underneath them.

Selected range
▮▮:▮▮ → ▮▮:▮▮
Clip retained
3m 48s kept
Video review
3 compared

Video title and channel appear once unlocked.

Concept 4

Describing one variable honestly

locked

After: variables-and-measurement

Standard deviation and the 68-95-99.7 rule worked on real adult height data.

Selected range
▮▮:▮▮ → ▮▮:▮▮
Clip retained
1m 04s kept
Video review
3 compared

Video title and channel appear once unlocked.

Concept 5

Comparing groups with cross-tabs

locked

After: describing-a-distribution

Row percentages and column percentages off the same table, answering two different questions.

Selected range
▮▮:▮▮ → ▮▮:▮▮
Clip retained
3m 38s kept
Video review
3 compared

Video title and channel appear once unlocked.

Concept 6

Charting so the finding survives the slide

locked

After: comparing-groups

A line chart used on categorical data, and the false trend it invents.

Selected range
▮▮:▮▮ → ▮▮:▮▮
Clip retained
1m 10s kept
Video review
3 compared

Video title and channel appear once unlocked.

Concept 7

Samples, populations and who got left out

locked

After: describing-a-distribution

Simple random against stratified, and how non-response quietly biases the result.

Selected range
▮▮:▮▮ → ▮▮:▮▮
Clip retained
3m 18s kept
Video review
2 compared

Video title and channel appear once unlocked.

Concept 8

Putting error bars on an estimate

locked

After: sampling

A 95% confidence interval interpreted correctly, with the common misreading stated and refuted.

Selected range
▮▮:▮▮ → ▮▮:▮▮
Clip retained
2m 12s kept
Video review
3 compared

Video title and channel appear once unlocked.

Concept 9

Testing a claim, and what a p-value is not

locked

After: uncertainty-and-intervals

A two-tailed test worked through on recovery times, from null hypothesis to p-value.

Selected range
▮▮:▮▮ → ▮▮:▮▮
Clip retained
2m 08s kept
Video review
3 compared

Video title and channel appear once unlocked.

Concept 10

Correlation, and the sentence you must not write

locked

After: charting-a-finding

A confounder worked in full — age driving both shoe size and reading ability.

Selected range
▮▮:▮▮ → ▮▮:▮▮
Clip retained
1m 07s kept
Video review
3 compared

Video title and channel appear once unlocked.

Concept 11

Regression, and reading a coefficient out loud

locked

After: correlation, hypothesis-testing

A multiple regression equation read out loud, coefficient by coefficient.

Selected range
▮▮:▮▮ → ▮▮:▮▮
Clip retained
4m 42s kept
Video review
3 compared

Video title and channel appear once unlocked.

What was rejected

11 candidates did not meet the course criteria.

  • Focuses mainly on calculating basic statistical metrics rather than exploring dataset limitations or research design.
  • Lists the types as vocabulary to memorise with no consequence attached
  • Is a pure Excel-formula tutorial (TRIM/VLOOKUP tips) with no dataset reasoning
  • Demonstrates the Excel PivotTable interface only, with no discussion of what the comparison means; or presents raw counts across unequal group sizes without normalising
  • Is a software feature tour (how to click through Excel/Power BI/Tableau chart menus) with no judgment about which chart is right
  • lists sampling designs as exam definitions with no discussion of bias
  • Is z-table / t-table formula drilling for an exam with no interpretation
  • Is z-table / t-table formula drilling for an exam with no interpretation
  • The video does not explain p-value or what p-value is not, postponing p-value to the next video.
  • Mentions causation only in a brief throwaway line at the end without working through a confounder example.
  • Does not explain the strength or direction of association or how to read values off a scatter plot.

Where this skill is used

Development / Multilateral Sector

Planner-economist roles at multilaterals and development organisations (UN-Habitat, World Bank, ADB, GIZ, WRI, C40) working on urban policy, climate and infrastructure programs, in India or abroad. Rare for a fresh B.Plan directly — usually a master's + experience; freshers enter via internships and research-associate roles at India offices.

8 mapped employers

Explore path →