Relate table values, algebra and graphs to the same mathematical features.
Key skillsRelate table values, algebra and graphs to the same mathematical features.
Build the idea
A statistical tool needs the explanatory and response columns in the correct order. Calculate the fitted coefficients, correlation and residuals, then inspect plots rather than relying on one summary number. Retain original data beside outputs so an individual row can be checked by hand. A documented workflow makes the numerical and graphical conclusions independently reproducible.
Try the sample task
Put x=1,2,3,4,5 in A2:A6 and y=2,4,5,4,5 in B2:B6. Use SLOPE(B2:B6,A2:A6), INTERCEPT(B2:B6,A2:A6), CORREL(A2:A6,B2:B6) and RSQ(B2:B6,A2:A6), or equivalent calculator functions. State expected outputs.
The full worksheet includes the worked solution and remaining task set.
What this activity covers
This focused activity develops the stated idea through one context. It is practice, not evidence that every application or subclause of a broad study-design bullet has been mastered. The official statement is published for Units 3 and 4 together; this activity uses one applicable context rather than inventing separate official unit lists.
Related topic collections
- Distributions, standardisation and normal models
- Association, correlation and causal claims
- Regression, residuals and transformations
- Time series, smoothing and seasonality
- Depreciation, compound interest and rates
- Loans, annuities and perpetuities
- Regular savings and investment targets
- Matrices, communication and dominance
- Transition, Leslie and population models
- Network traversal and shortest paths
- Minimum connectors and maximum flow
- Assignment and critical-path scheduling