How To... Perform Logarithmic Regression in Excel

Use Excel to create a logarithmic regression model to predict the value of a dependent variable based on an independent variable. In this video you will visualise the data and create a model that can be used to make predictions. The data used in this example is based on tree growth.

[@linhtiensaphora7567]

Thank you for a refresher of 30 years.

[@solarflare2722]

I've been trying to find a way to do this for SO LONg, THANK YOU SO MUCH

[@kanyaanindya8299]

Extremely helpful! Thanks so much!

[@melersoy3889]

fantastic- just what we needed!

[@shahriarkhan6466]

Thank you so much. Extremely helpful.

[@richardmaalouf4432]

Thank you sir for your very simple yet effective informative video

[@susy4027]

you just saved my life. Thanks very much.

[@graveyardrumblers]

Thank you, this was tremendously helpful

[@liamhoward2208]

How would one find the optimal co-efficient and constant by hand?

[@lorettavillas9704]

Thanks so much!!! Helped heaps 👏👏

[@KORE9000]

Muchas Gracias por el vídeo, estudiando desde casa.

[@venipr5413]

Very helpful sir. thankyou so much!

[@kamilsonsalla2491]

thanks, thats what I needed! :)

[@baileysmith4503]

This Guy a GOD at maths

[@Walter.Quiroz]

It's fantastic, it's helped me forecast sales! Thanks a million!

[@elmukelmu123]

I’d be really concerned if your sales plot to a logarithmic curve

[@Walter.Quiroz]

@@elmukelmu123 Why would they?

[@dartme18]

@@Walter.Quiroz Did your forecast come true!?

[@Walter.Quiroz]

@@dartme18 Pandemic wouldn't help, it was quite close to the adjustment though.

[@mr.viewfinder2472]

fantastic sir. Bless you.

[@emiliogonzalezalvarez204]

Top, thanks sir!

[@adityasingh-gy7yg]

Which excel version is this?

[@nadiautami436]

Thank you!

[@maloyaircraft1174]

Fantastic overview. Thank you

[@EugeneOLoughlin]

Glad you liked it!

[@CarPlebs]

Mega vid, used it to create a voltage curve for the oil temp

[@sriitatarigan290]

Thank you Sir. I have a question, what about to search x what the formula will be if y=50 ? And what the formula to enter on excel ? Help me please

[@muma6999]

thanks, now I get it

[@RITA-RNT]

Can anyone tell me how to get the number b&a (y=blogX+a) automatically without typing. I normally use intercept function but it works with linear and polynomial equation only. HELP PLEASE!

[@100feetsTall]

As explicit as it could get. Thanks

[@nahidmustneeded2714]

awesome

[@korman9872]

Tx sir

[@manojtomar8026]

how can we find x if y would be given

[@Melissa-ds1te]

Did you ever find out?

[@manojtomar8026]

@@Melissa-ds1te yes

[@raghadalzahrani1591]

@@manojtomar8026, Can you please share how you did it? I appreciate that.

[@punit0031]

Hello, Sir. I am a resercher from India. My question is about Duncan's Multiple Range Test. We are generally performing this test using either spss or MS excel patch. But how to calculate it manually from ANOVA table? Please make a video.

[@saikiaujjal50]

Please upload how to solve, y=a+bx+c logx

[@raghadalzahrani1591]

Did you solve it? can you please share how you did it!