Solving Polynomial Equations Using Goal Seek In Excel

Поделиться
HTML-код
  • Опубликовано: 4 фев 2025

Комментарии • 37

  • @TheOrganicChemistryTutor
    @TheOrganicChemistryTutor  Год назад

    Next Video: ruclips.net/video/vu0JmblDgog/видео.html
    Final Exams and Video Playlists: www.video-tutor.net/
    Full-Length Math & Science Videos: www.patreon.com/mathsciencetutor/collections

  • @victorialouren320
    @victorialouren320 2 года назад +12

    this guy seriously knows how to do everything. he deserves a Nobel peace prize

  • @jetorellana2893
    @jetorellana2893 3 года назад +5

    Thank you so much! This is really going to help with a HW that I have to turn in this week. You are the best, man. Thank you for making this videos. I can't thank you enough. You have no idea how influential you have been in my academic career. Thank you!!!

  • @patrickllr7947
    @patrickllr7947 6 лет назад +22

    11:00 - "The answer is 14."
    I laughed out loud.

    • @Carl_John
      @Carl_John 5 лет назад

      why have excel to solve it when he can solve it by himself, huh 😂😂

    • @threeaxis359
      @threeaxis359 4 года назад

      I know me to

  • @rinchentshering4661
    @rinchentshering4661 3 месяца назад

    It teaches several concept to solve polynomial equations using goal seek in excel;
    1. its helps show how changing one variable effects the outcome of a polynomial function
    2. Goal seek employs numerical methods to find solution
    3. this methods also shows mathematical models can be applied to real world problems,
    Graphing could be an alternative solution by plotting polynomial can visually help understand where the solution is. I agree that its the best solution.

  • @georgesadler7830
    @georgesadler7830 3 года назад

    MR. Organic Chemistry Tutor, thank you for Solving Polynomial Equations using Micrsoft Excel.

  • @solveiteasy7478
    @solveiteasy7478 5 лет назад +6

    If we plot a curve we can easly understand the range within which roots are lying. I think that will help

  • @CEMHanuragIIT
    @CEMHanuragIIT 2 года назад

    Awesome man, very helpful. Thanks

  • @rzaabdullayev6658
    @rzaabdullayev6658 2 года назад

    god, does this guy teaches excel as well? genius

  • @sansamman4619
    @sansamman4619 6 лет назад +3

    please do a series on c++ or c I would benefit a ton from a series on those 2 subjects

  • @kingsleyukaulor3704
    @kingsleyukaulor3704 2 года назад

    Thank you very much for this video. It was super helpful. Excellent!

  • @LT72884
    @LT72884 2 года назад

    what i usually do is graph a plot of the function in excel first, and that way io can see what my roots/zeros are and then i use goal seek. Or ill use bisection, rugala falsi, secant, fixed point or newton raphsons method to find my roots/zeros as well

  • @omali1703
    @omali1703 4 года назад +1

    Thanks very much for the explanation.. is it the same if I put f(x) equations??

  • @dineshbasnet7288
    @dineshbasnet7288 3 года назад

    Thank you Very Helpful

  • @NaufalFariza
    @NaufalFariza 3 года назад

    YOU ARE GENIOUS THANKYOU!!!!

  • @PedroMHenrique351
    @PedroMHenrique351 3 года назад

    Thank you so much!!

  • @bharatabs
    @bharatabs Год назад

    Thanks u so much

  • @Zeewaqar
    @Zeewaqar 5 лет назад

    thanks its help for me

  • @Zakir_Siddiky
    @Zakir_Siddiky 2 года назад

    Is it possible to get x values from the y values?

  • @gokhancakr4489
    @gokhancakr4489 3 года назад

    How I can adjust "to value" to the another cell or named variable?

  • @UsmanShakeel_ssppg_
    @UsmanShakeel_ssppg_ 3 года назад

    Thanks sir

  • @beenay18
    @beenay18 2 года назад

    i need goad seek value to be cell reference instead of number. is there any way to do it?

  • @xiaoboliu4377
    @xiaoboliu4377 5 лет назад

    Can I use the goal seek to calculate one whole column?

  • @omali1703
    @omali1703 4 года назад +4

    F(x)= x^3-1.9x^2-2.04x+2.016
    X= [-10 , 10 ] △X= 1
    Using goal seek find the polynomial roots ? What are the values of (x) that makes f(x) = 4 ? And last .. draw the graph?

  • @davinderkaur9534
    @davinderkaur9534 4 года назад

    How to put polynomial eq ..f(x) = x^2 - 4x +3 ...create an excel.formula that compute this equations .pkace the number 10 in cell A1

  • @brianwin5183
    @brianwin5183 4 года назад

    Thank you

  • @chloephung3700
    @chloephung3700 3 года назад +1

    do anyone know his info=)))) I love his voice since the first time I know this channel=)))

  • @samikacimi6858
    @samikacimi6858 3 года назад

    cant you set it to a cell and not a value?

  • @davinderkaur9534
    @davinderkaur9534 4 года назад

    In excel

  • @lvstw
    @lvstw 6 месяцев назад

    I tried on excel but my ans shows -6.25

  • @omali1703
    @omali1703 4 года назад

    Please

  • @prongelnursing2471
    @prongelnursing2471 Год назад

    I have office 365 and dont aee this feature

  • @imagine8229
    @imagine8229 3 года назад +1

    You exactly didnt help at how to use goal seek for polynomi yiu didnt give the real examples for it

  • @dhananjaymahajan3531
    @dhananjaymahajan3531 3 года назад

    thank you