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

Поділитися
Вставка
  • Опубліковано 5 жов 2024

КОМЕНТАРІ • 31

  • @ItoNarasimha
    @ItoNarasimha 7 місяців тому

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

  • @mubinna1579
    @mubinna1579 Рік тому

    Brother you have no idea how much you helped me.

  • @JesperSP
    @JesperSP 4 роки тому +1

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

  • @garymankey1294
    @garymankey1294 2 роки тому +2

    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.

  • @halohaihai
    @halohaihai 2 роки тому

    Thank you very much, finally i can finish my homework

    • @Edmerls
      @Edmerls  2 роки тому

      You are welcome!

  • @g.rabbanichowdhury3854
    @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?

  • @sagarrawal8332
    @sagarrawal8332 5 років тому +1

    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
      @ashrafmuhammad255 4 роки тому

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

  • @rogerfernandez5533
    @rogerfernandez5533 3 роки тому +1

    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
      @Edmerls  3 роки тому

      Great suggestion!

    • @euzavas
      @euzavas 2 роки тому

      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.)

  • @SaturdayNightSocks
    @SaturdayNightSocks 4 роки тому

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

  • @stevefeldman5522
    @stevefeldman5522 3 роки тому

    Fine job. Really excellent. Thanks!

  • @karthia6373
    @karthia6373 3 роки тому

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

  • @dannopper
    @dannopper 4 роки тому

    Thanks. Great video.

  • @janielingchin2019
    @janielingchin2019 4 роки тому

    Excellent work!

  • @adamsalazar1509
    @adamsalazar1509 4 роки тому

    Excellent! Thank you!

  • @lakshay2772
    @lakshay2772 3 роки тому

    Very useful! Thanks!

    • @Edmerls
      @Edmerls  3 роки тому

      Glad it was helpful!

  • @emanuelecetoloni5920
    @emanuelecetoloni5920 5 років тому +1

    You're the best

  • @ATM17820
    @ATM17820 7 місяців тому

    Legend

  • @andrewblock5339
    @andrewblock5339 2 роки тому

    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.

  • @spyhunter0066
    @spyhunter0066 2 роки тому

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

  • @ashrafmuhammad255
    @ashrafmuhammad255 4 роки тому

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

    • @Edmerls
      @Edmerls  4 роки тому +1

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

    • @ashrafmuhammad255
      @ashrafmuhammad255 4 роки тому

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

  • @YTPM_2305
    @YTPM_2305 2 роки тому

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

  • @elnazamjad8616
    @elnazamjad8616 2 роки тому

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