1/8
Looks like no tags are added yet.
Average life span
=AVERAGE(dataset)
Male life span
=if(datapoint=”m”,lifespan,““)
Average Lifespan of Male <1950
=AVERAGEIFS(lifespan,sex,”m”,deathyear,“<1950“)
Dx
=COUNTIF(dataset,”>=”&O4)-COUNTIF(dataset,”>=”&O5)
Nx
nx-1 - dx-1
lx
nx/total
qx
dx/nx
%dx
dx/total * 100
Neg % male deaths for graph
%dx * -1