Fieldwork Data Lab · Pattern & Anomaly
Enquiry: Which representation makes the fieldwork pattern clearest without distorting it?
Learning objective: I can check and present fieldwork data in a suitable graph, then interpret pattern, anomaly and reliability.
Vocabulary: cell · formula · mean · axis · unit · scale · scatter graph · correlation · anomaly
Lesson 4 of 6 evidence pack · Raw data to graph
| Site | Distance | Count 1 | Count 2 | Count 3 | Mean | EQS (−8 to +8) | Green /5 | Noise /5 |
|---|---|---|---|---|---|---|---|---|
| Transit Gate | 0 m | 58 | 63 | 61 | 60.7 | -5 | 1 | 5 |
| Market Link | 120 m | 49 | 46 | 50 | 48.3 | -3 | 1 | 4 |
| Civic Crossing | 240 m | 38 | 42 | 40 | 40.0 | 0 | 2 | 3 |
| Riverside Walk | 360 m | 26 | 29 | 27 | 27.3 | 4 | 4 | 2 |
| Park Edge | 480 m | 18 | 17 | 19 | 18.0 | 6 | 5 | 1 |
| Housing Green | 600 m | 13 | 12 | 11 | 12.0 | 5 | 4 | 2 |
Formula cue: mean = sum of the three equal counts ÷ 3. Spreadsheet equivalent: =AVERAGE(C2:E2).
Graph-choice prompt: categories → bar; ordered change → line; relationship between two numerical variables → scatter. Association does not prove cause.