How to generate Non-linear regression equations in MS Excel

Поділитися
Вставка
  • Опубліковано 18 січ 2025

КОМЕНТАРІ • 33

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

    Very nice Sir.....
    Thanks a lot

  • @SudhirKumar-cp1uq
    @SudhirKumar-cp1uq 4 роки тому

    Beautiful explanation

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

    Hello Sir, what would be the method if i have 6 input parameters? For Non Linear Regression equation. Do I create X1^2 all the way to X6^2?

  • @aa-sg8yp
    @aa-sg8yp 2 роки тому

    Thank you sir.. I have one independent variable and one dependent variable. What should I do..? I need to do nonlinear regression

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

      What is the reason behind your idea on one dependent and independent variable. what you are expecting the outcome of it.

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

    Hello sir... If i have 4 input variables for 1 response.. how to apply 2nd order regression model

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

      hi sir, if you need second order model, then do the interactions like you have A,B,C&D, A^2, B^2,C^2,D^2 like that can you do and generate the regression model.

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

      @@Vitarka thanks for replying sir..
      Sir i have taken 4 input parameters. After that I tried 2nd order model using Ms Excel as wel as MiNitab 19.
      I have selected A, B, C, D , A2, B2, C2, D2, AB , AC, AD, BC, BD, CD
      Now minitab is not considering the A2 and excel is not showing the coefficient value for A.

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

      May be A2 is not significant contribution, remove A2 and generate the equation.

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

      @@Vitarka dear sir, may u get ur what's up no... And discuss there .

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

      gmail: vitarkaprojects
      mail to me

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

    Thank you for this video. If we have two or more variables and one is increasing while other is decreasing. Overall effect of these two variables on output results is non linear. How to solve for this case for second order polynomial?

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

      I am not understanding one variable decreasing and one variable decreasing, basically these are input variables. Some case of randomness will be there definitely.

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

      @@Vitarka Sir, if an output result is depending on two input variables. value of one input variable is increasing, say 10, 20, 30, 40, 50 while at the same time value of second input variable is decreasing, say 50, 40, 30, 20 10.
      In this case, how can we generate non linear regression equation which can predict output based on above stated two input variables.?
      Sir, please reply.

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

      sir, i hope there is no change in procedure, apply the same you can get those

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

    How to do a Multiple non linear Regression in excel?

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

      What is difference between Multiple Non Linear & Non Linear regression. I think both are same. Please let me aware of it.

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

    How to generate power equation using regression concept...?

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

      you mean non linear equation

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

      @@Vitarka Yes Sir

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

      The procedure I have explained

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

      @@Vitarka sir can I sent u mail of my problem?

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

      Mail to me Gmail- vitarkaprojects

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

    You mentioned that R square indicate how accurate model is fitted also told that if it's above 90% then model is called as good fit but at the same time when you consider three variable and made a regression where R square value is about 96 and further you are considering the interaction effect why???
    Why there is contradiction in the condition when you see the R square value and p value for the intercept???
    You didn't mentioned about what about Adj R square???🙄

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

      Interaction effect basically talks about how you inputs are interacting with the output you are estimating. Interaction you can study two at a time.
      I don't know what contradiction in the R square value ?
      Adj R square is if there is any minor change in the experimental data also the fitness will be as close. Basically it should be only 2% difference between the RSq and Sq-adjusted.
      You can this video also at 13:08 ua-cam.com/video/2SZXC2vms-g/v-deo.html

  • @Capungo
    @Capungo 8 місяців тому

    The English language should be banned in India...

    • @Vitarka
      @Vitarka  8 місяців тому

      I hope this is not a relevant platform to express