Arte SheetsLearn. Try. Understand.

Clinical Medicine & Physiology

A Body Shape Index (ABSI): Spreadsheet Formula and Reference Scores

Calculate the ABSI waist–BMI–height index and illustrate standardization using explicitly hypothetical reference values.

What ABSI represents

Krakauer and Krakauer (2012) defined ABSI as waist circumference in metres divided by BMI raised to 2/3 and height in metres raised to 1/2. Their analysis included 14,105 non-pregnant adults in the US NHANES 1999–2004 sample. ABSI describes waist relative to height and weight; it does not directly measure visceral fat, muscle mass or a diagnosis.

The study found an association between ABSI and mortality in that population. Its reported 33% change in relative hazard per standard deviation was a population model estimate, not an individual forecast; the study included uncertainty and the relationship was not uniform in every subgroup. An ABSI value alone cannot establish anyone’s risk of death.

Calculate unscaled ABSI

Enter height in centimetres in B2, weight in kilograms in B3 and waist circumference in centimetres in B4. Enter this formula in B7; it converts lengths to metres and keeps the raw ABSI. Limits on inputs are exercise guards, not validated physiological ranges.

=IF(COUNT(B2:B4)<>3,"Enter numeric height, weight and waist",IF(OR(B2<120,B2>230,B3<30,B3>300,B4<45,B4>200),"Check example inputs",(B4/100)/((B3/(B2/100)^2)^(2/3)*SQRT(B2/100))))

Display ABSI multiplied by 1,000

This optional display scaling changes the number, not the underlying index. Reference means and standard deviations must use the same scale as the value being standardized.

=IF(ISNUMBER(B7),ROUND(1000*B7,4),B7)

Illustrate a reference z-score

To demonstrate standardization, B5 and B6 contain a hypothetical mean of 0.0808 and standard deviation of 0.0042 in the unscaled units. They are made-up teaching values, not an age- and sex-specific NHANES reference for any person. The result therefore has no clinical or mortality-risk interpretation. A real z-score requires appropriate, documented reference data for the intended population.

=IF(COUNT(B5:B6)<>2,"Enter numeric reference mean and SD",IF(OR(B5<=0,B6<=0),"Check reference values",IF(ISNUMBER(B7),ROUND((B7-B5)/B6,2),B7)))

Try the example

Use the original values or change them to test your understanding.

Further reading