Chain base method for bivariate grouped data calculator

SolutionHelp

_Item\^Year	2011	2012	2013	2014	2015
Wheat	40	46	50	56	64
Bajri	20	30	36	42	54
Chana	50	64	80	96	112

_Item\^Year	2007	2008	2009	2010
Murder	110	128	134	129
Rape	30	45	40	48
Robbery	610	720	770	830
Theft	2450	2630	2910	2890

Example

1. Find index number using Fixed base method by taking base year 2011
_Item\^Year 2011 2012 2013 2014 2015
Wheat 40 46 50 56 64
Bajri 20 30 36 42 54
Chana 50 64 80 96 112

Solution:
Fixed base method :
Fixed base index number

$I=("Value of variable in current year (period)")/("Value of variable in base year (period)") xx 100$

Base year = 2011

_Item\^Year	2011	2012	2013	2014	2015
Wheat	$(40)/(40)xx100=100$	$(46)/(40)xx100=115$	$(50)/(40)xx100=125$	$(56)/(40)xx100=140$	$(64)/(40)xx100=160$
Bajri	$(20)/(20)xx100=100$	$(30)/(20)xx100=150$	$(36)/(20)xx100=180$	$(42)/(20)xx100=210$	$(54)/(20)xx100=270$
Chana	$(50)/(50)xx100=100$	$(64)/(50)xx100=128$	$(80)/(50)xx100=160$	$(96)/(50)xx100=192$	$(112)/(50)xx100=224$
Total	300	393	465	542	654
General index number $=("Total")/3$	$300/3=100$	$393/3=131$	$465/3=155$	$542/3=180.67$	$654/3=218$