Lecture Video 3.6: Estimation and Prediction Intervals in Excel

This video shows how to generate point estimates, confidence intervals, and prediction intervals using linear regression in Excel. The equations used are discussed in the previous video, "Lecture Video 3.5."

[@sunrayminor4726]

Splendid, just splendid. Showing the actual statistical formulas applied to Excel and excel formulas with a practical use demonstration . Thank you. Hope to see more.

[@statswithgavin6297]

I'm glad it was helpful!

[@huajunxu5816]

Thank you so much! It is the most detailed video I have found.

[@statswithgavin6297]

You're welcome! I'm glad you found it helpful.

[@ghossein21]

Thank you so much, you explained it so well and in a very easy to understand manner

[@statswithgavin6297]

You're very welcome. I'm glad it was helpful.

[@Kanixmentor]

Thank you very much for such detailed video. It helped me a lot for research article.

[@statswithgavin6297]

You're welcome, Raja. I'm glad it was helpful.

[@jayantiyer9739]

Thanks! Where can i find these formulas? Any reference/link?

[@statswithgavin6297]

We use this book in the statistics class that I teach and you can find them there: www.amazon.com/Statistics-Business-Economics-David-Anderson/dp/1337901067?ref=d6k_applink_bb_dls&dplnkId=65b8466f-2a03-4fa3-acd9-5bee417b0c2c

[@iancox7273]

How would you adjust for log-linear regression?

[@statswithgavin6297]

If it's a log-linear regression with just one independent variable and you are building the intervals around logged predicted values then you don't need to make any adjustments to the method in the video.

[@iancox7273]

@@statswithgavin6297 Thanks!

[@maarten4132]

Thx

[@statswithgavin6297]

No problem!

[@duanebarrosfonseca]

Can I use the same formulas for nonlinear regressions?