Statistical Analysis & Data Training Course

This Statistical Analysis  and Data Training Course is aimed at beginners in the field of Data Science. It is a Data Training Course designed to give you a foundation in the subject of Data Science, and focusses on core methods of summarising data.

In this Data Training Course (Making Sense of Data – DS101), you will learn how to use Excel to summarise data effectively, which helps make “raw” data comprehensible. You will learn the skills required to use Excel formulas to gain insight into data by using various summary statistics.

Summarising data is a key skill and the foundation for more complicated methods of Statistical Analysis. This Statistical Analysis Course makes a good stepping-stone to more advanced Data Training Courses. You’ll learn key skills in summarising data including:

• Data Layout – how to arrange and manage your data using data tables and Pivot Tables.
• Averages – measures of central tendency, such as mean, median and mode.
• Dispersion – measures of the spread of data, such as standard deviation, confidence intervals, quartiles and standard error.
• Shape – the distribution or “shape” of data, such as skewness, kurtosis, histogram and tally plot.

This Statistical Analysis Course will give you the core skills you need for data summary.

Making Sense of Data is an important skill. Our modern world is a complicated place, and we are bombarded by data at every turn. The first step to understanding and making sense of data is being able to summarise data.

In this training course (Making Sense of Data – DS101) you will learn to use Excel to summarise data. You will learn the skills you need to take “raw” data and summarise them effectively, thus making the data more readily comprehensible. Understanding how to summarise data is an important step in the process of data analysis, and underpins all statistics tests. Summarising data is also helpful in the graphical presentation of data.

Making Sense of Data is the starting point for any journey into Data Analysis. You’ll learn core skills in both Data Science and in using Excel, such as:

• How to arrange your data.
  • How to use data tables.
  • How to use Pivot Tables.
• How to use Excel formulas to summarise data.
• How to use Excel to draw a histogram.
• Which summary statistics are most appropriate for your data.

This training course makes a good foundation for the study of Data Science, regardless of your field of study or enterprise.

In this training course you will be using Microsoft Excel spreadsheet software (any reasonably up to date version). Using Excel for Data Analysis makes a good introduction to Data Science, as Excel is a familiar and widely available computer program.

Using Excel for Statistics is an excellent starting point for learning about Data Science, as Excel has a wide range of built-in tools that can help with summarising data. Being able to summarise data is fundamental to all forms of Data Exploration and data analysis. In this training course you will be using Excel for Data Analysis and learning the skills you need to make data more comprehensible.

In this training course you will learn about using Excel for Data Analysis by accessing the various formulas and tools that allow you to summarise data. You’ll learn how to arrange and manage data, and to use data table and Pivot Table tools. You will learn about using Excel for statistics such as mean, median, skewness, kurtosis, confidence intervals and others. You will also learn how to create histograms and tally plots to help visualise the distribution of your data.

This Statistics Course is an introduction to data science. You’ll learn how to make numbers comprehensible. This is the starting point to more complicated data analysis; being able to summarise data allows you to start the process of data mining and exploration of patterns and trends. In this Data Course you’ll also learn how to use your spreadsheet program to help you explore and make sense of data by working through example datasets.

This Data Course is suitable for anyone who needs to learn about numbers and how to make sense of them.

In this Statistics Course (Making Sense of Data – DS101) you’ll be using Excel to learn a range of topics:

• How to layout and arrange your data.
  • How to use Data Tables.
  • How to use Pivot Tables.
• How to summarize data samples.
  • What is required to make sense of data!
• Averages and how to calculate them.
  • The different kinds of measure of centrality.
  • The arithmetic mean.
  • The median.
  • The mode.
• Variability in data and how to quantify it.
  • The different measures of data dispersion.
  • Standard deviation.
  • Standard Error.
• Visualising the shape of data.
  • Why data distribution is important.
  • The properties of the normal distribution.
  • Skewness and Kurtosis.
  • How to draw histograms.

No prior knowledge is assumed; this Statistics Course is aimed at beginners.

You’ll simply need a computer and Excel spreadsheet software. Online courses are delivered using the Zoom software, which is available for Windows or Macintosh computers. Support material is supplied online, usually via Google Classroom.

The duration of this Statistical Analysis Course is one day (starting at 9.30am and ending around 4.30pm).

Since COVID-19 online courses have been more popular. All our data training courses are available online, which means we can be flexible about dates. We can also arrange training at our main training centre in London, or at your workplace. At the moment there are no set dates for courses but you can Check dates here  to see details of forthcoming events.

Our main training centre is at 107, Cheapside, London EC2V 6DN. This is right in the heart of London and is close to Bank and St. Paul’s underground stations.

The Making Sense of Data course (DS101) is part of a suite of training courses aimed at beginners in data science. See also:

• Basic Hypothesis Testing using Excel (DS102) – Learn some of the basic hypothesis tests that underpin data analysis.
• Data Visualisation using Excel (DS103) – Learn how to visualise your data and results to best effect.