Question

Using the below teacher salary data, determine the average annual percentage increase from '69-'70 to '14-'15 for:

a. each state

b. the Northeast Region (all 9 states combined)

The geometric mean should be used in solving this problem.  

State	Average Annual Salary of Teachers
	1969-70	1979-80	1989-90	1999-2000	2009-10	2013-14	2014-15
1	2	3	4	5	6	7	8
Northeast Region
Connecticut ...............	9,262	16,229	40,461	51,780	64,350	70,583	71,709
Maine .....................	7,572	13,071	26,881	35,561	46,106	49,232	50,017
Massachusetts ..............	8,764	17,253	34,712	46,580	69,273	73,195	74,805
New Hampshire ..................	7,771	13,017	28,986	37,734	51,443	57,057	58,554
New Jersey .................	9,130	17,161	35,676	52,015	65,130	68,238	69,038
New York ................	10,336	19,812	38,925	51,020	71,633	76,409	77,628
Pennsylvania ...............	8,858	16,515	33,338	48,321	59,156	63,701	64,717
Rhode Island ..............	8,776	18,002	36,057	47,041	59,686	64,696	65,918
Vermont ....................	7,968	12,484	29,012	37,758	49,084	55,958	57,642

Answer 1

State	Average Annual Salary of Teachers
	1969-70	1979-80	1989-90	1999-2000	2009-10	2013-14	2014-15
1	2	3	4	5	6	7	8
Northeast Region
Connecticut ...............	9,262	16,229	40,461	51,780	64,350	70,583	71,709
Maine .....................	7,572	13,071	26,881	35,561	46,106	49,232	50,017
Massachusetts ..............	8,764	17,253	34,712	46,580	69,273	73,195	74,805
New Hampshire ..................	7,771	13,017	28,986	37,734	51,443	57,057	58,554
New Jersey .................	9,130	17,161	35,676	52,015	65,130	68,238	69,038
New York ................	10,336	19,812	38,925	51,020	71,633	76,409	77,628
Pennsylvania ...............	8,858	16,515	33,338	48,321	59,156	63,701	64,717
Rhode Island ..............	8,776	18,002	36,057	47,041	59,686	64,696	65,918
Vermont ....................	7,968	12,484	29,012	37,758	49,084	55,958	57,642
	8,715	15,949	33,783	45,312	59,540	64,341	65,559

% annual increase						geometric mean
1.752213	2.49313	1.279751	1.242758	1.096861	1.015953	1.406516
1.726228	2.056537	1.322905	1.296533	1.0678	1.015945	1.369781
1.968622	2.01194	1.341899	1.487183	1.056617	1.021996	1.429568
1.675074	2.22678	1.301801	1.363306	1.10913	1.026237	1.400167
1.879628	2.0789	1.457983	1.252139	1.04772	1.011724	1.400994
1.916796	1.964718	1.310726	1.404018	1.066673	1.015954	1.399408
1.864416	2.01865	1.449427	1.22423	1.076831	1.01595	1.392987
2.051276	2.002944	1.304629	1.268808	1.083939	1.018888	1.39943
1.566767	2.323935	1.301461	1.299963	1.140046	1.030094	1.390694
1.830055	2.118152	1.341268	1.313997	1.080633	1.018925	1.399776

a)

answer is in last column of second table

b)

1.399776