# Excel GEOMEAN Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/excel/geomean-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The GEOMEAN function calculates the geometric mean of a range of numbers, providing an accurate average for multiplicative datasets. ```excel =GEOMEAN(number1, [number2], ...) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the GEOMEAN you need in plain EnglishGenerate Formula Need more than a single GEOMEAN formula? Try our free [AI for Excel](https://betteranalyst.com/excel-ai) — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat. ## Parameters **`number1`**:\ The first number or range of numbers for which you want to calculate the geometric mean. This argument is required. **`number2`**:\ An optional additional number or range of numbers to include in the geometric mean calculation. You can include up to 254 additional numbers or ranges. ## What is a GEOMEAN Formula in Excel? The *GEOMEAN* function in Excel is a statistical tool that calculates the geometric mean of a set of positive numbers. Unlike the arithmetic mean, which sums the values and divides by the count, the geometric mean multiplies the values together and then takes the nth root (where n is the count of values). This function is particularly useful in situations where you want to find the average rate of return over time or when dealing with percentages. In simpler terms, the GEOMEAN function helps you understand the central tendency of a set of numbers that are multiplicative in nature, making it easier to analyze growth rates or ratios. ## A Practical Example Imagine you are analyzing the annual growth rates of a small investment portfolio over five years, and you have the following data in an Excel spreadsheet: ### Growth Rates Table: | Year | Growth Rate (%) | | - | - | | 1 | 10 | | 2 | 20 | | 3 | -10 | | 4 | 15 | | 5 | 5 | You want to find the average growth rate over these five years. ## GEOMEAN Formula To calculate the average growth rate, you would use the GEOMEAN formula as follows: ```excel =GEOMEAN(1 + B2:B6) - 1 ``` ### Breakdown of the Formula: - **1 + B2:B6**: This adjusts the growth rates to a multiplicative format (e.g., 10% becomes 1.10). - **GEOMEAN(...)**: This calculates the geometric mean of the adjusted growth rates. - **- 1**: This subtracts 1 to convert the result back to a percentage format. ## Result of the Formula When you apply the formula, it calculates the average growth rate over the five years. The output would be: | Average Growth Rate (%) | | - | | 7.70 | Here, the average growth rate is calculated based on the geometric mean of the adjusted growth rates. ## Why Use GEOMEAN? The GEOMEAN function is particularly useful when dealing with rates of return, percentages, or any data that is multiplicative in nature. It provides a more accurate measure of central tendency for such data compared to the arithmetic mean, especially when the values vary significantly. ## Key Takeaways: - **GEOMEAN**: Calculates the geometric mean of a set of positive numbers. - **Accurate Representation**: Provides a better average for multiplicative data compared to the arithmetic mean. - **Common Use Cases**: Ideal for financial analysis, growth rates, and any scenario where you need to average ratios or percentages. Understanding how to use the GEOMEAN function can significantly enhance your data analysis capabilities in Excel, enabling you to extract meaningful insights from your datasets. Happy calculating! ## Example use case You have a table where Column A contains the names of different investment options and Column B contains their corresponding annual returns expressed as percentages. You can use the GEOMEAN function to calculate the average annual return of these investments over a specified period. This allows for a better understanding of the overall performance of the investment portfolio, helping investors make informed decisions about where to allocate their funds without the complications of calculating compounded returns manually. **Beyond the GEOMEAN function:** Better Analyst is a full [Excel AI](https://betteranalyst.com/excel-ai) that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free [AI Excel assistant](https://betteranalyst.com/excel-ai) that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required. Don't have a spreadsheet yet? Use our free [AI spreadsheet generator](https://betteranalyst.com/ai-excel-spreadsheet-generator) to turn a text prompt into a downloadable Excel file — a full [AI Excel sheet maker](https://betteranalyst.com/ai-excel-spreadsheet-generator) that builds headers, columns, and formulas from your description. ## Need more help with Excel formulas? Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Excel how-to guides - [How To Make A Copy Of An Excel Sheet](https://betteranalyst.com/excel/how-to-make-a-copy-of-an-excel-sheet) - [How To Make A Graph In Excel](https://betteranalyst.com/excel/how-to-make-a-graph-in-excel) - [How To Make A Histogram In Excel](https://betteranalyst.com/excel/how-to-make-a-histogram-in-excel) - [How To Make A Line Graph In Excel](https://betteranalyst.com/excel/how-to-make-a-line-graph-in-excel) - [How To Make A Pie Chart In Excel](https://betteranalyst.com/excel/how-to-make-a-pie-chart-in-excel) - [How To Make A Table In Excel](https://betteranalyst.com/excel/how-to-make-a-table-in-excel) - [How To Merge Cells In Excel](https://betteranalyst.com/excel/how-to-merge-cells-in-excel) - [How To Multiply In Excel](https://betteranalyst.com/excel/how-to-multiply-in-excel) ## Explore all Excel formulas Browse our complete library of Excel formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.