below are the monthly data for Jul - Mar, data & are in real values and are not in percenatge difference. Problem is this i want to figure out the growth rate, either it could be postive growth or negative. i attempted to figure out the average growth rate in percenatge from jul - mar. I have taken the monthly percentage difference of the data and then subtracted it from 1, then i applied GEOmean formula. but can not be satsified by the answer. the answer i come through is -8%. Is this the right answer?. the formula i used to come to this answer is =GEOMEAN(K2:R2+1)-1. i took the percenatge difference then subtract1 from the answer then applied thet formula. Please anybody help me to solve this as i have importnt presentationn to make in which i have to show the growth rate % .
149.11
212.35
195.6
166.47
160.8
146.63
179.18
141.4
155.62
Bookmarks