Generate Gaussian Data

[default_name]

Hello!

I have two columns:

• 
  [*=1]X ranging from 300 to 1050 (cells AB53:AB803)
  [*=1]Gaussian Model

​

I would like the Gaussian Model column to fill in with Gaussian values.
Not sure if this makes any sense. Here is a somewhat basic example of what I mean.

Example:

I want to generate Gaussian data for 11 cells.
If the data were to be graphed, I want the data to have an amplitude of 85% (0.85).

The data would look like something this: (values are guessed here, just for the example)

X	Gaussian
1	0
2	0.12
3	0.25
4	0.50
5	0.75
6	0.85
7	0.75
8	0.50
9	0.25
10	0.12
11	0

<tbody>
</tbody>

​

How would I go about writing a function that would do this within the regular formula editor?

Thanks in advance!

 

[default_name]

I am seeing references to NORMINV online, but I am having a hard time with that (am not sure if that is even the correct route to take here).