Skip to main content
SheetTutor.
SheetTutorLearn Excel by playBack to task

Compare changes in the same matched records

Your goal: Preserve record alignment, summarize after-minus-before differences and reconcile a two-sided paired test with a change interval.

Full task requirements

Enter separate formulas in G2:G8. Each A-column identity binds its before value in B to its after value in C; retain those row pairs. D2 is two-sided alpha. Report pair count, mean after-minus-before change, standard error of those within-record differences, signed t for a zero mean change, two-sided paired p, and lower/upper t interval endpoints for the mean change. Trailing rows without an identity are unused. Do not treat the before/after columns as independent groups.

Same workpieces before and afterKeep each complete record together0 cells selected
A binds each before/after B/C pair. D2 is alpha. Keep original pairs; trailing unused rows do not add observations.Scroll the worksheet horizontally to inspect later source columns.
Click or drag source cells; selected cells change color Drag from selected cells to deselect.
#
1
2
3
4
5
6
7
Step 1 of 3

Keep each complete record together

Select the source cells in the worksheet, then enter your prediction below.

Rules for this step

Select each record identity and its before/after values. The identity binds the row pair; unused trailing rows are not additional pairs.

0 cells selected