excel how to use to make a lognormal distribution of the probability density distribution curve chart
Verify the lognormal distribution of the elements of the event, generally can be carried out with the help of the lognormal distribution of the probability of paper, if the probability of the probability of density curve plotted on the probability of paper for the linear, then the event that is a lognormal distribution. Here is what I bring you about excel with making a probability density distribution curve chart for lognormal distribution, I hope it will help you.
excel with the production of lognormal distribution of probability density distribution curve chart
1, the first thing to do is to plot the normal distribution scale.
Open 2013 version of excel, according to their needs to enter a series of cumulative distribution values. In the “X-axis grid value” in the second cell of the column insert the formula “NORM. S.INV”. In the pop-up window of the “probability” at the beginning of the series of cumulative distribution of the value of the selection of certainty, space, fill handle pull-down, that is, to get the value of the normal scale.
2, to the second cell of the three columns enter 0, fill handle fill. To “X-axis grid value” as the horizontal coordinates, to fill the third column of 0 as the vertical coordinates, to do the scatter plot. Scatterplot made the following Figure 1, at this time the normal scale to display in the X-axis, the next to adjust the format of the axes.
3, select the horizontal coordinate axis, right-click and select “Set Axis Format”, in the right window, “Maximum” “Minimum” were filled in. “3.7194695” “-3.7194695”. Select “Axis Value” for “Vertical Axis Crossing” and enter the value “-3.7194695” to indicate that the vertical and horizontal coordinates cross at the point (-3.7194695, 0). 3.7194695, 0). Adjusted coordinates as shown
4, the next thing to do is to display the cumulative distribution value in the horizontal coordinate.
Select the horizontal coordinate axis, delete. Select the point on the horizontal axis, right-click, and select “Add Data Label”. Once again, select the point on the center axis, right-click, and select “Format data labels”. In the right window, “Label Include” first check the “X value”, and then remove the original “Y value” check, and in the “Label Position and select “Down” in “Label Position”. After completing the above steps, the data displayed for the original X-axis grid value can be modified manually, the data you want to display can be modified to get the effect of Figure III.
5, the above four steps is to complete the normal probability scale drawing, logarithmic scale coordinates of the drawing method is similar to the above method. First of all, enter the original data, according to the function ln (number) to find its logarithm, in the new column enter “-3.7194695”, and fill with fill handle.
Right-click on the chart, select “Select Data”, in the pop-up window of the “X-axis series value” select all “-3.7194695” that column, in the “Y-axis series value” select all “-3.7194695” that column, in the “Y-axis series value” select all “-3.7194695” that column. a column, in the “Y-axis series value” select the logarithm of the original data, selected after selecting OK, and then “OK”, at this time that the logarithmic scale is displayed on the Y-axis. (“-3.7194695” column is to ensure that the logarithmic data fall on the Y-axis.)
6, the next step is to delete the value of the vertical axis as in step four, show the point of the data label, this time only check the “Y-axis” no longer check the “X-axis”, the label’s position select ” to the left”. And then manually modify the data you want to display, that is, to complete the display of values on the Y-axis.
7, the dust particle size was lognormal distribution as an example of how to apply the above steps produced by the lognormal probability coordinates.
Set the known particle size of the dust and the number of each particle size sieve under the cumulative distribution value. Enter the raw data in excel. Calculate the logarithm of the particle size by ln(number), and calculate the value of the sieve cumulative distribution value corresponding to the regression standard normal interval value (i.e., the X-axis grid value described above) by NORM.S.INV. Add the calculated logarithm of particle size and X-axis grid value data to the table, right-click, and add a trend line. If the data points show a good linear relationship, it indicates that the particle size of the dust is log-normally distributed.
Guess what you like:
1.excel use function to create a normal distribution graph method
2.how to use Excel function to draw a curve
3.Excel in the 2010 version of the method of plotting the standard normal distribution probability density function graph
4.excel2010 normal distribution how to do
5.Excel table how to make a normal distribution data graph and normal curve template
How to plot the probability density distribution of foreign exchange yields
1, collect the required data: you need to obtain historical foreign exchange price data, which can be obtained from major financial websites or trading platforms.
2, calculate the rate of return: the price change in each time interval is converted into a rate of return. Usually use the logarithmic rate of return (logreturns) to calculate the formula: log (today’s prices / yesterday’s prices).
3, statistical analysis: through the mean, standard deviation and other statistical indicators to describe the distribution of returns.
4, plotting the probability density distribution: using statistical software or programming languages (such as Python and R) to plot the probability density distribution, where the x-axis represents the value of the return, and the y-axis represents the probability density value. Commonly used probability density functions include normal distribution, t-distribution, gamma distribution and so on.