Nonlinear Regression Using Excel

Nonlinear Regression Using Excel

[@michelelombardo681]

Sorry, but I am a bit confused on the business logic behind the setup... how can the "Number of ads" be explained by the "Volume of sales", shouldn't the variables actually be switched around to explain the relation?

[@robertcormia7970]

This is well organized and fairly easy to follow. I was able to complete the exercise after playing a few sections over. It works.

[@kotrynele]

So what is the optimal amount of ads and sales? Is it the derivative of the function equalized to 0 to find the Max?

[@chandrakanthmalyala1942]

It has to be so when you are going with GRG non linear. But if you do not select multi start option, you will end up with local optimal solution rather than global optimal solution

[@9986916092]

Can you post a video for performing the same in scilab plz

[@LEO_rumano]

these data 4153.2 ; -8757.9 ; R^2 = 92.26% are obtained (without using Solver) ,with only one formula selection 5 Files + 2 Columns (in office 365 is not necessary) , paste =LINEST(B3:B12,LN(A3:A12),,1) CTRL+SHIFT+ENTER (in office 365 is not necessary)

[@Georgia90]

thank you very much!

[@aminipo8829]

bad explanation

[@mamtapandey7410]

In which version excel such kind of facility available? Plz help me.

[@Sanghitabasu50]

2007 se suru karke jitne versions h sab mein milega.

[@tska84]

you can't rename them to A1 and A2 because those are already the names of other cells that exist in the spreadsheet

[@dinhvietcuong2239]

Nothing was better...

[@khadkhad8057]

mlih

[@mominahussain5552]

Watch this in 1.5 x speed

[@changbadinesh]

This is linear regression not nonlinear

[@DataAnalyticsPro21]

this is nonlinear because it has a nonlinear component in the form of ln(x)

[@jongcheulkim7284]

Thank you so much

[@khadkhad8057]

mlih