Statistics add-in software for statistical analysis in Excel
  • Tutorials
  • Simple linear regression tutorial

Making predictions

In many cases the purpose of model fitting is to make predictions about the response given a value of the predictor.

It is important to remember that making predictions outside the observed range of the data (known as extrapolation) is risky. It is impossible to be sure that the fitted relationship extends beyond the observed range.

  1. On the Analyse-it ribbon tab, in the Predict group, click Predict .

    The Predict Y panel is added to the analysis task pane.

  2. In the Predict Y grid, enter 100 in the #1 edit box.
  3. Select the Mean check box, and in the Confidence interval edit box, enter 95%.
  4. Select the Individual check box, and in the Prediction interval edit box, enter 95%.
  5. Click Recalculate.
    The results are calculated and the analysis report opens.

For a Budget of 100 million $ the average retained impressions per week is 64.9 million. The 95% confidence interval (CI) 50.2 to 79.5 million is the uncertainty in the mean estimate. The 95% prediction interval (PI) 18.2 to 111.6 is the interval we would expect a single future observations to lie within.

predict Y from regression fitted model

  •  Tutorials
  •  Distribution tutorial
  •  Correlation / PCA tutorial
  •  Compare groups means tutorial
  •  Association in 2-way contingency tables tutorial
  •  Simple linear regression tutorial
  •  Plotting bivariate data
  •  Fitting a simple regression model
  •  Checking the assumptions of the regression model
  •  Changing the regression fit
  •  Making predictions
  •  Bland-Altman method comparison tutorial
  •  Estimating the precision of a measurement procedure (CLSI EP05-A3)
  •  Evaluating the linearity of a measurement procedure (CLSI EP06-A)
  •  Verifying the precision of a measurement procedure against a performance claim and estimating the bias (CLSI EP15-A3)
  •  Pareto charts tutorial
  •  Process control charts tutorial
  •  Process capability tutorial



Version 6.15
Published 18-Apr-2023
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.