Gaussian curve with EXCEL

Good evening everyone;
first of all, I want to sincerely thank you for taking the time to read and respond to my question with such diligence and seriousness.

@ Raymond:

actually, I was alluding to the fact that the bone is set, which is not true, to the point that I was ashamed to ask questions like: what is the step? what values should I create? and how? why -3 and 3? I am just a simple beginner in Excel, and you could say I'm a pro-beginner even :(

@ ak21306:

I am a biochemist, I do not deny having seen statistics courses, but very superficially, moreover we did not delve into graphical representations. I would like to create a Gaussian curve on my own without anyone's (teacher's) guidance, and to do this I managed to download a workbook that shows the procedure, but unfortunately it is not very useful to me since it contains bizarre concepts (almost the same workbook that ccm18 gave)

@ ccm18:

while browsing the pages of a book by Dagneli, I was able to extract the formula for the probability density, and based on these values I requested the scatter plot in Excel, but it did not look like the Gaussian one!

have a good evening.

re
a few clarifications
- the normal distribution is defined by its mean (or mathematical expectation) and its standard deviation (m and s in my sheet)
- the probability density f is represented by the bell curve C of Gauss, (probability density sheet)
- the probability p(X<x) is the area under the curve C from negative infinity to x (the integral) and the function F(x) = p(X<x) is the cumulative distribution function of the distribution. it is a monotonically increasing function on (-infinity, +infinity] from 0 to 1, (cumulative distribution function sheet)
- you can change the value of m (mean) and s (standard deviation)
- the step is the difference between two consecutive values of x in the table, it is calculated so that the table contains 100 values, so do not touch it
- the value tables go from x = m-4*s to x+4*s, an interval containing more than 99.9% of the values of x (for a normal distribution)
- in both graphs, the points M(x,f(x), N(x,F(x)) show how the function evolves, according to a value of x entered in E6, the rest is calculated. When you change m and s in B2:B3, it is possible that these lines are not very relevant, normal, you need to change x in E6 so that this value is within the range of x values. If these lines bother you, you can delete the two series from the graph

I hope I have clarified some of the bizarre concepts a bit

have a good day

Hello ccm81;

I found in your response the remedy for my little "Gaussian boo-boo"; indeed, I was finally able to get a perfect Gaussian just by replacing the m and s values in your spreadsheet with mine.

Actually, I was on the wrong track thinking I had to put my data in the (100) table.

It’s all clear now.

I owe you a big thank you.

there is no Gaussian in this section,
the Gaussian is expressed as a function of the probability density, but it requires too much calculation.....which I am trying to shorten.

Good evening;
I would like to thank you for your valuable answers and explanations :)
Have a good evening everyone.

Excel is designed to spare the user from mountains of calculations and provide reliable and consistent results.
Moreover, I've already conducted a search on Google, but to no avail.
I would like to draw your attention to an important point: I am not looking to solve a mathematical problem; I am looking for a trick to create this curve without calculations...

I hope my concern is clear ;)

Hello,
We must have different Google results, because for me it leads to this address:
http://www.excelabo.net/trucs/graph_loi_normale
Good graph.

Hello Raymond;

your words are very kind Raymond, thank you,

have a good afternoon and good luck to your daughter ;)

See you soon.