Excel How to fill area under curve, graph with color: normal distribution | Excel 1-8| IHDE Academy
HTML-код
- Опубликовано: 22 авг 2024
- In this lesson, I will show how to fill a selected area under the normal distribution curve in Microsoft Excel with a color.
A typical question in the context of statistical process control is:
Between which two dimensions is a certain proportion of values to be expected?
Various distribution models are used for the calculation.
Sometimes, in addition to the two measures, you also want to emphasize the area under the distribution curve.
So two quantiles are needed. This example shows the 5% and 95% quantile (percentile). The 5% quantile is the left limit, and the 95% quantile is the right limit of the 90% range.
I wish you much success.
Rolf Ihde
This was exactly what I was looking for, expertly made video!
Thank you for the positive feedback! It's great to hear that the video was useful to you.
sir how can apply this work flow on xy scatter chart in excel 2010.?
Hi, Thank you for your reply. Unfortunately, I don't have access to the 2010 version of Excel. I would assume, though, that the Excel functions NORM.INV and NORM.DIST, as well as the scatter chart, are available in Excel 2010.