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)
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD="align: center"]X
[/TD]
[TD="align: center"]Gaussian
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"]0
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: center"]0.12
[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: center"]0.25
[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD="align: center"]0.50
[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD="align: center"]0.75
[/TD]
[/TR]
[TR]
[TD="align: center"]6
[/TD]
[TD="align: center"]0.85
[/TD]
[/TR]
[TR]
[TD="align: center"]7
[/TD]
[TD="align: center"]0.75
[/TD]
[/TR]
[TR]
[TD="align: center"]8
[/TD]
[TD="align: center"]0.50
[/TD]
[/TR]
[TR]
[TD="align: center"]9
[/TD]
[TD="align: center"]0.25
[/TD]
[/TR]
[TR]
[TD="align: center"]10
[/TD]
[TD="align: center"]0.12
[/TD]
[/TR]
[TR]
[TD="align: center"]11
[/TD]
[TD="align: center"]0
[/TD]
[/TR]
</tbody>[/TABLE]


​

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).