Confidence and prediction intervals for forecasted values

The 95% confidence interval for the forecasted values ŷ of x is

Confidence interval regression


This means that there is a 95% probability that the true linear regression line of the population will lie within the confidence interval of the regression line calculated from the sample data.

 Confidence prediction interval

Figure 1 – Confidence vs. prediction intervals

In the graph on the left of Figure 1, a linear regression line is calculated to fit the sample data points. The confidence interval consists of the space between the two curves (dotted lines). Thus there is a 95% probability that the true best-fit line for the population lies within the confidence interval (e.g. any of the lines in the figure on the right above).

There is also a concept called prediction interval. Here we look at any specific value of x, x0, and find an interval around the predicted value ŷ0 for x0 such that there is a 95% probability that the real value of y (in the population) corresponding to x0 is within this interval (see the graph on the right side of Figure 1).

The 95% prediction interval of the forecasted value ŷ0 for x0 is

Prediction interval regression

where the standard error of the prediction is

Standard error prediction

For any specific value x0 the prediction interval is more meaningful than the confidence interval.

Example 1: Find the 95% confidence and prediction intervals for the forecasted life expectancy for men who smoke 20 cigarettes in Example 1 of Method of Least Squares.

Confidence prediction intervals Excel

Figure 2 – Confidence and prediction intervals

Referring to Figure 2, we see that the forecasted value for 20 cigarettes is given by FORECAST(20,B4:B18,A4:A18) = 73.16. The confidence interval, calculated using the standard error 2.06 (found in cell E12), is (68.70, 77.61).

The prediction interval is calculated in a similar way using the prediction standard error of 8.24 (found in cell J12). Thus life expectancy of men who smoke 20 cigarettes is in the interval (55.36, 90.95) with 95% probability.

Observation: You can create charts of the confidence interval or prediction interval for a regression model. This is demonstrated at Charts of Regression Intervals. You can also use the Real Statistics Confidence and Prediction Interval Plots data analysis tool to do this, as described on that webpage.

Example 2: Test whether the y-intercept is 0.

We use the same approach as that used in Example 1 to find the confidence interval of ŷ when x = 0 (this is the y-intercept). The result is given in column M of Figure 2. Here the standard error is


and so the confidence interval is


Since 0 is not in this interval, the null hypothesis that the y-intercept is zero is rejected.

