Achievable logoAchievable logo
CGMA BA1
Sign in
Sign up
Purchase
Textbook
Practice exams
Support
How it works
Exam catalog
Mountain with a flag at the peak
Textbook
Introduction
1. Goals and decisions of an organization
2. The market system
3. The domestic economy
4. Macroeconomics – The international economy
5. Macroeconomics – Index numbers
6. Introduction to the financial context of business entities
7. Foreign currencies
8. Investment appraisal
9. Summarizing and analyzing data
9.1 Introduction
9.2 Tabulating data and charts
9.3 Averaging data
9.4 Measure of spread
10. Inter-relationships between variables
11. Time series model
Wrapping up
Achievable logoAchievable logo
9.4 Measure of spread
CGMA BA1
9. Summarizing and analyzing data
Our CGMA course is currently in development and is a work-in-progress.

Measure of spread

3 min read
Font
Discuss
Share
Feedback

Range

Definitions
Range
Tells you how spread out a data set is by looking at the two extreme values. It’s the difference between the highest value and the lowest value.

Formula for ungrouped data as is follows:

Range=Highest value−Lowest value+1

Where data is grouped:

Upper interval limit−lowest interval limit

Standard deviation

Definitions
Standard deviation
Measures how far the data values typically lie from the mean. A larger standard deviation means the data is more spread out around the mean. A smaller standard deviation means the data is more tightly clustered around the mean.

The formula for standard deviation is:

Standard deviation=∑F∑FX2​−(∑F∑FX​)2​

Let’s use the previous data set. Notice that when the data is grouped into classes, the X values are the midpoints of the classes. If the data is not grouped into classes, then X is simply the value given.

Number of absent days Frequency
0 5
1 3
2 1
3 3
4 3
5 3
6 1
7 1
Grand total 20

To apply the standard deviation formula, we first calculate the supporting values shown in the table below.

Number of absent days (X) X​2 Frequency FX FX​2
0 0 5 0 0
1 1 3 3 3
2 4 1 2 4
3 9 3 9 27
4 16 3 12 48
5 25 3 15 75
6 36 1 6 36
7 49 1 7 49
Grand total 20 54 242

Final calculations:

20242​(2054​)212.1−7.294.81​​=12.1=7.29=4.81=2.19​

When you do standard deviation questions, make sure you follow the formula carefully and use the correct totals from your table. Remember: a smaller standard deviation means the data is less dispersed, so the mean is based on values that are closer together.

Coefficient of variation

Definitions
Coefficient of variation
Combines the mean and the standard deviation to help you compare the spread of two different data sets, especially when their means are not the same.

Comparing standard deviations directly can be misleading when the data sets are on different scales. For example, salaries in two companies may have different average levels. A company with higher salaries will often have a higher standard deviation simply because the numbers are larger. The coefficient of variation adjusts for this by measuring spread relative to the mean, making the comparison fairer.

A is a management accountant and he has been offered a position by 2 companies in country 7. The following are the average salaries for management accountants in both companies including the standard deviations. Calculate the coefficient of variation and indicate which company the accountant should choose based on your calculations?

Company Mean St deviation
KTA 100000 10000
SBA 120000 20000

Solution

(spoiler)

KTASBA​=100,00010,000​=0.1=120,00020,000​=0.17​

Company St deviation Mean Coefficient of variation
KTA 10000 100000 0.1
SBA 20000 120000 0.17

Based on our calculations, KTA has a lower spread ratio meaning the accountant should choose to accept a job offer from KTA.

Range

  • Measures data spread using extremes
  • Formula (ungrouped): Highest value − Lowest value + 1
  • Formula (grouped): Upper interval limit − Lowest interval limit

Standard deviation

  • Quantifies average distance from the mean
  • Larger value = data more spread out; smaller = more clustered
  • For grouped data, use class midpoints as X values
  • Calculation steps:
    • Compute FX and FX² totals
    • Use: (N∑FX2​)−(N∑FX​)2​
  • Smaller standard deviation = less dispersion

