default_name
Board Regular
- Joined
- May 16, 2018
- Messages
- 170
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hello!
I have two columns:
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:
Thanks in advance!
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)
<tbody>
</tbody>
How would I go about writing a function that would do this within the regular formula editor?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>
Thanks in advance!