Statistics add-in software for statistical analysis in Excel
  • Statistical Reference Guide
  • Fit model
  • Linear fit

Making predictions

Predict the value of the mean at specific values of the predictors, or the value of an individual future observation.

  1. Activate the analysis report worksheet.
  2. On the Analyse-it ribbon tab, click Predict, and then click Y.
    The analysis task pane Predict Y panel opens.
  3. In the Terms list box, under the #1 column, type the value for each predictor.

    You can leave a value blank in which case the average value is used. Leaving the value blank is useful in ANOVA models where you can predict the mean at specific combinations averaged over other effects.

  4. To predict the expected mean, select the Mean check box, and in the Confidence interval edit box, type the confidence level. Finally, in the Method drop-down list, select Simultaneous for intervals that ensure you achieve the confidence level simultaneously for all predictions, or Individual for intervals only that ensure confidence for each individual prediction.
  5. To predict the future value of an individual observation, select the Individual check box, and in the Prediction interval edit box, type the confidence level.
  6. Optional: On the Fit panel, in the Predicted values drop-down list, select the style to plot the predicated values on the scatter plot.
  7. Click Recalculate.
Related concepts
Prediction
Point and interval estimation
Available in Analyse-it Editions
Standard edition
Method Validation edition
Quality Control & Improvement edition
Ultimate edition

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Statistical Reference Guide
  •  Distribution
  •  Compare groups
  •  Compare pairs
  •  Contingency tables
  •  Correlation and association
  •  Principal component analysis (PCA)
  •  Factor analysis (FA)
  •  Item reliability
  •  Fit model
  •  Linear fit
  •  Simple regression models
  •  Fitting a simple linear regression
  •  Advanced models
  •  Fitting a multiple linear regression
  •  Performing ANOVA
  •  Performing 2-way or higher factorial ANOVA
  •  Performing ANCOVA
  •  Fitting an advanced linear model
  •  Scatter plot
  •  Summary of fit
  •  Parameter estimates
  •  Effect of model hypothesis test
  •  ANOVA table
  •  Predicted against actual Y plot
  •  Lack of Fit
  •  Effect of terms hypothesis test
  •  Effect leverage plot
  •  Effect means
  •  Plotting main effects and interactions
  •  Multiple comparisons
  •  Multiple comparison procedures
  •  Comparing effect means
  •  Residual plot
  •  Residuals - normality
  •  Residuals - independence
  •  Plotting residuals
  •  Outlier and influence plot
  •  Identifying outliers and other influential points
  •  Prediction
  •  Making predictions
  •  Making inverse predictions
  •  Saving variables
  •  Logistic / Probit fit
  •  Study design
  •  Method comparison / Agreement
  •  Measurement systems analysis (MSA)
  •  Reference interval
  •  Diagnostic performance
  •  Survival/Reliability
  •  Control charts
  •  Process capability
  •  Pareto analysis
  •  Study Designs
  •  Bibliography



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.