This unit introduces learners to key statistical and probabilistic methods used to explore and interpret data. Learners will develop practical skills in summarising data using descriptive statistics and understanding the role of probability in measuring uncertainty and supporting predictions.
For the full unit details, please download the latest version of the qualification specification. This is available for download on the relevant qualifications page.
Unit Learning Outcomes
To view the assessment criteria and any additional content, please expand the relevant learning outcome below.
1 — Be able to apply descriptive statistical techniques to summarise datasets.
Assessment Criteria
Explain the purpose of descriptive statistics. (AC 1.1):
Data simplification and organisation are achieved through summarisation, which condenses complex data into clear, concise overviews.
Effective data structuring, or organisation, highlights key features.
Description encompasses aspects of data distribution, concentration, and variability.
Demonstrate how to calculate key measures of central tendency (AC 1.2):
Measures of central tendency include the mean, median, and mode
Clarify the interpretation of measures of dispersion (AC 1.3):
Spread of data is characterised by range, variance, standard deviation, and interquartile range (IQR).
Describe common data distributions. (AC 1.4):
Distributions range from the bell-shaped normal distribution, where data lean towards the centre, to skewed distributions, where data lean towards one side, and to uniform distributions, where each value has an equal likelihood.
Evaluate their relevance in effectively summarising and analysing datasets. (AC 1.5):
Large datasets can be transformed into meaningful insights, highlighting significant trends and patterns for easier identification and interpretation.
The mean is a powerful averaging method, though susceptible to outliers.
The median provides a more robust central measure, particularly when dealing with extreme values.
The mode indicates the most frequent value, helping to understand data repetition.
The range provides a simple measure of the difference between the minimum and maximum values.
Variance and standard deviation offer deeper insights into the deviation of individual data points from the mean.
Finally, the interquartile range (IQR) provides a focused view of the central 50% of the data.
2 — Be able to apply descriptive statistical techniques using spreadsheets.
Assessment Criteria
Demonstrate and evaluate the application of descriptive statistical techniques using spreadsheets. (AC 2.1):
Excel
Techniques
Spreadsheet formulae such as =AVERAGE(range), =MEDIAN(range), =MODE(range), =MIN(range), =MAX , =QUARTILE.INC(range, 1), and =STDEV(range).
Calculations such as for range, using =MAX(range)-MIN(range) or for IQR using =QUARTILE.INC(range, 3)-QUARTILE.INC(range, 1)
Analyse and interpret business data to draw meaningful conclusions.(AC 2.2):
Mean gives you the average value of your dataset.
The median is the middle value when your data is ordered.
Mode identifies the most frequently occurring number in your data.
Minimum value is the lowest value in your dataset.
Maximum is the highest value.
Range is the difference between the highest and lowest values.
IQR (Interquartile Range) measures the spread of the middle 50% of your data.
Standard Deviation) gives a sense of how spread out your data is.
3 — Be able to apply probability concepts, rules, and distributions to conduct business analysis using spreadsheets.
Assessment Criteria
Describe probability concepts, types, and their relevance in data analytics (AC 3.1):
Theoretical Probability is based on known outcomes.
Experimental Probability relies on actual data.
Subjective Probability is shaped by personal judgment.
Apply fundamental probability rules to analytical scenarios (AC 3.2):
The Probability of an Event is calculated by dividing the favourable outcomes by the total outcomes.
Rules include the Complement Rule, Addition Rule, and Multiplication Rule.
Condition probability calculates the probability of an event occurring given that another event has already occurred.
Types of Probability Distributions include
Discrete Distributions, which involve countable outcomes.
These use the Probability Mass Function (PMF) or Cumulative Distribution Function (CDF).
Key examples include the Binomial and Poisson distributions. Continuous Distributions handle infinite outcomes.
They utilise Probability Density Functions (PDFs) and Cumulative Distribution Functions (CDFs), with the Normal distribution being a prominent example.
Use spreadsheets to apply probability techniques for business analysis (AC 3.4):
For calculating Mean, use =AVERAGE(range).
For calculating SD, use =STDEV(range).
For calculating probability, use =NORM.DIST(X, Mean, SD, TRUE).
Assess proficiency in using spreadsheets for independent probability-based data analysis (AC 3.5):
Probability is a powerful tool that measures how likely an event is to occur.
It quantifies uncertainty by giving us a value between 0 and 1, where 0 means impossible and 1 means certain.
Probability plays a crucial role in various areas, such as risk assessment, trend forecasting, analysing customer behaviour, and conducting A/B testing.
