Table of Contents
To plot a Log-Normal Distribution in Excel, follow these steps:
1. Enter your data into a new Excel spreadsheet, with one column containing the values and another column containing the corresponding frequencies.
2. Select the entire data set and click on the “Insert” tab in the menu bar.
3. In the Charts section, click on the “Insert Scatter (X, Y) or Bubble Chart” option.
4. A scatter plot chart will be generated. Right-click on any of the data points and select “Add Trendline” from the drop-down menu.
5. In the Format Trendline window, select the “Logarithmic” option under the “Trendline Options” tab.
6. Click on the “Display Equation on chart” and “Display R-squared value on chart” options to show the equation and R-squared value on the graph.
7. Click “Close” to exit the Format Trendline window.
8. Your scatter plot will now show a curved trendline representing the Log-Normal Distribution.
9. To customize the chart, you can change the axis labels, add a title, and adjust the formatting as desired.
By following these steps, you can easily plot a Log-Normal Distribution in Excel for your data set. This allows for visually representing the distribution and analyzing its characteristics in a clear and organized manner.
Plot a Log-Normal Distribution in Excel
This step-by-step tutorial explains how to plot the following log-normal distribution in Excel:
Step 1: Define the X Values
First, let’s define a range of x-values to use for our plot.
Step 2: Calculate the Y Values
The y values on the plot will represent the PDF values associated with the log-normal distribution.
We can type the following formula into cell B2 to calculate the PDF value of the log-normal distribution associated with an x value of 0.01, a mean value of 1, and a standard deviation of 1:
=LOGNORM.DIST(A2, $E$1, $E$2, FALSE)
We can then copy and paste this formula down to every remaining cell in column B:
Step 3: Plot the Log-Normal Distribution
Next, highlight the cell range A2:B22, then click the Insert tab along the top ribbon, then click the Scatter option within the Charts group and click Scatter with Smooth Lines:
The following chart will be created:
The x-axis shows the values of a that follows a log-normal distribution with a mean value of 1 and a standard deviation of 1 and the y-axis shows the corresponding PDF values of the log-normal distribution.
Step 4: Modify the Appearance of the Plot
Feel free to add a title, axis labels, and remove the gridlines to make the plot more aesthetically pleasing:
Additional Resources
The following tutorials explain how to plot other common distributions in Excel:
Cite this article
stats writer (2024). “How can I plot a Log-Normal Distribution in Excel?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-plot-a-log-normal-distribution-in-excel/
stats writer. "“How can I plot a Log-Normal Distribution in Excel?”." PSYCHOLOGICAL SCALES, 28 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-plot-a-log-normal-distribution-in-excel/.
stats writer. "“How can I plot a Log-Normal Distribution in Excel?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-plot-a-log-normal-distribution-in-excel/.
stats writer (2024) '“How can I plot a Log-Normal Distribution in Excel?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-plot-a-log-normal-distribution-in-excel/.
[1] stats writer, "“How can I plot a Log-Normal Distribution in Excel?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. “How can I plot a Log-Normal Distribution in Excel?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.