Confidence Intervals vs. Prediction Intervals

What is the difference between Confidence Intervals and Prediction Intervals? And how do you calculate and plot them in your graphs?

[mm.f]

WOW! Thanks dude. Il have to replay this a few times but what an eye opener in using excel and confidence intervals. You're a savior

[ClicketyKate]

This video is amazing. My faith in good teachers has been restored.
I feel like I owe you a pint! Thank you for rescuing me during a PhD breakdown.

[sora]

Thank you so much. Much better than some of the other explanations I have seen.

[wes]

Hartstikke bedankt Gerard voor deze prachtige uitleg. Dit was precies wat ik nodig had.

[nicholasdavidson]

It's been too long since undergraduate stat classes. I was stumped. Thank you so much!

[cristiansrosa]

Excellent material to understand and develop both methods into excel spreadsheet.

[mohawberel]

thank u so much, I am not good in English, but this explanation is much more better than videos in Russian. Ur talent of teaching ruin language border.

[caissa]

holy moly, thank you! it's true as Jeff said below...hours and hours and can't find nearly as great and informative video as this one. working on my masters thesis and needed to know EXACTLY what you just taught us. :-)

[zacharymacchesney]

Great explanation, concise and informative. Thanks for sharing your knowledge and taking the time to present it in a simple and understandable manner.

[JeffUssing]

Dr. Verschuuren,

Thanks for sharing this great video. I spent hours on Google trying to find this very thing for one of my graduate classes. Everything I read covered the principals and theory behind this, which is great, I need to know that too. But failed to cover how to make the Excel charts.

Erg bedankt,
Jeff

[benphua]

Thank you for the explanation of these two items

[paulfilmer]

Much appreciated, and now included in all my plots...

[alessandrastellacaporale]

Thank you so much for sharing this video and the excellent explanation!

[joseibrandoamayavargas]

Muchas gracias por tu explicación, señor.

[vivekvanapalli]

This is so knowledgeable and precisely explained. Thanks Dr. Gerard! 

[pbjohnny]

I didn't know that James Bond as played by Sean Connery was such an astout statistician.

[ragsanoor]

You are awesome Sir...Thanks a ton for sharing your knowledge with us.. Pray God to give you long and healthy life... God Bless you...

[olegk]

Fantastic template and excellent presentation Dr. Verschuuren! Is it possible to do the same (And Plot PIs and CIs) in Excel with quadratic, cubic or arbitrary curve-fit? I always have to go to Minitab when I need these estimates. I would like to do this totally in Excel with non-linear dependencies.

[alexandrelucas]

How do we deal with this if we have a lot of independent variables (Xs)?

[josechvaicer]

What to do ( using this excellent video) when the X values are averages from time points with different number of samples. For example: Stability batches have 8 to 10 samples at 0, 1 and 3 months, but have only 3 or 2 samples for 12 and 15 months. How to adapt the linear regression to this kind of bias? How to consider these different "weights" of each average in the X values?