How to use Excel to calculate Confidence interval and prediciton interval for multiple regression mo

[@scotthand3897]

Hello dr
I think actually that is incorrect the way you calculated prediction interval
However it may be a simple estimate of what the prediction interval is

[@mikeg4075]

Thank you!!!

[@DrJiangJingze]

You are welcome!

[@maarten4132]

Thx

[@DrJiangJingze]

You are welcome!

[@mayurbhagat2143]

How to plot 95% Lower and upper CI line in scatter plot?

[@DrJiangJingze]

You basically use the method I taught in this video to calculate the y value for each X observation. Please let me know if this is helpful or you need further explanation.