Akaike information criterion: what it means and how to read it

In the report: AIC — −2 Log Likelihood plus a penalty of 2 for every coefficient.

How to read it

For choosing between models of the same Y on the same rows: the lower AIC, the better the balance of fit and simplicity; a difference under about 2 is negligible, the value itself means nothing. Compare only converged models without lambda: with ridge or without convergence AIC is not the usual criterion.

In plain words

A teacher had two ways to guess who passes. The first used only study hours, the second used study hours and shoe size. She wanted to know whether shoe size was worth keeping. She counted AIC and got 62.8 for the first way and 64.5 for the second. Lower is better, so the first way wins, and a gap under 2 is tiny anyway. Now she can say shoe size brings nothing and the simpler way is enough. The number itself means nothing; only the gap between two ways does, and only on the same students with lambda at 0.

How it is computed

AIC = −2LL + 2k

Example

The cell with AIC is selected in each report; point at a label to see its note.

  • — the sample data (50 rows) the examples use
  • — two steps; pass is coded 0 and 1 =STATS_LOGISTIC(Data!A1:T51, "pass", "x1,x2|x", 0, 50, 1e-8)

Where you see it

Get it in your sheet

One formula in a cell gives the whole report, Akaike information criterion included. ALS Stats is a free add-on for Google Sheets™.

Install ALS Stats from Google Workspace Marketplace (opens in a new tab)