- #1
sunrah
- 199
- 22
I have 100 data points that I want to fit in Excel I can do this with NORMDIST no problem but I'm also trying to do it without it to no avail!
I'v tried plotting the data using the Gauss function:
[itex]y(x) = \frac{1}{\sqrt{\pi \sigma^{2}}}e^{\frac{-(x - x_{0})^2}{2\sigma^{2}}}[/itex]
where x is a data point, x0 the mean and σ the standard deviation from the mean, but it doesn't go bell-shaped although normdist gives a nice gaussian.
I'v tried plotting the data using the Gauss function:
[itex]y(x) = \frac{1}{\sqrt{\pi \sigma^{2}}}e^{\frac{-(x - x_{0})^2}{2\sigma^{2}}}[/itex]
where x is a data point, x0 the mean and σ the standard deviation from the mean, but it doesn't go bell-shaped although normdist gives a nice gaussian.
Last edited: