Study data analysis for CISI Certificate in Investment Management, with the technical unit kept inside the wider two-unit certificate route.
This chapter tests whether you can use data intelligently rather than cosmetically. The paper is not looking for advanced quant pretence. It is looking for candidates who know what data are useful, what technical analysis can and cannot do, how central tendency and dispersion actually differ, how returns should be measured, and how attribution and risk-adjusted metrics improve investment judgement. The strongest answers choose the right metric for the job instead of admiring statistics for their own sake.
| Check | What matters |
|---|---|
| Official technical-topic weighting | 13% |
| Core distinction under pressure | separate data availability from data usefulness, and separate raw return numbers from properly contextualised performance interpretation |
| Strongest use of this page | use it after valuation and securities so the metrics connect back to real portfolios and instruments |
| UK note | keep sterling examples, FTSE-style benchmark language, and UK portfolio-review logic active throughout |
The paper usually tests whether you can interpret evidence rather than merely calculate it. Average values, dispersion, return measures, attribution, and risk-adjusted metrics all exist because investment managers need to make better decisions, compare performance fairly, and communicate clearly.
It also tests whether you can question the wrong metric. A number can be technically correct and still be the wrong tool for the investment question in front of you. Stronger answers often win by rejecting the tempting-but-wrong measure.
The data chapter is therefore a discipline chapter. It asks whether you can move from raw observations to a defensible investment conclusion without overstating precision. Good answers usually mention the source of the data, the relevant benchmark, the effect of cash flows, and the kind of risk being measured.
| Section | Main exam angle |
|---|---|
| Sources of Data and Data Types | If the issue is evidence quality, ask what source and data type actually fit the task |
| Big Data and Technical Analysis | If the question is about pattern detection or data scale, do not confuse richer data with guaranteed better judgement |
| Statistics: Central Tendency | If multiple averages appear, decide which one best represents the distribution and the problem |
| Statistics: Dispersion | If spread or variability is central, use the right dispersion lens |
| Measuring Returns | If the stem gives prices or portfolio values, ask whether nominal, real, total, or relative return is the real issue |
| Benchmarking and Attribution | If the question is about why a portfolio out- or underperformed, attribution and benchmark relevance matter |
| Risk-Adjusted Returns | If risk and return appear together, do not stop at the headline gain figure |
Data quality matters before any statistic is calculated. Market prices, company filings, benchmark data, analyst inputs, macro series, and alternative data each have strengths and weaknesses. The exam usually rewards candidates who question fit, timeliness, and reliability.
| Data source or type | Main value | Main caution |
|---|---|---|
| market prices | timely evidence of traded value | can be noisy, sentiment-driven, or illiquid |
| company filings | audited or formal issuer information | backward-looking and dependent on accounting policy |
| benchmark data | performance comparison and mandate control | useful only if the benchmark fits the mandate |
| macroeconomic data | context for rates, inflation, growth, and currencies | revisions and lags can affect interpretation |
| analyst or vendor data | convenient aggregation and estimates | methodology and conflicts should be considered |
| alternative or big data | broader evidence and possible early signals | may be unstructured, biased, or hard to validate |
Data can be quantitative or qualitative, structured or unstructured, time-series or cross-sectional. The exam often tests whether the candidate understands what a dataset can and cannot support. A large dataset does not automatically remove sampling bias, stale information, survivorship bias, or poor relevance.
Big data can widen the evidence base, but it does not remove the need for judgement. Technical analysis can identify patterns or sentiment clues, yet it should not be treated as guaranteed prediction. The stronger answer usually balances usefulness with caution.
Technical analysis uses price, volume, trend, support, resistance, moving averages, momentum, or chart patterns to infer market behaviour. It can be useful for timing, sentiment, and risk control, especially where market psychology matters. It is weaker when presented as proof of intrinsic value or guaranteed future return.
Big data and technical analysis share the same exam trap: pattern detection is not the same as causal explanation. A pattern can be real historically and still fail when market structure, liquidity, regulation, or participant behaviour changes.
Central tendency asks what “typical” looks like, but mean, median, and mode do not say the same thing. The right answer usually depends on the shape of the data and the question being asked.
| Measure | Best use | Weakness |
|---|---|---|
| Mean | balanced average when observations are reasonably stable | distorted by outliers |
| Median | middle observation, useful for skewed data | ignores the size of extreme values |
| Mode | most common observation | may be unhelpful for continuous investment returns |
If return data include one extreme gain or loss, the median may better represent the typical observation than the mean. If the question asks about total portfolio experience over a period, the mean may still be useful, but only after checking dispersion and compounding.
Dispersion matters because average return without spread can be misleading. Volatility, range, and related measures help show how stable or unstable results have been.
The core point is that two strategies can have the same average return and very different risk. Standard deviation captures spread around the mean. Range gives a simple highest-to-lowest view. Downside-focused measures may be more relevant when the client or mandate cares more about losses than upside variability.
Use dispersion measures as context, not as the whole answer. A high-volatility strategy may be acceptable for a long-horizon growth mandate and unsuitable for a short-horizon capital-preservation mandate.
Return measurement is one of the highest-value parts of the chapter. The candidate needs to know when nominal return is insufficient, when inflation matters, and when total return or benchmark-relative return is the real decision lens.
Core return formulas:
\[ \begin{aligned} \text{Total return} &= \frac{\text{Ending value} - \text{Beginning value} + \text{Income}}{\text{Beginning value}} \\ \text{Real return} &\approx \text{Nominal return} - \text{Inflation rate} \end{aligned} \]Money-weighted return reflects the timing and size of external cash flows. It is useful when assessing the investor’s actual experience because contributions and withdrawals affect the result. Time-weighted return strips out the effect of external cash-flow timing more effectively, so it is commonly preferred when assessing manager skill.
| Return measure | Best use | Exam caution |
|---|---|---|
| Nominal return | raw growth in money terms | ignores inflation |
| Real return | purchasing-power outcome | requires inflation adjustment |
| Total return | capital change plus income | income must not be ignored |
| Money-weighted return | investor experience with cash-flow timing | can reward or punish the manager for client cash-flow timing |
| Time-weighted return | manager performance over subperiods | may not match the client’s actual money outcome |
| Relative return | performance versus benchmark | benchmark must fit the mandate |
For multi-factor models, remember the purpose: explain return using several risk or style factors rather than a single market relationship. Factor models can improve attribution and risk understanding, but they depend on assumptions, data quality, factor definition, and regime stability.
Benchmarks matter only when they fit the mandate. Attribution matters because outperformance or underperformance is rarely useful unless the driver is understood.
A benchmark should match the investment universe, currency, risk profile, style, and constraints of the mandate. A UK equity income fund should not be judged casually against a global growth benchmark. If the benchmark is wrong, attribution will be misleading even if the calculation is tidy.
Attribution separates performance into causes. Asset allocation, sector selection, security selection, currency exposure, duration positioning, yield-curve positioning, fees, and transaction costs can all matter depending on the portfolio. The exam often rewards the candidate who identifies the source of performance rather than merely saying the portfolio outperformed.
Risk-adjusted thinking matters because high returns alone do not prove strong management. The paper typically tests whether the candidate can judge whether the return justified the risk and how that should be communicated.
High-yield risk-adjusted measures:
\[ \begin{aligned} \text{Sharpe ratio} &= \frac{R_p - R_f}{\sigma_p} \\ \text{Treynor ratio} &= \frac{R_p - R_f}{\beta_p} \\ \text{Jensen's alpha} &= R_p - \left(R_f + \beta_p(R_m - R_f)\right) \end{aligned} \]Sharpe uses total risk, so it is often more useful for a whole portfolio where unsystematic risk matters. Treynor uses beta, so it focuses on return per unit of systematic risk. Jensen’s alpha asks whether the portfolio exceeded the return implied by CAPM. Sterling, Calmar, and Omega-style measures bring additional attention to drawdown or downside profile, depending on how the measure is defined in the question.
| Measure | Risk lens | Better use |
|---|---|---|
| Sharpe ratio | total volatility | comparing diversified or total-portfolio outcomes |
| Treynor ratio | systematic risk | comparing portfolios where beta is the relevant risk unit |
| Jensen’s alpha | excess return versus CAPM expectation | asking whether performance beat model-implied return |
| Sterling or Calmar ratio | drawdown-sensitive performance | assessing strategies where large losses matter |
| Omega ratio | distribution and downside threshold | comparing non-normal return profiles when supplied |
Different measures may rank the same strategies differently. That is not an error; it means the measures are asking different risk questions. A strategy can look strong on total volatility and weaker on drawdown, or strong on beta-adjusted return and weaker on downside-tail behaviour.
Use this sequence before calculating:
flowchart TD
A["Data source and observation set"] --> B["Choose the right summary or return measure"]
B --> C["Compare to benchmark or objective"]
C --> D["Interpret attribution and risk-adjusted quality"]
D --> E["Use the result in portfolio judgement"]
A £500,000 portfolio rises to £540,000 over a year while inflation runs at 6%. Which statement is the strongest starting interpretation?
Answer: A.
The move from £500,000 to £540,000 is a positive nominal return, but inflation reduces the real purchasing-power improvement. Benchmark and risk conclusions need separate evidence.