Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • Tutorials
  • Simple linear regression tutorial

Fitting a simple regression model

After inspecting the scatter plot the next step is to fit a model to describe the relationship.

  1. On the Analyse-it ribbon tab, in the Fit group, click Fit > Polynomial 2 - Quadratic.

    A 2nd order polynomial fit task is added to the analysis task pane.

  2. On the Analyse-it ribbon tab, in the Model group, click Test Effect of Model.

    The Effect of Model task is added to the analysis task pane.

  3. Click Recalculate.
    The results are calculated and the analysis report opens.

The regression line on the scatter plot shows the relationship described by the model.

The effect of model table p-value of 0.0011 tells you that there is a statistically significant relationship between spend and yield.

effect of model table for regression fit

Next topic: Checking the assumptions of the regression 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
Products
  • Standard Edition
  • Medical Edition
  • Quality Control & Improvement Edition
  • Method Validation Edition
  • Ultimate Edition
  • Compare Editions
  • Pricing
Support
  • Documentation
  • Tutorials
  • Download latest version
  • Release history
  • Contact support
Company
  • About us
  • Blog
  • Contact us
  • Privacy policy

Get Started

  • Download free trial
  • Sign In

© 2026 Analyse-it® Software, Ltd. All rights reserved.

Statistical analysis and method validation software for Microsoft Excel.

We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.