Excel-এ ডেটা নিয়ে কাজ

স্লাইড ১

Working With Data in Excel

স্লাইড ২

Three sessions of numbers, none of them yours

The risk difference, the hypertensive counts, the percentages: all printed, none typed. A mentorship plan that cannot insert a lab here is a syllabus, not a room.

স্লাইড ৩

What this session is not

It is not an Excel course. It is not a new paper. It is the earlier numbers, made rather than received, so the next session can talk about means and medians with a student who has already produced both.

স্লাইড ৪

Act I · A Sheet Is a Dataset, Not a Report

স্লাইড ৫

One row per person, one column per variable

Session 2’s rectangle becomes a sheet. If that rule is broken, every later formula is decorating a mess.

স্লাইড ৬

The header row is one row, and it is the top one

স্লাইড ৭

Codes, not labels

স্লাইড ৮

A blank is not a zero, and 999 is a disaster

Missingness is a decision that has to stay visible. Filling it with zero invents patients. Coding it as 999 invents giants. Both destroy a mean before anyone has chosen a test.

স্লাইড ৯

Five ways the same twenty patients were entered wrongly

The practice register is simulated and says so on the frame. The mistakes are not. They are the ones that quietly sit under a finished Table 1.

স্লাইড ১০

Khanam’s Table 1 is a report, not a dataset

A table is the answer to questions already asked. A dataset is what you ask the next question of. Confusing the two is how people try to ‘analyze’ a published table and think they have the study.

স্লাইড ১১

Act II · Addresses, Formulas, and the Denominator That Moved

স্লাইড ১২

Every cell has an address

স্লাইড ১৩

A formula starts with an equals sign

স্লাইড ১৪

A range is two addresses and a colon

স্লাইড ১৫

Drag it down and the addresses move with it

স্লাইড ১৬

The dollar sign holds one part of an address still

স্লাইড ১৭

Session 3’s error, now visible on screen

স্লাইড ১৮

Act III · Counting a Categorical Column

স্লাইড ১৯

COUNT counts numbers; COUNTA counts anything

স্লাইড ২০

COUNTIF asks a question of a column

স্লাইড ২১

A percentage is a count over a denominator you chose

Session 3’s sentence becomes a formula. The denominator is still a choice. Excel will not make it for you; it will only remember the choice you typed.

স্লাইড ২২

COUNTIFS makes a two-way table

স্লাইড ২৩

Row or column percentage: one reference apart

স্লাইড ২৪

The same table without typing a formula

স্লাইড ২৫

100.1 is not always an error

স্লাইড ২৬

Act IV · Summarizing a Numerical Column

স্লাইড ২৭

Four functions, one column

স্লাইড ২৮

Quartiles and percentiles

স্লাইড ২৯

The five-number summary, as one block

স্লাইড ৩০

77.0 centimetres, and where you have seen it

স্লাইড ৩১

When the mean and the median part company

স্লাইড ৩২

STDEV.S or STDEV.P

স্লাইড ৩৩

The card to keep beside the keyboard

A short list, not a software syllabus. COUNT, COUNTIF, the five-number summary, and the one rule about missing values. Session 4 then asks which of those numbers a paper should print.

স্লাইড ৩৪

What the next session does with all of this