Part of the Advanced Excel training series which covers how to find the best fit curve for a given set of data. This example uses Excel's Solver Add-in to mimic Excel's trend line using a Gaussian curve.

The completed example file can be found below. Please note that this will not match EXACTLY to the video because the RAND() function provided a different "raw data" set for the following file. You can use this file to check your work.

https://drive.google.com/open?id=0B2n...