ASTAM Excel Tutorial

ASTAM includes one Excel workbook question and five written-answer questions. The workbook is the graded surface for the Excel question; the written answer booklets are the graded surface for the other questions.

Treat Excel as a small actuarial modeling environment. The goal is not fancy spreadsheet design. The goal is visible formulas, clear labels, correct distribution functions, and enough structure that a grader can follow the model without guessing what each cell means.

ASTAM Excel work sits at the point where probability, statistics, and short-term insurance modeling meet. The workbook may need to calculate fitted probabilities, evaluate likelihoods, compute quantiles, build model-comparison cells, or support an answer that is written in the booklet.

That means the candidate needs two habits at once: use Excel efficiently, and still explain the actuarial model. A correct cell with no model interpretation is fragile; a good written explanation with an incorrect workbook is also fragile.

Use a predictable worksheet shape every time. Put inputs and parameters near the top, build the model table below, place check cells next to the table, and put the final answer or interpretation in a clearly labeled cell.

This layout makes the workbook easier to grade and easier to debug under time pressure. It also prevents the most common spreadsheet error: hiding the model inside disconnected numbers.

The hard part is usually not typing a function name. The hard part is matching the actuarial random variable to the software parameterization. Before you enter a formula, write what the random variable counts or measures.

Pay special attention to gamma, lognormal, and negative binomial models. Gamma functions require consistent scale or rate thinking. Lognormal functions use the normal parameters of the log of the variable. Negative binomial functions can count failures, successes, or claim counts depending on the convention in the model.

A Goal Seek setup should have three cells you can point to: the changing cell, the target cell, and the result cell. The changing cell holds the parameter. The target cell holds the equation you want to force to zero or to a stated value.

For a one-parameter likelihood fit, the target might be a score equation. For a tail or reserve calculation, the target might be a probability, quantile, reserve balance, or rate-level equation. Either way, the worksheet should make the target visible.

For the Excel question, assume the workbook must stand on its own. The grader should be able to see formulas, labels, assumptions, and the final result in the submitted file.

For the written questions, use Excel as a calculator if it helps, but put the answer, method, and interpretation in the answer booklet. The workbook is not a substitute for written-answer credit on those questions.

Use short drills before full released-exam review. The point is to make workbook mechanics automatic enough that the actual ASTAM problem can spend your attention on the actuarial model.

If the underlying probability or statistics is rusty, use ProbabilityPath and StatisticsPath for slower prerequisite review, then return to ActuaryPath for the short-term insurance version.