Results 1 to 1 of 1

Thread: Population and vaccination coverage

  1. #1
    Jun 2014
    United Kingdom

    Population and vaccination coverage

    I am new to this forum, so I am not sure I am in the right place to start a thread. please advice if this is not the case.
    I need to determine the number of people vaccinated per year based on the population number by age group and the coverage rate.

    I use a spreadsheet to try to determine the equation (enclosed), but I failed to go beyond 4 years and I cannot find the pattern to go beyond.
    If I use the following naming convention:
    PopY1(1 to8) the number of children aged 1 to 8 years and C1 the percentage coverage year1
    I get the following
    Year1 number vaccinated=Pop1(1to8) x C1
    Year2 number vaccinated=Pop2(1to8) x C2 - Pop1(1to7) x C1 x C2
    Year3 number vaccinated =Pop3(1to8) x C3 - Pop2(1to7) x C2 x C3 - Pop3(1to6) x (C1 -C1*C2)x C3
    Year4 number vaccinated= Pop4(1to8) x C4 - Pop3(1to7) x C3 x C4 - Pop2(1to6) x (C2 -C2*C3)x C4 - Pop1(1to5) x (C1*C2*C3-C1*C3-C1*C2+C1) x C4

    I would need to find what the equation is for each year for 10 years?
    And then I would need to extrapolate for any age groups (1 to 5, 10 to 56,etc)
    Do you think you could help or point me in the right direction.
    I thank you in advance.
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Health insurance coverage
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: Jun 30th 2010, 05:49 AM
  2. NP-hardness of submodular maximum coverage
    Posted in the Discrete Math Forum
    Replies: 0
    Last Post: Apr 30th 2010, 11:01 AM
  3. MEDEVAC coverage
    Posted in the Calculus Forum
    Replies: 4
    Last Post: Jul 23rd 2009, 09:15 AM
  4. Orbit coverage...
    Posted in the Trigonometry Forum
    Replies: 1
    Last Post: Feb 3rd 2009, 06:28 PM
  5. Plot of coverage
    Posted in the Differential Geometry Forum
    Replies: 1
    Last Post: Sep 3rd 2008, 02:56 AM

Search Tags

/mathhelpforum @mathhelpforum