Back to resources

Using Excel for statistics: Short videos on scatter diagrams, trend lines and correlation

These short videos demonstrate useful techniques for using Excel for statistics in GCSE and A level Mathematics, including the large data sets. Most are less than 5 minutes in length.

These videos use the Car fuel and emissions data set

The data set used in the videos is not related to any exam specification; it has been chosen to illustrate the techniques.

  • video icon

    Adding a trend line to a scatter diagram in Excel

  • video icon

    Drawing a scatter diagram in Excel

  • video icon

    Calculating a correlation coefficient in Excel

Related resources

Popular

MEI Conference 2025 Session Resources

Can you ‘control minds’ and make people do what you want – or does the maths help you?
Popular

Ritangle 2024

Questions and answers from our Ritangle 2024 competition

Proving the Pythagorean Theorem

Explore the Pythagorean Theorem in ancient texts in order to better appreciate how maths has developed in a range of diverse cultures.

Maths games from around the world

Appreciate maths from other cultures by exploring games with a focus on problem-solving and strategy.
Skip to content