The Perfect Gaussian Curve fitting in MS Excel | Mathematics | Curve Fitting | Excel

Download Complete Notes at: www.edmerls.com/index.php/Math...
Curve fitting is the process of constructing a curve, or mathematical function, that has the best fit to a series of data points.
Fitted curves can be used as an aid for data visualization, to conclude values of a function where no data are available, and to summarize the relationships among two or more variables.
Equation for Gaussian Curve is, Y = A.{ e }^{ -\left( \frac { { \left( x-B
ight) }^{ 2 } }{ 2{ C }^{ 2 } }
ight) }
Where A is Height,
B is Position and
C is FWHM.
Analytical Reasoning
• Solve Problems Related...
English Grammar
• Making Sense With Tens...
Interview Skills
• Questions You May Be A...
Managerial Economics
• MCQ #1 of Managerial E...
Royalty Free Stock Footage
• Flowers - Royalty free...
Chemical Thermodynamics - Physical Chemistry
• State and Explain firs...
Ionic Equilibria - Physical Chemistry
• Derive expression for ...
Electrochemistry - Physical Chemistry
• What are different typ...
Solid State - Physical Chemistry
• Explain the following ...
Gaseous State - Physical Chemistry
• Postulates of Kinetic ...
Colloidal States - Physical Chemistry
• What is Colloidal Solu...
Stereochemistry - Organic Chemistry
• Explain Configuration ...
Nanomaterials - Engineering Chemistry
• Compare top down with ...
Water and Its Treatment - Engineering Chemistry
• Explain why hard water...
Electrochemistry - Engineering Chemistry
• Distinguish between me...
Environmental Studies
• MCQ on Environmental S...
Optics - Applied Physics
• What are cartesian sig...
For Details Visit
cepekmedia.co.nf
cepek.hol.es/
edmerls.66Ghz.com/
edmerls.tk/

[@ItoNarasimha]

Thank you so much, this worked wonderfully for my medical equipment evaluations!

[@mubinna1579]

Brother you have no idea how much you helped me.

[@SaturdayNightSocks]

Awesome video, very useful thanks. Helped me get my lab report done on time :)

[@adamsalazar1509]

Excellent! Thank you!

[@janielingchin2019]

Excellent work!

[@JesperSP]

You can also calculate the Sum chi sq using the formula = sumxmy2(Fit,y) - this way you dont need the "Chi sq" column

[@dannopper]

Thanks. Great video.

[@karthia6373]

Thank you, excellent video, I need to know that how to work with Modified Gaussian model (MGM). Could you please help on this?

[@stevefeldman5522]

Fine job. Really excellent. Thanks!

[@Edmerls]

Many thanks!

[@g.rabbanichowdhury3854]

Very well explained. Thank you very much. I used this method for fitting my experimental values. But unfortunately, the final values for the variables depend a lot on initial values (that we first assume). Did you notice anything like that in your calculation?

[@lakshay2772]

Very useful! Thanks!

[@Edmerls]

Glad it was helpful!

[@halohaihai]

Thank you very much, finally i can finish my homework

[@Edmerls]

You are welcome!

[@sagarrawal8332]

It was very much well explained..I understood a lot...can you please tell me what is concept of offset in curve fitting and how to calculated it?

[@ashrafmuhammad255]

But is for limited cells. it doesn't hold on more than 300 cells of a column.

[@rogerfernandez5533]

Hi, thanks for your video. Very useful. one question. to calculate chi sq (Column D) why you don't use ((Y - Fit)^2)/Fit. ? Just the difference btw them.

[@Edmerls]

Great suggestion!

[@euzavas]

Because he is using the Goodness-of-Fit given by the Chi distribution. Formula for that is (Observed Value - Expected Value)^2 / Expected Value... Like we do to test the association between two variables in a contingency table (chi-square test of independence, etc.)

[@ATM17820]

Legend

[@garymankey1294]

Nice work, but C is not the FWHM. They are related by FWHM = 2 * C * SQRT( 2 * LN (2)). Do another take please and also fix the part where you entered the fit formula wrong.

[@emanuelecetoloni5920]

You're the best

[@Edmerls]

Thanks

[@spyhunter0066]

How can you find the error in the fit parameters? That's the real deal.

[@andrewblock5339]

This doesn't appear to be working for me. It repeatedly just gives me a straight line when I'm trying to fit it to a Gaussian.

[@ashrafmuhammad255]

what is the purpose behind all this practice when we already have a curve of same dimensions.?

[@Edmerls]

Please check my website www.edmerls.com for complete course and download notes for free.

[@ashrafmuhammad255]

@@Edmerls Thank you so much, which course on your website explains my question.

[@YTPM_2305]

The equation used in excel for Gaussian fitting is incorrect. There is no exponential term.

[@elnazamjad8616]

If you just slow down a little that would be great. You say and do everything so fast it is difficult to follow.