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

Plotting bivariate data

The scatter plot is a fundamental tool for looking at bivariate data. It shows the important characteristics of the data and can be used to decide what model may describe the relationship between the variables.

  1. Open the file tutorials\TV Ad Yield.xlsx.
  2. Click a cell in the dataset.
  3. On the Analyse-it ribbon tab, in the Dataset group, click Dataset.

    The dataset task pane is displayed.

  4. Select Labels in first column.
  5. Click Apply.

    The dataset task pane is closed.

  6. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Fit Model drop-down list, and then click Scatter.
    The analysis task pane opens.A scatter plot is added to the analysis task pane.
  7. In the Y variable list, select Retained impressions per week.
  8. In the X variable list, select Budget.
  9. Click Calculate.
    The results are calculated and the analysis report opens.

The scatter plot suggests the relationship between advertising yield and spend is not a straight line. It appears the yield increases sharply at lower spend and levels out as spending increases.

Next topic: Fitting a simple 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
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.