GEOMEAN function not resulting in a geometric mean percentage
I have a spreadsheet with over 80 data cells that I need to find the geometric mean for. I can calculate it fine by hand but I need to be able to use excel. Whenever I press the equals geomean function and enter my data and close the parentheses, it spits out a dollar amount comparable in size to the two data points I entered into the function and not a percentage representing the growth or change between the two data points. If someone could provide either a working formula or point me towards a tutorial relevant to business data analytics thst would be great. Every tutorial I found online is dealing with applying GEOMEAN to established percentages and not showing any conversions that must be made to raw dollar amount data if any PRIOR to running the GEOMEAN function. The course material also has this issue and maybe thats the missing link.
[link] [comments]
Want to read more?
Check out the full article on the original site