86 Responses to Confidence and prediction intervals for forecasted values

  1. Joaquin says:

    Dr. Zaiontz,
    Very neat and concise example. I’m particularly interested in a one sided C.I. (lower bound)
    Would you agree to use
    \hat{y} – t_{crit} s.e.

    where t_{crit} should be calculated in Excel using =TINV(2*\alpha,df),
    where \alpha = 1-p?



    • Charles says:


      I believe that what you wrote is correct.


      • Emiel says:

        Hi all,

        It would be good to point out that the function TINV gives a two-sided confidence interval. The new function T.INV (with a dot) gives a one-sided confidence interval. In case of using the new function, you should take \alpha/2; furthermore, it uses the 1-\alpha/2 value, thus, T.INV(0.975,df).


        • Charles says:


          Actually, more simply you should use the T.INV.2T function for the two-sided critical value. It is equivalent to TINV.

          This is explained on the webpage

          I will shortly update this information to better explain the various usages of the functions.


          • Omamz says:

            Hi Charles,

            Your post has been of tremendous help to me.
            Although it took me some time I have applied most of the solutions and they have worked just fine.
            I need clarification on example 2. Why did you have to eliminate the # 1 before 1/15?
            Would really appreciate your prompt response.

          • Charles says:

            The test uses the confidence interval and not the prediction interval. This is why a 1 is not inserted before 1/15. Shortly I will update the webpage to explain better when the prediction interval is used and when the confidence interval is used.

  2. Kristian Pedersen says:


    Whats the formula in J12? Cannot get the same results…



    • Charles says:

      Hi Kristian,
      J12 contains the same value as cell E9. The formula in E9 is =FORECAST(E8,B4:B18,A4:A18).

      • Kristian Pedersen says:

        Hi Charles,

        I’m refering to J12, not J11 🙂 J12 contains the formula for se (prediction standard error) and formula result i 8.236857, which I cannot get by using the exact same numbers you do.

        What formula is in cell J12??

        I think it is in the (x – x_)^2 that something is wrong!


  3. Kristian Pedersen says:

    Hi Charles,

    Great. Thank u.


  4. Anu says:

    Please help how u got value of SSx which I suppose to be:-271.6

  5. David says:

    Hi Charles,

    Thanks for your contributions on this site. I’m a bit confused by your base formula, though. Where you use the sum of squared deviations of x (SSx, calculated as DEVSQ(x) or DEVSQ(A4:A:18), I’ve learned to use the standard deviation of x times (n-1), or STDEV.S(A4:A:18)*(n-1) in Excel speak. This would yield a value of CI SE of 2.090695467 and a PI SE of 8.244184143. The difference is small in your dataset, but where deviations are larger the use of sums of squared deviations instead of the method I’ve heard will yield very different results. That said, I’m not at all certain which method is correct–can you point to some references for your formula, please?

    Thanks in advance for taking the time to clarify this issue for me.


    • Charles says:

      Hi David,

      Note that for any range R1, the square root of DEVSQ(R1) is STDEV.S(R1)*(n-1). In fact, in the formula for cell E12 in Figure 2 of the referenced page I do take the square root of SSx, and so it seems that we should get the same answer. Can you send me an example of your calculation so that I can see why the results are not the same?


      • Zhang says:

        Thanks for your contribution. I would like to know how to calculate CI and PI if there are two independent variables. Thanks.

  6. Rizwan says:

    Hi Charles,

    Is Syx = Sres = STEYX(Y,X)? Is it same as Syx = SQRT((SUM(yi – Yi)^2)/(degrees of freedom)), where (xi,yi) are given data and Y is any nonlinear model (not a straight line, say a sigmoidal or logistic curve), which fits the data.

    • Charles says:

      Sorry for the long delay in responding to you. I just realized that I overlooked responding to you.
      It is true that Syx = Sres = STEYX(Y,X) = SQRT((SUM(yi – Yi)^2)/df) for linear models. I am not sure what these terms would even mean for non linear models such as logistic regression models.

  7. Elisa says:

    Hi Charles,
    I am using a exponential/hyperbolic function to fit my data. The model is (a*X+b)-SQRT[(a*X+b)^2-((4*a*X*b*c)/(2*c))].
    I wonder if I can calculate prediction intervals in the way you show, or if there is any parameter that is different for this type of models. If so, can you tell me how I should calculate it?
    Thank you very much

  8. Tristan says:

    Hi Charles,

    This post has helped me so much already, really very insightful and easy to follow!

    I am trying to do a prediction interval for some metal fatigue test data but I am trying to find 90% confidence in the 98% reliability data. In order to do this is just using 0.1 as the probability in TINV sufficient for the method to change it to the 90% probability or do I need to make more changes please?

    Thanks for your help!


    • Charles says:

      TINV(.1,df) (i.e. alpha = .1) is part of the formula for a 90% prediction interval. But I don’t understand what the 98% reliability data means.

  9. Ryan says:


    What’s the rationale for the added 1 under the square root of the standard error of the prediction? Theoretically, why 1?

    Thank you

    • Charles says:

      The standard error for a prediction interval adds the variability of the points around the predicted mean. mathematically this is where the 1 comes from.
      I plan to eventually show the proofs of the formulas for the confidence and prediction intervals. You will then be able to see from the proofs more precisely where the 1 comes from.

  10. Paul says:

    Hi Charles,
    I notice that you use n-2 for degrees of freedom, whilst other publications, for example UKAS M3003, use n-1. Although a small difference is seen in the calculation of the degrees of freedom, it can greatly affect the interval magnitude. Could you give some advise as to which calculation should be used for the df value? Thank you in advance for your reply.

    By the way, your website has been an extremely useful aid, Thanks

    • Charles says:

      I am not familiar with UKAS M3003, but I just checked a few other publications and they all show df = n-2 when calculating the confidence interval for regression.

  11. Mari says:

    Hello! Thank you very much this incredibly helpful guide! Do you have a tutorial on how to find the C.I and P.I using multiple regression?

  12. Phil says:

    Hi Charles,
    I wanted to point out a common misunderstanding about confidence intervals: CI’s say nothing about the probability that the true value of the population parameter lies within them – it either does or it doesn’t. A 95% CI just tells you that, if you were to repeat your experiment (sampling) an infinite number of times and run the statistics on each sample, the true parameter will lie within 95% of those confidence intervals. What you described as a CI in the first section of your post is actually Bayesian credible interval, which is a bit more complicated to calculate, but it does tell you the probability that your population parameter lies within the interval.

    • Charles says:


      Thanks for correcting my somewhat appealing, but, in the end, inaccurate statement. Shortly I will update the website with a more accurate characterization of the confidence interval.

      I appreciate your help in making the site more accurate.


  13. Andy says:

    Hi Charles,
    I need like to plot the 95% Confidence Interval curves just like they are shown within Figure 1 (e.g. the dotted lines). How would you recommend doing this in Excel? I was informed that other programs may provide this feature, but I prefer to continue working in Excel if at all possible.
    Thank you in advance,

    • Charles says:

      Yes, you can do this in Excel. E.g. to create the dotted line for the upper confidence interval curve, fill in a range of x and y values (say A1:B100) as follows: (1) in column A insert x values of the appropriate scale. If for example you are looking at values between 0 and 10, insert 0 in cell A1 and the formula =A1+.1 in cell A2 and then highlight the range A2:A100 and press Ctrl-D, in (2) in column B insert the y values for the upper confidence interval. E.g. in cell B1 insert the Excel formula for the upper confidence interval value corresponding to the x value in cell A1 (this is as described in cell E15 of Figure 2 of the referenced webpage), then highlight range B1:B100 and press Ctrl-D. (Make sure that you use absolute addressing for all the parts of the formula in B1 that don’t depend on the x value in cell A1.) (3) Finally, highlight range A1:B100 and select Insert > Charts|Scatter.

  14. Ang says:

    Hi, Charles. Can you make a video on plotting a 95% confidence interval. Above instruction was really confusing. Will be grateful.

    • Charles says:

      Thanks for your input. I will try to improve the explanation, but first I need to finish up the work I am doing on time series analysis.

  15. Gary says:

    Hi Charles,

    If I understand you correctly, you describe the confidence interval as the range of possible values for model parameters, e.g. the range of values slope and intercept may be for a linear regression for a given set of data and specified confidence interval. You describe prediction interval as the interval around a predicted Y for a specific X0.

    However, in your example you calculate confidence interval for a specific X0 and do the same for a prediction interval. I am confused as the example does not appear to match the discussion.

    Obviously I don’t understand you correctly!

    On a related matter, when one does a linear regression with Excel, Excel reports the Lower and Upper confidence intervals for “intercept” and “X Variable”, i.e. values for the slope and intercept. How does this Excel output relate to your discussion above?

    Thank you

    • Charles says:

      I will respond to your first question shortly.
      Regarding your second question: the confidence intervals for the intercept and x variable are really for the intercept and x coefficient (not for the prediction or confidence interval of data elements).

    • Charles says:


      Here is my response to your first question:

      The confidence interval focuses on the population mean. If you create many random samples that are normally distributed and for each sample you calculate a confidence interval for the mean, then about 95% of those intervals will contain the true value of the population mean.

      The prediction interval focuses on the true y value for any set of x values. If you create many random samples that are normally distributed and for each sample you calculate a prediction interval for the y value corresponding to some set of x values, then about 95% of those intervals will contain the true y value.


  16. John Hart says:

    Hello Charles,

    Could you tell me what the first part in cell G12 is (it is kind of blurry on my monitor), for the calculation of s.e. 2.06?

    Also, is there a shortcut (function) in Excel for the s.e. calculation?

    Thank you,

    • Charles says:


      Cell G12 contains the following formula: s_Res * SQRT(1/n + x_0 – k) – 2/SS_x)

      There is no Excel formula for calculating this. The Real Statistics form REGPRED will automatically calculate the s.e. in the prediction interval case, but not the confidence interval case. I will add a similar formula for the confidence interval shortly. See the following webpage for more details:
      Prediction and Confidence Intervals


  17. Sma Perkings says:

    Hello charles,

    Thank you for the explanation. I have a question though:
    what if I have x and I would like to predict y instead but with a confidence interval? is it the same principle and the same formula?

  18. Alex says:

    Everything seems to follow in my software (i wanted to transfer confidence intervals into a bespoke dashboard from my software) for a single X variable
    If i have two x variables how do i calculate the SE of the overall confidence interval?
    I.e what does the Equation in cell G12 look like?

  19. Steve says:

    I am trying to determine a confidence interval around a natural exponential function (y = ae^bx or ln(y) = ln(a)+bx) using Excel. I have reviewed this website but am unsure about the confidence interval calculation.
    Thank you!

    • Charles says:


      Since you are treating ln(y) = ln(a) + bx as a linear regression z = bx + c where z = ln(y) and c = ln(a), one approach to creating a confidence interval is to use the confidence interval for z = bx + c, as described on the webpage

      This will give you a confidence interval for z of form [h, k] you then need to convert this into a confidence interval for y. The simplest approach for this is to use the confidence interval [e^h, e^k].


  20. Will says:

    Hi Charles

    Thanks so much for this, I hadn’t found a description of prediction intervals in various textbooks. The example is really clear.

    Are the confidence and prediction intervals still valid outside of your range of known x’s? eg a colleague has produced a linear regression model for some data of payments against time to predict future payments. They have created confidence intervals for the predicted future payments.

    I was going to suggest an exponential smoothing method to predict the next values with confidence intervals but they have already used their regression model and wanted to know whether it was suitable.

    • Charles says:


      As to whether or not prediction are valid outside the data range, the answer (as is often the case) is that it depends. The following webpage explores this issue:

      I don’t have enough information to comment on whether exponential smoothing can be used. I have just added a description of exponential smoothing to the website. See the webpage Exponential Smoothing


      • Will says:

        Thanks for such a fast response, Charles,

        The data represents payments over time. They decay exponentially and are expected to reach zero eventually. A log transformation was performed before producing the linear regression model. The data is remarkably close to being a straight line after the log transformation. R squared is close to 1. Time is deemed to be a highly significant explanatory variable.

        I believe I could use exponential smoothing with a multiplicative trend and no seasonal component. If I wanted to predict payments at a certain point in future, do you think we would be better to use regression with prediction intervals or exponential smoothing? (I have 32 monthly observations but I’m particularly interested in the predicted value in 16 months time).

        Thanks again!

        • Charles says:

          I can’t tell which is better a priori. If there are theoretical reasons for using one over the other, then that should guide your choice. Otherwise I would try each and see which looks like a better fit. Of course, the limitations with this approach to the decision are (1) are you able to tell which provides a better fit and (2) does the choice overfit the data, i.e. it matches the known data better, but it is less of a fit for future values — this is why it is often better to base the decision on your domain knowledge (what I called theoretical considerations previously.

  21. Adam Scarchilli says:

    Thank you so much! This example was extremely helpful in finding prediction intervals in Excel and exactly what I was looking for!

  22. Roger says:

    Can you extend this to a pooled within-group slope as obtained from ANCOVA

    • Charles says:

      Sorry, but what do you consider to be the pooled within-group regression slope as obtained from ANCOVA?

      • Roger says:

        Hi Charles
        I am not a statistician – please bear this in mind.

        When you have two variables (x,y) and several groups, one can use an analysis of covariance to test the difference between groups for y when regressed against x. This does not use the regression line with the data pooled irrespective of group, but the pooled within group regression line. For example Statistical Methods, Snedechor and Cochran Chapter 14 fig 14:6:1 (6th ed) . I want the prediction intervals around this pooled-within-group regression line. I hope this is clear.

        • Charles says:

          Sorry Roger, but I don’t have access to Statistical Methods, Snedechor and Cochran Chapter 14 fig 14:6:1 (6th ed).

  23. Roger says:

    CAn you extend your Fig 1 to a pooled within-group regression slope as obtained from ANOVA

    • Charles says:

      Sorry, but what do you consider to be the pooled within-group regression slope as obtained from ANOVA?

  24. Christian Treitz says:

    Thank you, as with all the other commenters this operation procedure helped me very much.
    In your example we assume data to be t-distributed. Can I follow the same steps only replacing T.INV.2T(0.05;df) with NORM.INV(0.05;meanX;stdevX), if I assume my data is normally distributed? Also if this is possible, do I have to calculate NORM.INV(0.025;meanX;stdevX) for two tailed data? I did not find a description of this function to be sure on this point.
    Thank you and best regards, Christian

    • Charles says:

      Is there any reason why you want to replace the t distribution by the normal distribution? You would usually use the t distribution when the population mean and standard deviation are unknown (and so are estimated from the sample).

      • Christian Treitz says:

        Hello Charles,
        there are a few reasons why I wanted to check and see if choosing either distribution would produce different results. First, my data-set is a population and log-transformed normally distributed so I can calculate the geometric- population mean (or mean of log data) and geometric standard deviation. Second, the population size is around 2000 and I wanted to see if with so many degrees of freedom, choosing normal of t-distribution still makes a significant difference. In the end I am simply not sure which would be more correct however when I compared the results of T.INV(0.05,df) and NORM.INV(0.025, mean,stdev) for my data the values are quite similar, same with confidence levels 0.1 vs. 0.05. The only difference are that the second calculations gives me negative numbers.
        NORM.INV(0.025, mean,stdev)=-1.916
        NORM.INV(0.05, mean,stdev)=-1.604

        • Charles says:

          For df high enough the values should be almost the same. Also the correct comparison is
          NORM.INV(1-0.025, mean,stdev)=1.916
          NORM.INV(1-0.05, mean,stdev)=1.604

  25. DGRoberts says:

    Good Day

    I am using this methodology for my MSc dissertation. How do you suggest that I reference it?

    Is this appropriate?

    Zaiontz, C. (2016). Confidence and Prediction intervals for forecasted values. Retrieved June 16, 2016, from

  26. David Dinnarr says:

    Hi Charles,

    I’m fitting a regression model to some lifing data (Strain vs Number of Cycles) and would like to make sure I’m making the right assertions.

    When regression isn’t involved, I’ve seen several references to tolerance intervals. (I think this is what Tristan was referring to when he spoke about 98% of the population with 95% reliability.)
    I’m still struggling slightly with the differences between prediction and tolerance intervals (explained in, particularly in the context of a regression model. I was hoping you might be able to explain and have some pointers about how to modify the calculations to include it.

    Ideally I’d like to say for a certain value of strain (X) for a design we can be A% confident that B% of the population will survive beyond Y cycles.

    Many thanks for your help.

  27. Mark Stafford says:

    Hi Charles,

    What is the equation for the standard error of the prediction when the y-intercept is zero? The physics of our data requires linear regressions where y=0 when x=0. Something similar to, but in excel.


    • Charles says:


      I believe that the type of linear regression that you are referring to is described on the following webpage:
      Multiple Regression without Intercept. The value for the matrix B is given on that webpage.

      The calculation of the prediction interval is shown on the following webpage:
      Confidence and Prediction Intervals for Multiple Regression. You can use the formula on that webpage for the prediction interval substituting the value B given above.


      • Mark Stafford says:

        Sorry if I wasn’t specific enough, but I am using a simple linear regression thought the origin (zero-intercept). What is the equation for the confidence interval for the forecasted values ŷ of x? Wouldn’t it be that s.e.=0 when x=0 such that any and all possible true best fits still goes through the origin and do not rotate around the data set mean (curved confidence interval)? Thanks again.

        • Charles says:

          Clearly at x = 0, s.e. would be zero, but this is not the case for other values of x.
          The information I gave you previous will enable you to calculate a prediction interval at other values of x.

  28. Chester says:

    Hi Charles,

    I would like to know how to calculate the “Standard Error of intercept” or “Standard deviation of intercept” by excel formula rather than LINEST function?

    Thanks for your informative helps

  29. Tomas Alexandersson says:

    Hi Charles,
    Thanks for maintaining this site with very helpful information.

    Is it a good idea to use the prediction intervals as a check for outliers in the measured data when doing a linear regression between y and x?

    Best regards

  30. Cristopher Mallory-Coble says:

    Hello Charles-

    I am being asked to use the slope and intercept to create a nonlinear model, after I have identified my most linear graph which is the “Power Regression” model. With my regression summary statistics, how am I creating the formula using slope and the intercept. I am missing something rather simple I believe.


  31. Amanda Cardoso says:

    Charles Zaiontz,

    I need to say that you are such an absolutely amazing person. All your intructions are very easy to follow. I even like statistics now. Thank you very much!

  32. Keith says:

    Hello Dr. Zaiontz,
    I am developing a correlation between sample lab results (x) and field instrument readings (y) in order to establish a cleanup level equivalent for my field instrument. I’ve calculated 95% upper and lower prediction limits for the field instrument cleanup value equivalent and would like to know what I can say precisely about each of these values. Is it accurate to say of the lower prediction limit that there’s a 95% (or 90%?) chance that the true field instrument cleanup value equivalent is greater than the lower limit and that this value assures minimal false negatives (null hypothesis is that contamination exceeds cleanup level)? Similarly, is there a 95% (or 90%?) chance that the true field instrument cleanup value equivalent is less than the upper limit? If the latter is accurate, what would be any potential value of using the upper limit, other than it being the least conservative value (i.e. allowing minimize cleanup costs) without regard for false negatives?

    • Charles says:

      In general if you have a 95% confidence interval for some parameter of (a,b), it means that if you reran the experiment 1,000 times, then the true value of the parameter will occur in the interval (a,b) in approximately 950 (i.e. 95%) of these experiments.

Leave a Reply

Your email address will not be published. Required fields are marked *