1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/surfingpikachu11
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#Excel compatibility
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#modern spreadsheet innovations
#self-service analytics tools
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#business intelligence tools
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications