University Dissertation Modelling question (Population, by age groups factoring in death rates)

[simned02]

This should be really simple. I have a birth rate, which become Juveniles (column b) for a year, then there is a death rate applied, and they move into been aged to 2 year, this repeats for 8 years, when they become 9 and then again when they become 10 (different death rates applied to nine year olds and 10 year olds). The idea is to see how the population grows.

My challenge is I can't get the calculation in my head, I feel it should be simple but I am getting myself into a tizz over it.

I have not been told, so I assume say a 10% dealth rate applies to the whole of the population in the age group.

any help or ideas would be greatly appreciated

 

[awoohaw]

Can you use the xl2bb add in (link below) in order to post a sample of your data and the rates you want to apply to each column? This will be a big help in helping the forum to help you. Please.

 

[simned02]

This should be really simple. I have a birth rate, which become Juveniles (column b) for a year, then there is a death rate applied, and they move into been aged to 2 year, this repeats for 8 years, when they become 9 and then again when they become 10 (different death rates applied to nine year olds and 10 year olds). The idea is to see how the population grows.

My challenge is I can't get the calculation in my head, I feel it should be simple but I am getting myself into a tizz over it.

I have not been told, so I assume say a 10% dealth rate applies to the whole of the population in the age group.

any help or ideas would be greatly appreciated

 

[simned02]

Wolf Model Mr Excel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC
1		Original Pack															Mortality															Dispersal									Territory Established									Births
2	Time Steps	Juv Fem (0-1)	Sub Fem (2-8)	Sub Fem (9)	Sub Fem (10+)	Dom Fem(2-8)	Dom Fem (9)	Dom Fem (10+)	Juv Male (0-1)	Sub Male (2-8)	Sub Male (9)	Sub Male (10+)	Dom male (2-8)	Dom Male (9)	Dom Male (10+)		Juv Fem (0-1)	Sub Fem (2-8)	Sub Fem (9)	Sub Fem (10+)	Dom Fem(2-8)	Dom Fem (9)	Dom Fem (10+)	Juv Male (0-1)	Sub Male (2-8)	Sub Male (9)	Sub Male (10+)	Dom male (2-8)	Dom Male (9)	Dom Male (10+)		Juv Fem (0-1)	Sub Fem (2-8)	Sub Fem (9)	Sub Fem (10+)	Juv Male (0-1)	Sub Male (2-8)	Sub Male (9)	Sub Male (10+)		Juv Fem (0-1)	Sub Fem (2-8)	Sub Fem (9)	Sub Fem (10+)	Juv Male (0-1)	Sub Male (2-8)	Sub Male (9)	Sub Male (10+)		Litter Size	Females	Males
3	1	1				1			1				1				1	0	0	0	0	0	0	1	0	0	0	1	0	0		1	0	0	0	0	0	0	0		1	0	0	0	0	0	0	0		5	2	3
4	2	2	0	0	0	0	0	0	4	0	0	0	1	0	0		2	0	0	0	0	0	0	4	0	0	0	1	0	0		1	0	0	0	1	0	0	0		0	0	0	0	1	0	0	0		0	0	0
5	3	1	0	0	0	0	0	0	3	0	0	0	1	0	0		1	0	0	0	0	0	0	3	0	0	0	0	0	0		1	0	0	0	2	0	0	0		1	0	0	0	2	0	0	0		0	0	0
6	4	0	0	0	0	0	0	0	1	0	0	0	0	0	0		0	0	0	0	0	0	0	1	0	0	0	0	0	0		0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0		0	0	0	Litter Size
7	5	0	0	0	0	0	0	0	1	0	0	0	0	0	0		0	0	0	0	0	0	0	1	0	0	0	0	0	0		0	0	0	0	1	0	0	0		0	0	0	0	0	0	0	0		0	0	0	5	73%	73%
8	6	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0		0	0	0	2	27%	100%
Wolves

Cell Formulas
Range	Formula
X3:Y3,Q3:R8,U3:U8,X4:X8,Y5:Y8,AB3:AB8	Q3	=BINOM.INV(B3,0.903, RAND())
S3:S8,V3:V8,Z3:Z8,AC3:AC8	S3	=BINOM.INV(D3,0.4, RAND())
T3:T8,W3:W8,AA3:AA8,AD3:AD8	T3	=BINOM.INV(E3,0.25, RAND())
Y4	Y4	=BINOM.INV(J3,0.903, RAND())
AF3:AI8	AF3	=BINOM.INV(Q3,0.35,RAND())
AJ3:AM8	AJ3	=BINOM.INV(X3,0.35,RAND())
AO3:AV8	AO3	=BINOM.INV(AF3,0.8,RAND())
AX3:AX8	AX3	=IF(AND(BI3>=1,BL3>=1),(INDEX(BA$7:BA$11,COUNTIF(BC$7:BC$11,"<="&RAND())+1)),0)
AY3:AY8	AY3	=BINOM.INV(AX3,0.5,RAND())
AZ3:AZ8	AZ3	=AX3-AY3
B4:B8	B4	=SUM(Q3-AF3)+AY3
C4:E8	C4	=SUM(R3-AG3)
F4:H8,M4:O8	F4	=U3
I4:I8	I4	=SUM(X3-AJ3)+AZ3
J4:L8	J4	=SUM(Y3-AK3)
BC7:BC8	BC7	=SUM(BB$7:BB7)

 

[simned02]

Can you use the xl2bb add in (link below) in order to post a sample of your data and the rates you want to apply to each column? This will be a big help in helping the forum to help you. Please.

Thanks, and sorry this all new to me.

 

[awoohaw]

Thanks, and sorry this all new to me.

Its okay, welcome to the forum. You've given us what we need now and someone, if not me will post a solution.

 

[awoohaw]

I am not a statistician. I do not have statistical knowledge of how to apply the functions you are using.
I hope others can provide some insight.