Statistical Analysis using Microsoft Excel Training in United Kingdom

  • Learn via: Classroom
  • Duration: 1 Day
  • Level: Intermediate
  • Price: From €1,625+VAT
We can host this training at your preferred location. Contact us!

Statistics involves collecting, analysing, interpreting, presenting, and organising data and provides methods for making inferences and conclusions about a population based on a sample of data.

Microsoft Excel offers various techniques and functions to calculate a single value or an array of values from the data in your Excel worksheets.

Whether you want to use the Excel Analysis ToolPak (an add-in that provides many statistical analysis tools) or formulas for statistical analysis, such as probability and distribution, this course will guide you through building and developing the various advanced statistical approaches needed.

We will use Microsoft Excel and various sample datasets to produce statistical results that can be used in reports and storytelling.

We will help you apply the topics covered in the course to your everyday activities through hands-on learning and structured workshops.

You will need a working knowledge of the following;

  • Understand how to write formulas using standard functions
  • Ideally, you should have attended:
    • Fundamentals of Statistics (QASTATFUND)
    • Microsoft Excel Intermediate (QAEXITMC)

At the end of the course, you’ll be able to:

  • Build probability formulas

  • Develop statistical distribution functionality

  • Apply inferential statistics to datasets

Module 1: Probability rules

  • Conditional Probability
  • Bayes’ Theorem
  • Random Variables

Module 2: Statistical Distributions

Normal

  • Bernoulli
  • Binomial
  • Poisson

Module 3: Inferential Statistics

  • Point Estimates
  • Hypothesis Testing
  • Confidence Levels

Module 4: Inference for Numerical Data

  • T-tests
  • ANOVA

Module 5: Inference for Categorical Data

  • Proportions
  • Chi-Square



Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our United Kingdom facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

09 January 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
16 January 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
09 January 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
16 January 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
24 February 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
24 February 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
24 April 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
24 April 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom

Related Trainings

Statistical Analysis using Microsoft Excel Training Course in the United Kingdom

The United Kingdom (Britain) is situated in north-western Europe. The UK is made up of England, Scotland, Wales and Northern Ireland. The United Kingdom is a constitutional monarchy with a unitary parliamentary democracy, as Queen Elizabeth II has been the monarch since 1952. The country's capital and largest metropolis is London.

The United Kingdom has always been one of the most popular tourist destinations in Europe. People from all around the world come to see the diverse scenery and rich cultural background of Britain. Some of the most popular places to visit in the UK are London (with Tower Bridge, River Thames, Big Ben, Parliament Buildings, Westminster Abbey…), Scotland's Capital Edinburgh, Roman-Era Bath, Stonehenge (one of the best-known prehistoric monument in Europe), Windsor Castle and Loch Ness.

Empower yourself with our extensive selection of IT courses, covering programming, data analytics, software development, business skills, cloud computing, cybersecurity, project management. Experience personalized training and expert guidance from our instructors, who will come to your chosen training venue anywhere in United Kingdom.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.