• OT: Excess deaths stats - sanity check

    From Sylvia Else@21:1/5 to All on Wed Feb 14 16:57:30 2024
    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant agency.
    If you scroll down to "Age specific rates, 2023, 2022, Baseline", and
    look at the three right hand columns.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater than
    the baseline average?

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    This seems to happen not just for both sexes, but for each sex individually.

    Sylvia.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Sylvia Else@21:1/5 to Anthony William Sloman on Wed Feb 14 19:10:25 2024
    On 14-Feb-24 6:57 pm, Anthony William Sloman wrote:
    On Wednesday, February 14, 2024 at 4:57:38 PM UTC+11, Sylvia Else wrote:
    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant agency.
    If you scroll down to "Age specific rates, 2023, 2022, Baseline", and
    look at the three right hand columns.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater than
    the baseline average?

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    It's simple enough. The Covid-19 epidemic killed off quite a few vulnerable people, and the survivors represent samples from the more robust elements of the population.

    Years ago it was claimed that males who survived past 80 in good health and women who survived past 85 in good health were predominantly drawn from that more robust population.

    It's a statistician's play ground. In practical terms you can't work out precisely what population you belong to - you might just be a lucky snowflake.

    An Australian male has an average life expectancy of 81.2 years, so at 81 and a couple of months I might be expected to drop dead soon. As an Australian male of 81, I've actually
    got a life expectancy of 8.44 more years. In reality, as an 81-year-old Australian male who never smoked and managed to get a Ph.D. I'm a member of an even longer-lived cohort, but they don't split the life expectation table finely enough that I can
    quote a number.

    This seems to happen not just for both sexes, but for each sex individually.

    Both sexes have been selected in much the same way.

    --
    Bill Sloman, Sydney


    I'm only concerned here about the relationship between the numbers,
    which I cannot make any sense of.

    Sylvia.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From legg@21:1/5 to All on Wed Feb 14 08:06:12 2024
    On Wed, 14 Feb 2024 16:57:30 +1100, Sylvia Else <sylvia@email.invalid>
    wrote:

    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant agency.
    If you scroll down to "Age specific rates, 2023, 2022, Baseline", and
    look at the three right hand columns.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater than
    the baseline average?

    Age specific rates, 2023, 2022, Baseline

    I read all rates higher than baseline except in 85+.
    . . . . including all-age.

    Monthly rates also higher all months but one.

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    This seems to happen not just for both sexes, but for each sex individually.

    Sylvia.

    ?

    RL

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Brown@21:1/5 to Sylvia Else on Wed Feb 14 14:41:32 2024
    On 14/02/2024 05:57, Sylvia Else wrote:
    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant agency.
    If you scroll down to "Age specific rates, 2023, 2022, Baseline", and
    look at the three right hand columns.

    I see what you mean. It doesn't seem to make any sense.

    All the numbers for Jan-Sept 2023 are below long term average (because a proportion of those who would naturally have died in 2023 were killed permaturely by Covid). The column total is above the long term average.

    You are right - this data makes no sense at all.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater than
    the baseline average?

    It can't even with really weird population ratings.

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    This seems to happen not just for both sexes, but for each sex
    individually.

    Sylvia.

    I'll hazard a guess that some of the numbers presented there are summed
    over a different period so that the larger numbers are not correct.

    Spreadsheets allow people to make very creative mistakes!

    --
    Martin Brown

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Sylvia Else@21:1/5 to Martin Brown on Thu Feb 15 16:22:27 2024
    On 15-Feb-24 1:41 am, Martin Brown wrote:
    On 14/02/2024 05:57, Sylvia Else wrote:
    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant
    agency. If you scroll down to "Age specific rates, 2023, 2022,
    Baseline", and look at the three right hand columns.

    I see what you mean. It doesn't seem to make any sense.

    All the numbers for Jan-Sept 2023 are below long term average (because a proportion of those who would naturally have died in 2023 were killed permaturely by Covid). The column total is above the long term average.

    You are right - this data makes no sense at all.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater
    than the baseline average?

    It can't even with really weird population ratings.

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    This seems to happen not just for both sexes, but for each sex
    individually.

    Sylvia.

    I'll hazard a guess that some of the numbers presented there are summed
    over a different period so that the larger numbers are not correct.

    Spreadsheets allow people to make very creative mistakes!


    Thanks.

    There's a update due in a couple of weeks. I'll wait to see whether that suffers the same issue, and contact them if so. Otherwise I'll just
    assume it was a one-off error.

    Sylvia.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Cursitor Doom@21:1/5 to All on Fri Feb 16 17:40:47 2024
    On Thu, 15 Feb 2024 16:22:27 +1100, Sylvia Else <sylvia@email.invalid>
    wrote:

    On 15-Feb-24 1:41 am, Martin Brown wrote:
    On 14/02/2024 05:57, Sylvia Else wrote:
    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant
    agency. If you scroll down to "Age specific rates, 2023, 2022,
    Baseline", and look at the three right hand columns.

    I see what you mean. It doesn't seem to make any sense.

    All the numbers for Jan-Sept 2023 are below long term average (because a
    proportion of those who would naturally have died in 2023 were killed
    permaturely by Covid). The column total is above the long term average.

    You are right - this data makes no sense at all.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater
    than the baseline average?

    It can't even with really weird population ratings.

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    This seems to happen not just for both sexes, but for each sex
    individually.

    Sylvia.

    I'll hazard a guess that some of the numbers presented there are summed
    over a different period so that the larger numbers are not correct.

    Spreadsheets allow people to make very creative mistakes!


    Thanks.

    There's a update due in a couple of weeks. I'll wait to see whether that >suffers the same issue, and contact them if so. Otherwise I'll just
    assume it was a one-off error.

    Sylvia.

    Worried about the Covid jabs you had then, Sylvia?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From legg@21:1/5 to legg on Sat Feb 17 09:22:00 2024
    On Wed, 14 Feb 2024 08:06:12 -0500, legg <legg@nospam.magma.ca> wrote:

    On Wed, 14 Feb 2024 16:57:30 +1100, Sylvia Else <sylvia@email.invalid>
    wrote:

    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant agency.
    If you scroll down to "Age specific rates, 2023, 2022, Baseline", and
    look at the three right hand columns.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater than
    the baseline average?

    Age specific rates, 2023, 2022, Baseline

    I read all rates higher than baseline except in 85+.
    . . . . including all-age.

    Monthly rates also higher all months but one.

    Sorry - was reading 'all deaths' chart, not age grouped table.

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    This seems to happen not just for both sexes, but for each sex individually. >>
    Sylvia.


    It looks like the anomaly in the report is resticted to 'persons'
    and 'males'. It is not repeated in 'female' figures.

    Neither parts of the table reflect trends in the charts.

    RL

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Sylvia Else@21:1/5 to Cursitor Doom on Sun Feb 18 10:55:54 2024
    On 17-Feb-24 4:40 am, Cursitor Doom wrote:
    On Thu, 15 Feb 2024 16:22:27 +1100, Sylvia Else <sylvia@email.invalid>
    wrote:

    On 15-Feb-24 1:41 am, Martin Brown wrote:
    On 14/02/2024 05:57, Sylvia Else wrote:
    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant
    agency. If you scroll down to "Age specific rates, 2023, 2022,
    Baseline", and look at the three right hand columns.

    I see what you mean. It doesn't seem to make any sense.

    All the numbers for Jan-Sept 2023 are below long term average (because a >>> proportion of those who would naturally have died in 2023 were killed
    permaturely by Covid). The column total is above the long term average.

    You are right - this data makes no sense at all.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater
    than the baseline average?

    It can't even with really weird population ratings.

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    This seems to happen not just for both sexes, but for each sex
    individually.

    Sylvia.

    I'll hazard a guess that some of the numbers presented there are summed
    over a different period so that the larger numbers are not correct.

    Spreadsheets allow people to make very creative mistakes!


    Thanks.

    There's a update due in a couple of weeks. I'll wait to see whether that
    suffers the same issue, and contact them if so. Otherwise I'll just
    assume it was a one-off error.

    Sylvia.

    Worried about the Covid jabs you had then, Sylvia?

    My sole interest in this thread relates to having the correct data to
    allow conclusions to be drawn. The data in question seem to be
    internally inconsistent, which is to say, cannot be correct regardless
    of the underlying facts.

    Sylvia.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Sylvia Else@21:1/5 to Sylvia Else on Tue Feb 20 11:53:36 2024
    On 14-Feb-24 4:57 pm, Sylvia Else wrote:
    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant agency.
    If you scroll down to "Age specific rates, 2023, 2022, Baseline", and
    look at the three right hand columns.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater than
    the baseline average?

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    This seems to happen not just for both sexes, but for each sex
    individually.

    Sylvia.

    I should just add that I thought I'd try to prove this impossible using algebra, and failed totally.

    So then I used Excel, and was able to construct a counter example. So my intuition about this was wrong. Of particular significance appears to be
    that the population numbers for the base line age groups will not
    generally be the same as the population numbers for the current data age groups.

    Oh well. Thanks to those who looked at this.

    Sylvia.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jasen Betts@21:1/5 to Sylvia Else on Fri Mar 8 20:07:42 2024
    On 2024-02-20, Sylvia Else <sylvia@email.invalid> wrote:
    On 14-Feb-24 4:57 pm, Sylvia Else wrote:
    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant agency.
    If you scroll down to "Age specific rates, 2023, 2022, Baseline", and
    look at the three right hand columns.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater than
    the baseline average?

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    This seems to happen not just for both sexes, but for each sex
    individually.

    Sylvia.

    I should just add that I thought I'd try to prove this impossible using algebra, and failed totally.

    So then I used Excel, and was able to construct a counter example. So my intuition about this was wrong. Of particular significance appears to be
    that the population numbers for the base line age groups will not
    generally be the same as the population numbers for the current data age groups.

    Oh well. Thanks to those who looked at this.

    Sylvia.

    It should be possible to get the numbers that went into this report
    under "freedom of information".

    --
    Jasen.
    🇺🇦 Слава Україні

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bill Sloman@21:1/5 to Jasen Betts on Sat Mar 9 15:17:21 2024
    On 9/03/2024 7:07 am, Jasen Betts wrote:
    On 2024-02-20, Sylvia Else <sylvia@email.invalid> wrote:
    On 14-Feb-24 4:57 pm, Sylvia Else wrote:
    <https://www.abs.gov.au/statistics/health/causes-death/provisional-mortality-statistics/latest-release>

    I just need a sanity check before I raise this with the relevant agency. >>> If you scroll down to "Age specific rates, 2023, 2022, Baseline", and
    look at the three right hand columns.

    How can the 2023 figures for each age group be less than the
    corresponding baseline average, but the all-ages number be greater than
    the baseline average?

    If any 2023 age group were above the baseline average, then all-ages
    number could go either way, because of different total populations in
    each age group, but with all age groups being below the baseline
    average, I just don't see it.

    This seems to happen not just for both sexes, but for each sex
    individually.

    Sylvia.

    I should just add that I thought I'd try to prove this impossible using
    algebra, and failed totally.

    So then I used Excel, and was able to construct a counter example. So my
    intuition about this was wrong. Of particular significance appears to be
    that the population numbers for the base line age groups will not
    generally be the same as the population numbers for the current data age
    groups.

    Oh well. Thanks to those who looked at this.

    Sylvia.

    It should be possible to get the numbers that went into this report
    under "freedom of information".

    Perhaps. But Australian civil servants can be remarkably obstructive.
    They don't like informed criticism, and work hard to frustrate it.

    --
    Bill Sloman, Sydney

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)