# Google Sheets LOGINV Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/loginv-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 LOGINV function returns the inverse of the lognormal distribution for a specified probability, mean, and standard deviation. ``` LOGINV(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 LOGINV you need in plain EnglishGenerate Formula ## Parameters **`x`**: The probability value for which you want to calculate the logarithmic inverse. **`mean`**: The mean or expected value of the distribution. **`standard_deviation`**: The standard deviation of the distribution, which measures the dispersion of the data points around the mean. ## What is a LOGINV? The *LOGINV* 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 based on a given probability and the parameters of the lognormal distribution. The lognormal distribution is often used to model data that is positively skewed, such as income or stock prices. In simpler terms, LOGINV allows you to determine the value of a variable that corresponds to a specific probability in a lognormal distribution. ## A Practical Example Imagine you are analyzing the distribution of annual incomes in a certain region, and you want to find the income level that corresponds to a specific percentile. ### Income Data: | Percentile | Mean Income | Standard Deviation | | - | - | - | | 0.25 | 30000 | 5000 | | 0.50 | 50000 | 10000 | | 0.75 | 70000 | 15000 | You want to find the income level that corresponds to the 75th percentile. ## LOGINV Formula To achieve this, you would use the LOGINV function as follows: ``` =LOGINV(0.75, 50000, 10000) ``` In this formula: - `0.75` is the probability for which you want to find the corresponding income level. - `50000` is the mean of the lognormal distribution. - `10000` is the standard deviation of the lognormal distribution. ## Result of the Formula When you apply the LOGINV formula, the output would give you the income level that corresponds to the 75th percentile. For example, if the result is `70000`, it indicates that 75% of the population earns less than this amount. ## Why Use LOGINV? LOGINV is beneficial because it allows you to work with lognormally distributed data effectively. It provides a straightforward way to find values corresponding to specific probabilities, which is essential in fields such as finance, economics, and risk management. Additionally, it helps in making informed decisions based on statistical analysis. ## Key Takeaways: - **LOGINV**: A statistical function that calculates the inverse of the lognormal distribution. - **Application**: Useful for finding values corresponding to specific probabilities in positively skewed data. - **Statistical Analysis**: Aids in making informed decisions based on the distribution of data. - **Common Use Cases**: Ideal for income analysis, stock price modeling, and any scenario involving lognormally distributed data. LOGINV is an essential function for anyone working with statistical data in Google Sheets, providing a powerful way to enhance data analysis and reporting capabilities. Happy spreadsheeting! ## Example use case You have a table with sales data, where Column A contains sales amounts and Column B contains corresponding probabilities. Use the LOGINV formula to calculate the inverse of the log-normal distribution for a given probability, helping assess potential sales outcomes. ## 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 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) - [How To Insert Multiple Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-multiple-rows-in-google-sheets) - [How To Lock A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-a-row-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.