Coefficient of variation

  • Compares spread relative to the mean
  • Formula: Standard deviation ÷ Mean
  • Useful for comparing data sets with different scales
  • Lower coefficient = less relative variability, preferred option

Sign up for free to take 5 quiz questions on this topic

Previous
Next  | 10.1 Big data
All rights reserved ©2016 - 2026 Achievable, Inc.

Measure of spread

Range

Definitions
Range
Tells you how spread out a data set is by looking at the two extreme values. It’s the difference between the highest value and the lowest value.

Formula for ungrouped data as is follows:

Range=Highest value−Lowest value+1

Where data is grouped:

Upper interval limit−lowest interval limit

Standard deviation

Definitions
Standard deviation
Measures how far the data values typically lie from the mean. A larger standard deviation means the data is more spread out around the mean. A smaller standard deviation means the data is more tightly clustered around the mean.

The formula for standard deviation is:

Standard deviation=∑F∑FX2​−(∑F∑FX​)2​

Let’s use the previous data set. Notice that when the data is grouped into classes, the X values are the midpoints of the classes. If the data is not grouped into classes, then X is simply the value given.

Number of absent days Frequency
0 5
1 3
2 1
3 3
4 3
5 3
6 1
7 1
Grand total 20

To apply the standard deviation formula, we first calculate the supporting values shown in the table below.

Number of absent days (X) X​2 Frequency FX FX​2
0 0 5 0 0
1 1 3 3 3
2 4 1 2 4
3 9 3 9 27
4 16 3 12 48
5 25 3 15 75
6 36 1 6 36
7 49 1 7 49
Grand total 20 54 242

Final calculations:

20242​(2054​)212.1−7.294.81​​=12.1=7.29=4.81=2.19​

When you do standard deviation questions, make sure you follow the formula carefully and use the correct totals from your table. Remember: a smaller standard deviation means the data is less dispersed, so the mean is based on values that are closer together.

Coefficient of variation

Definitions
Coefficient of variation
Combines the mean and the standard deviation to help you compare the spread of two different data sets, especially when their means are not the same.

Comparing standard deviations directly can be misleading when the data sets are on different scales. For example, salaries in two companies may have different average levels. A company with higher salaries will often have a higher standard deviation simply because the numbers are larger. The coefficient of variation adjusts for this by measuring spread relative to the mean, making the comparison fairer.

A is a management accountant and he has been offered a position by 2 companies in country 7. The following are the average salaries for management accountants in both companies including the standard deviations. Calculate the coefficient of variation and indicate which company the accountant should choose based on your calculations?

Company Mean St deviation
KTA 100000 10000
SBA 120000 20000

Solution

(spoiler)

KTASBA​=100,00010,000​=0.1=120,00020,000​=0.17​

Company St deviation Mean Coefficient of variation
KTA 10000 100000 0.1
SBA 20000 120000 0.17

Based on our calculations, KTA has a lower spread ratio meaning the accountant should choose to accept a job offer from KTA.

Key points

Range

  • Measures data spread using extremes
  • Formula (ungrouped): Highest value − Lowest value + 1
  • Formula (grouped): Upper interval limit − Lowest interval limit

Standard deviation

  • Quantifies average distance from the mean
  • Larger value = data more spread out; smaller = more clustered
  • For grouped data, use class midpoints as X values
  • Calculation steps:
    • Compute FX and FX² totals
    • Use: (N∑FX2​)−(N∑FX​)2​
  • Smaller standard deviation = less dispersion

Coefficient of variation

  • Compares spread relative to the mean
  • Formula: Standard deviation ÷ Mean
  • Useful for comparing data sets with different scales
  • Lower coefficient = less relative variability, preferred option

More from Summarizing and analyzing data

  • Introduction
  • Tabulating data and charts
  • Averaging data