Arte SheetsLearn. Try. Understand.

Statistical & Clinical Analysis

P-POSSUM Surgical Audit Research and a Fictional Logistic Formula

Understand the context of the Portsmouth POSSUM surgical audit model and practice a separate fictional logistic calculation.

The Portsmouth surgical audit study

Prytherch and colleagues investigated a modified POSSUM mortality equation using 10,000 general surgical interventions. Their study evaluated agreement with observed in-hospital mortality and its use in comparative surgical audit. The model draws on physiological and operative findings; it is not inherently a 30-day mortality calculation.

The published P-POSSUM logit is −9.065 + 0.1692 × physiological score + 0.1550 × operative severity score. Correct scoring requires the individual factors and definitions, and performance depends on the study population and calibration. The equation and an isolated number do not decide where an individual patient should recover.

A different, invented logistic example

The workbook formula uses fictional coefficients and two arbitrary numbers X and Y. It is not P-POSSUM and does not estimate surgical mortality. Enter each value between 0 and 100. For X = 20 and Y = 10, the invented transform is 0.1978.

Missing, text and out-of-range values are rejected. This calculation is solely an example of using EXP and ROUND in a spreadsheet.

Fictional XFictional YInvented output
20100.1978
000.0474
50300.8022
=IF(COUNT(B2:B3)<>2,"Enter both numeric values",IF(OR(B2<0,B2>100,B3<0,B3>100),"Enter values from 0 to 100",ROUND(1/(1+EXP(-(-3+0.04*B2+0.08*B3))),4)))

Apply the research carefully

Read the original study for its cohort, variables and outcome. This worksheet cannot diagnose a patient, predict an individual outcome or prescribe surgical or postoperative care.

Try the example

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

Further reading