Excel for Statistics

Some undergraduate courses and post graduate research require a basic understanding of Excel for stats.

Here's some information and resources to help get you started

Use this spreadsheet while attending statistics workshops.

Here are some useful videos to answer questions about descriptive statistics in Excel.

Introduction to Excel, part one This video covers setting up data for analysis, using excel formulae and descriptive statistics functions.
Introduction to Excel, part two (graphing) This video covers making a bar graph and scatterplots using the descriptive data performed in “Introduction to Excel, part one”.
An Introduction to using the AI data assisted analysis graph function in Excel
How to create a scatterplot graph in Excel
Introductory information on calculating some descriptive statistics in Excel
A brief introduction to running Student’s t-test in Excel
How to run a one-way Analysis of Variance (ANOVA) in Excel
How to run a ‘simple’ regression in Excel