From an existing multiple regression output produced with Excel 2007, I show you how to make point predictions and approximate 95% prediction intervals. The basic package of Excel does not have a routine for making predictions intervals, so I suggest a method of inflating the residual standard deviation statistic by 10% to get an approximate standard error of prediction.
Thank you so much!
julespe 6 months ago
helped for me
jamaniusa 9 months ago