# Google Sheets LOGNORM.INV Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/lognorm.inv-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 LOGNORM.INV function returns the inverse of the lognormal distribution for a specified probability, mean, and standard deviation. ``` LOGNORM.INV(x, mean, standard_deviation) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the LOGNORM.INV you need in plain EnglishGenerate Formula ## Parameters **`x`**: The value for which you want to find the inverse of the lognormal distribution. **`mean`**: The mean of the natural logarithm of the distribution. **`standard_deviation`**: The standard deviation of the natural logarithm of the distribution. ## What is LOGNORM.INV? The *LOGNORM.INV* function in Google Sheets is a statistical function used to calculate the inverse of the lognormal distribution. This function is particularly useful in scenarios where you need to find a value that corresponds to a given probability in a lognormally distributed dataset. The lognormal distribution is often used in fields such as finance, environmental studies, and reliability engineering, where the data is positively skewed. In simpler terms, LOGNORM.INV allows you to determine the value of a variable that has a lognormal distribution based on a specified probability. ## A Practical Example Imagine you are analyzing the distribution of incomes in a certain region, and you want to find out what income level corresponds to a specific percentile. ### Income Distribution Table: | Percentile | Probability | | - | - | | 10% | 0.10 | | 50% | 0.50 | | 90% | 0.90 | Assume the mean (mu) of the natural logarithm of the income is 10, and the standard deviation (sigma) is 0.5. ## LOGNORM.INV Formula To find the income level corresponding to the 90th percentile, you would use the LOGNORM.INV function as follows: ``` =LOGNORM.INV(0.90, 10, 0.5) ``` In this formula: - `0.90` is the probability for which you want to find the corresponding income level. - `10` is the mean (mu) of the natural logarithm of the income. - `0.5` is the standard deviation (sigma) of the natural logarithm of the income. ## Result of the Formula When you apply the LOGNORM.INV formula, it will return the income level that corresponds to the 90th percentile. For example, if the result is approximately 22000, it means that 90% of the population earns less than $22,000. ### Income Distribution Table with Results: | Percentile | Probability | Income Level | | - | - | - | | 10% | 0.10 | 12,000 | | 50% | 0.50 | 20,000 | | 90% | 0.90 | 22,000 | ## Why Use LOGNORM.INV? LOGNORM.INV is beneficial because it allows analysts and researchers to work with lognormally distributed data effectively. It provides a straightforward way to determine thresholds or cutoffs based on probabilities, which is essential for making informed decisions in various fields. Additionally, it helps in understanding the distribution of data, especially when dealing with skewed datasets. ## Key Takeaways: - **LOGNORM.INV**: A statistical function that calculates the inverse of the lognormal distribution. - **Use Cases**: Ideal for analyzing income distributions, environmental data, and any scenario where lognormal distribution is applicable. - **Understanding Data**: Helps in determining income levels or other thresholds based on specified probabilities, enhancing data analysis capabilities. LOGNORM.INV is an essential function for anyone working with statistical data in Google Sheets, providing a powerful tool for analyzing and interpreting lognormally distributed datasets. Happy spreadsheeting! ## Example use case You have a table with sales data where Column A contains sales amounts and Column B contains corresponding probabilities. You can use LOGNORM.INV to determine the sales amount at a specific probability, helping to forecast revenue and set targets effectively. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Enable Macros In Google Sheets](https://betteranalyst.com/google-sheets/how-to-enable-macros-in-google-sheets) - [How To Filter In Google Sheets](https://betteranalyst.com/google-sheets/how-to-filter-in-google-sheets) - [How To Find Circular References In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-circular-references-in-google-sheets) - [How To Find Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-duplicates-in-google-sheets) - [How To Freeze A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-a-row-in-google-sheets) - [How To Freeze Panes In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-panes-in-google-sheets) - [How To Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets 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.