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

Fitting an advanced linear model

Fit an advanced linear model to describe the relationship between many predictor variables and a response variable.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Fit Model, and then click Advanced.
    The analysis task pane opens.
  3. In the Y drop-down list, select the response variable.
  4. In the Available variables list, select the predictor variable(s):
    • To select a single variable, click the variable.
    • To select multiple variables, click the first variable then hold down the CTRL key and click each additional variable.
    • To select a range of variables, click the first variable then hold down the SHIFT key and click the last variable in the range.
  5. Optional: Click the drop-down menu arrow next to the Available variables list, and then select the measurement scale of the variable.

    If the measurement scale is not set, Analyse-it tries to determine if the variable is categorical or continuous scale. After you add a variable to a model, the icon alongside the variable indicates the assumed scale.

  6. Click Add to add a variable, or click Factorial to add the factorial terms, or click Polynomial to add a polynomial terms.
  7. To add the interaction between two or more variables, in the Terms list box, click the first term then hold down the CTRL key and click each additional term to include in the interaction, and then click Cross.
  8. To remove a term, in the Terms list box, click the term and then click Remove.
  9. Repeat steps 4 through 8 to build the model.
  10. Optional: To assign a weight to each row for the analysis, in the Weight drop-down list, select the weight variable.
  11. Click Calculate.
Related concepts
Summary of fit
Parameter estimates
Effect of model hypothesis test
Effect of terms hypothesis test
Related tasks
Plotting residuals
Identifying outliers and other influential points
Plotting main effects and interactions
Comparing effect means
Making predictions
Saving variables
Related reference
Dataset layout
Advanced models
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.