Polynomial Regression in Excel 2010

Shows you how to do a polynomail regression of orders 1 to 4 of the newspaper revenue from classified ads since 1975 in Excel 2010.

[rajeshpandey]

This is much more helpful. Thanks Tom!

[lyvennet]

Thanks. I taught statistics in a Chinese University 15 years ago. I wish a video such as this had been available then.

[MrSupernova]

This video was extremely helpful. It explained the basics of a polynomial regression very clearly, Thank you!

[dcggil]

This was extremely helpful! Thank you! On top of the regression data I now know how the graphs work. One million thanks

[sarahal-zboun]

Really really helpful and very clear explanation.Thanks. For Mathematics' knowledge NO AGE> God bless

[SunOneAppscom]

Hello Tom,

Great video.

R-squared is coefficient of determination, expected value is between 0 to 1 and not -1 to 1

[sathyavel]

Presentation is excellent and also the example marvelous

[tuxlepingouin]

Thanks guy ! That's the solution i was looking for !

[LaguePentas]

Also works for excel2007 ... THANKS A LOT!

[jillposta]

thanks! this is precisely what i needed.

[MusafirHoonYaro]

I have a question which is an extension of the topic discussed in this video. I understand how to estimate the 95% Confidence Interval and 95% Prediction Interval for linear regression. Could you please guide me to any discussions where these quantities are estimated for non-linear regression? Thank you.

[davekam]

great video. Can you please explain how to get the variables out of the equation for use elsewhere in excel?

[hakim]

Thanks for this!! it was really useful!

[dariuslucas]

how to get the coefficients in a cell rather than in an equation within the chart?

[sewarekangalu]

At 3:00-3:15 minute mark: r^2 is between 0 and 1 because r is between -1 and 1.

[JMRG]

This is regressión of polynomial curves?, or we are just finding a parabolic tendency line... Is this Useful if i want to use Multi Factos like X, z, W, not only to determine Y

[vaidehicrs]

Great video! I am having a little difficulty in fitting a 7th order polynomial or higher in excel. Does it only fit up to 6th order polynomial ?

[marksworn]

Maybe just copy and paste the graphs next time? :)