Linear and Polynomial Regression in Microsoft Excel

preview_player
Показать описание
Linear and polynomial regression is demonstrated in Excel. The data is show on a plot with trend lines added as linear, quadratic, and cubic correlations.
Рекомендации по теме
Комментарии
Автор

Thank you very much, wonderful information ....

jagathagurumarimuthu
Автор

Appreciate the explanation of how to get those numbers using the SLOPE, INTERCEPT and RSQ functions for the linear. Can you please give the names for the polynomial curve fit. I would like to have Excel spit those numbers out, but don't want to plot out each, as I have a lot of data to go through.

RDBremner
Автор

What is the maximum degree of polynomial that I can go for in excel?

biditkumarsarbajna
Автор

is polynomial regression and non-linear regression same?

NawtieBoy
Автор

Sir how to find unknown concentration from the second degree Polinomial equation ??

brpatel
Автор

Can you plot planetary transits or when they cross each other?

rhb
Автор

sir, I have a question
for linear line, u explained how u get the mount of numbers by using slop( ), and intercept( ) but for the polynomial, u didn't mention that how we can see this amount of number, for example, I want to see -0.1607x^2 I want to see all numbers of -0.1607 how I do that by excel function for polynomial? thank u so much for the information

yadfaruq
Автор

thank you for this . i did same as you did it, i did not get same result as in published paper. if you do not mind can i send email to you with attached file and more details.

raimonbawazir
Автор

but how do you fetch these coefficients automatically bro, i don't wanna write them myself see ?

arthurjuster