Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • Tutorials

Simple linear regression tutorial

Learn how to fit a simple regression model, check the assumptions of the ordinary least squares linear regression method, and make predictions using the fitted model.

On March 1, 1984 the Wall Street Journal published data on the advertising spend and yield for a number of commercial TV adverts. The advertisements were selected by an annual survey conducted by Video Board Tests, Inc., a New York ad-testing company, based on interviews with 20,000 adults who were asked to name the most outstanding TV commercial they had seen, noticed, and liked. The retained impressions were based on a survey of 4,000 adults, in which regular product users were asked to cite a commercial they had seen for that product category in the past week. Of interest is fitting a model to describe the relationship, and making predictions using the model. For more information see DASL Story: TV Advertising Yields.

In this tutorial you will perform the following tasks:

  1. Plotting bivariate data
    Create a scatter plot of the relationship between the variables.
  2. Fitting a simple regression model
    Fit a polynomial regression model to describe the relationship.
  3. Checking the assumptions of the regression model
    Check the assumptions and robustness of the model.
  4. Changing the regression fit
    Change the model to a logarithmic regression to better describe the relationship.
  5. Making predictions
    Estimate the average retained impressions given a $100 million spend.

  •  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.