Hey everyone,(adsbygoogle = window.adsbygoogle || []).push({});

I'm hoping I can get some input on this. As some of you may recall, I'm currently in an internship at Fermilab, and I've hit a snag in plotting my data. I'm measuring the intensity of the NuMI neutrino beam at multiple different points to look for discrepancies in the measured intensity and plotting them graphically. Essentially I'm taking the measured intensity and creating normal distributions, then finding the difference between the normal distributions and plotting the differences as normal distributions. I'm good up to this point, but now I need to take these differences and fit them to a Gaussian Distribution. This apparently isn't something that Excel has built in, but can be done using the proper procedures.

I've been following http://homepages.gac.edu/~smiller3/courses/371-f14/fitting.pdf [Broken] which has worked very well up to a point. I'm stuck on step 8. I'm trying to optimize the distribution using the Solver function in Excel 2013, and I keep getting a division by zero error for my R² value, and I can't figure out why. Could anyone provide some input or direct me toward a better tutorial for doing this? It would be very appreciated!

**Physics Forums - The Fusion of Science and Community**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Fitting data to a Gaussian Distribution in Excel

Loading...

Similar Threads - Fitting data Gaussian | Date |
---|---|

Mathematica Chisquare fit to multiple data sets | Aug 4, 2017 |

Fitting an ellipse through 3-d data | Feb 27, 2015 |

Fit data with function in MATLAB | Jun 29, 2013 |

MATLAB - Find the error on polynomial fit parameters of experimental data | Feb 5, 2013 |

Fit data with a curve in MATLAB | Nov 21, 2012 |

**Physics Forums - The Fusion of Science and Community**