Growth rate

%3CLINGO-SUB%20id%3D%22lingo-sub-1487676%22%20slang%3D%22en-US%22%3EGrowth%20rate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487676%22%20slang%3D%22en-US%22%3E%3CP%3EHopefully%20a%20simple%20query.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20population%20numbers%20for%20a%20village%20at%20two%20census%20dates%3A%26nbsp%3B%3C%2FP%3E%3CP%3E1971%26nbsp%3B%20%26nbsp%3B3028%20people%3C%2FP%3E%3CP%3E1981%26nbsp%3B%204271%20people%3C%2FP%3E%3CP%3EI'd%20like%20to%20calculate%20the%20exponential%20growth%20rate%20and%20fill%20in%20the%20missing%20population%20numbers%20for%201972-1980.%3C%2FP%3E%3CP%3Emany%20thanks%2C%20Liam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1487676%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1487696%22%20slang%3D%22en-US%22%3ERe%3A%20Growth%20rate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487696%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F709510%22%20target%3D%22_blank%22%3E%40lkennedy19%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EI%20have%20a%20feeling%20I'm%20missing%20something%20here.%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20document.%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20what%20I%20did...%3C%2FP%3E%3CP%3E1981-1971%20%3D%2010%20(years)%3C%2FP%3E%3CP%3E4271-3028%20%3D%201243%20(the%20change%20in%2010%20years)%3C%2FP%3E%3CP%3E1243%2F10%20%3D%20124.3%20(increase%20per%20year)%3C%2FP%3E%3CP%3EAdd%20it%20up%20year%20over%20year!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20I%20missed%20the%20shot%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBen%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1487972%22%20slang%3D%22en-US%22%3ERe%3A%20Growth%20rate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F709510%22%20target%3D%22_blank%22%3E%40lkennedy19%3C%2FA%3E%26nbsp%3BSince%20you%20ask%20for%20%22exponential%20growth%22%2C%20use%20the%20GROWTH%20function.%20See%20attached%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hopefully a simple query. 

I have population numbers for a village at two census dates: 

1971   3028 people

1981  4271 people

I'd like to calculate the exponential growth rate and fill in the missing population numbers for 1972-1980.

many thanks, Liam

2 Replies

Hi @lkennedy19,

I have a feeling I'm missing something here. 

See attached document. 

Here's what I did...

1981-1971 = 10 (years)

4271-3028 = 1243 (the change in 10 years)

1243/10 = 124.3 (increase per year)

Add it up year over year!

 

Let me know if I missed the shot here.

 

Ben

 

@lkennedy19 Since you ask for "exponential growth", use the GROWTH function. See attached example.