# Google Sheets LOGNORM.DIST Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/lognorm.dist-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.DIST function calculates the log-normal distribution for a given value, mean, and standard deviation, useful for modeling skewed data. ``` LOGNORM.DIST(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.DIST you need in plain EnglishGenerate Formula ## Parameters **`x`**: The value at which to evaluate the distribution. **`mean`**: The mean or average of the distribution. **`standard_deviation`**: The standard deviation of the distribution. ## What is LOGNORM.DIST? The *LOGNORM.DIST* function in Google Sheets is a statistical function used to calculate the lognormal distribution of a specified value. A lognormal distribution is a probability distribution of a random variable whose logarithm is normally distributed. This function is particularly useful in fields such as finance, economics, and environmental studies, where it can model phenomena that are positively skewed. In simpler terms, LOGNORM.DIST allows you to determine the probability of a variable that follows a lognormal distribution, given a specific value, mean, and standard deviation. ## A Practical Example Imagine you are analyzing the distribution of incomes in a certain region, and you want to find the probability that a randomly selected individual has an income less than a certain amount. ### Income Distribution Table: | Income | Probability | | - | - | | 30,000 | ? | | 50,000 | ? | | 70,000 | ? | You want to calculate the probability of an individual earning less than $50,000, assuming the income follows a lognormal distribution with a mean of 10 and a standard deviation of 0.5. ## LOGNORM.DIST Formula To achieve this, you would use the LOGNORM.DIST function as follows: ``` =LOGNORM.DIST(50000, 10, 0.5, TRUE) ``` In this formula: - `50000` is the value for which you want to calculate the probability. - `10` is the mean of the natural logarithm of the distribution. - `0.5` is the standard deviation of the natural logarithm of the distribution. - `TRUE` indicates that you want the cumulative distribution function (CDF), which gives the probability that a random variable is less than or equal to the specified value. ## Result of the Formula When you apply the LOGNORM.DIST formula, it will return a probability value that represents the likelihood of an individual earning less than $50,000 based on the specified lognormal distribution parameters. ### Example Output: | Income | Probability | | - | - | | 30,000 | 0.1587 | | 50,000 | 0.5000 | | 70,000 | 0.8413 | In this case, the probability of an individual earning less than $50,000 is approximately 0.5000, or 50%. ## Why Use LOGNORM.DIST? LOGNORM.DIST is beneficial because it provides a way to model and analyze data that is positively skewed, which is common in real-world scenarios such as income distribution, stock prices, and other financial metrics. It allows for a more accurate representation of data that cannot be adequately described by a normal distribution. ## Key Takeaways: - **LOGNORM.DIST**: A statistical function that calculates the lognormal distribution for a specified value. - **Cumulative Probability**: Can return the cumulative probability, indicating the likelihood of a random variable being less than or equal to a specified value. - **Real-World Applications**: Useful in finance, economics, and any field where data is positively skewed. - **Data Analysis**: Enhances the ability to analyze and interpret data distributions effectively. LOGNORM.DIST is an essential function for anyone working with statistical data in Google Sheets, providing a powerful tool for understanding and modeling lognormally distributed variables. 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.DIST to calculate the probability of a given sales amount occurring, aiding in forecasting and decision-making. ## 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 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) - [How To Insert Multiple Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-multiple-rows-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.