Your starting point
Prerequisites: Use the ideas and vocabulary from lesson 7; revisit its worked examples if needed.
Definition: Sorting changes record order according to one or more fields. Filtering selects records that meet a condition. Neither operation by itself changes the meaning of the source population or proves that selected records are representative.
Move complete records together
Sorting only one column independently can detach values from the people or events they describe. Sort the whole table by a chosen field. Check a recognizable record afterward to ensure its attributes stayed together. Numeric order also differs from text order: as text, 100 can appear before 20 because characters are compared rather than quantities.
Make the filter explicit
A filter is part of the analysis definition. “Revenue in the North region” is not the same claim as “revenue for the business.” State whether comparisons use all records or a subset. The workbench applies view filters to charts and summaries, while cleaning changes the full working table. This distinction prevents a hidden filter from being mistaken for a transformation of the source.
Inspect what disappears
A missing value may not satisfy a numerical condition. Filtering for positive durations can remove unknown durations as well as legitimate zero values. Record the original and selected row counts and ask whether excluded records differ systematically. A useful focused view can still introduce selection bias when generalized beyond the selected group. Reset filters before answering a new question.
Two worked examples
Numeric sorting
A column contains 2, 10 and 100 as numeric quantities. Ascending numerical order is 2, 10, 100. Text ordering may place 10 and 100 before 2. In the inspector, confirm the intended type before concluding that a sorted table shows the smallest or largest measurements.
A selected subset
A fictional table has twelve orders, of which five are from North. A filter selects those five without deleting the other seven. If their revenue totals 400, describe it as revenue among the five selected North orders. Do not label 400 as the full business total or infer that North represents all customers.
Where this becomes useful
A service manager reviews urgent tickets with long response times. The filtered view is useful for investigation, but its average should not be presented as the average for every ticket handled by the service.
Make an attempt
Use Table Explorer with Customer support. Sort minutes numerically, then filter priority to Urgent. Record both row counts and inspect missing durations. Clear the filter and explain why the summary changes without any underlying record being edited.
Misconception check
Claim: A filtered chart still describes the entire dataset.
Inspect the correction
It describes the selected records. Include the filter condition and count when communicating its scope.
Independent application
Build a focused view of a synthetic dataset using a stated condition. Compare one summary before and after filtering. Preserve the original table and write two accurately scoped findings that do not confuse the selected subset with the whole.
Completion records practice and self-review. It is not certification of statistical competence.
