Quadratic Regression Analysis in Excel

This video providses step-by-step instructions on how to do a quadratic (2nd-order) regression analysis (least-squares curve fit) using Microsoft Excel, and then how to plot the results.

You can also watch all related short videos with one click by going to one of Dr. Cimbala's playlists:

[jonathantan]

WOW! I searched for 9 hours and yours is the only video who solved my problem in two minutes. I love you king

[sasquatchhimself]

Outstanding. Quick and clear and easy. Wish all videos were like this. Thanks

[kongleakhenaneth]

Wow. Your explanation is amazing! Its short, simple and full of information. You just saved me, sir.

[BogieRaven]

Thank you for explaining how the Multiple R data fits into what what is actually going on in a way I easily understood!

[redraiders]

Its 2022 and this video helped me a lot. Thank you John!

[plutoniumfy]

Thank you so much for this tutorial! It was concise and straight-forward to understand.

[BabuRamPascaranPKAppa]

Thank you Sir, very clear explanation, a dummy like me can understand it well. I very much appreciate it.

[Firehun]

Thank you! This is the best video tutorial for this, short and simple

[Maharajasworld]

wow!! nice explanation..what if we have more than one variable

[zzounds]

Great! Really! Thank you for taking your time to make such a video, it really helped me! Thank you once again very much!

[blessedvona]

Thank you, please to use the quadratic fit to solve for unknowns what would be the equation for the quadratic curve?

[tomgroen_]

Hey John, great explanation! I do have a question tho, is it still possible to interpolate in the quadratic regression curve?

For example if I have a sample. The ‘x-value’ is in my case the concentration and the ‘y-value’ is the peak intensity. To make the quadratic regression curve I'm correcting the peak intensities, by using the known concentrations of the samples.

When I measure a new sample, I obtain the ‘normal’ peak intensity. I need to correct this using the concentration, but since the concentration is unknown, I’m not able to correct the peak intensity. Normally I would determinate the concentration by interpolating the found peak intensity in the curve, but because I need to correct the peak intensity, using the concentration, this is not possible. Am I still able to determinate the unknown concentration? Can I correct the peak intensity using the theoretical concentration and then interpolate the corrected peak intensity in the curve to obtain the concentration? I would really appreciate it if you could give me some advice 😊.

[RitheshrajD]

thank you!! is it possible to find the limit of detection (LOD) from second-order polynomial fitting

[StylinRed]

if i wanted a 3rd or more degree polynomial analysis would i need to make an X1, X2(^2) and X3(^3)... column? or just an X1 and X2 column with the equation in the 2nd column being cubed? 

[syakeera]

May i know what is meant by Standard Error at each intercept and slope variables results? I kinda confused to write about the error of the analysis.

[mrvlacp]

Can I have didfferent S.E Standard error for each y's???

[q]

2:42 how did you add 2 "$" suddenly???

[JMRG]

Alrite now i blieve this is a true polinomical regression.

[lokeshjindal]

Won't the model suffer from 100percent correlated independent variables