Calculating averages in business data

Averages help businesses analyse data sets to make informed decisions, such as evaluating performance or planning resources. Different types of averages provide insights into central tendencies and data spread.

Mean

The mean gives an overall average by considering all values in a data set.

$\text{Mean}=\frac{\text{sum of all values}}{\text{number of values}}$

For example, a retailer might calculate the mean daily sales over a week to assess average performance.

Median

The median identifies the middle value in an ordered data set, which is useful for understanding typical performance without extreme values skewing results.

To find the median:

1. Arrange the data in ascending order.
2. If there is an odd number of values, the median is the middle one.
3. If there is an even number, the median is the mean of the two middle values.

For instance, a logistics firm could rank delivery times and use the median to target improvements for slower routes.

Mode

The mode highlights the most frequent value in a data set, helping businesses focus on common patterns.

To find the mode:

• Count the frequency of each value.
• The value with the highest frequency is the mode (there may be more than one if frequencies tie).

A supermarket chain might use the mode to determine the most popular product size for stocking decisions.

Range

The range measures the spread of data, showing variation between extremes. It is not an average but complements them by indicating data consistency.

$\text{Range}=\text{largest value}-\text{smallest value}$

Businesses often pair the range with averages to assess data reliability, such as evaluating the variability in employee productivity scores.

Worked example - Calculating mean, median, mode and range

A small business records weekly sales figures (£) over six weeks: 750; 1,000; 850; 1,000; 900; 600. Calculate the mean, median, mode and range.

Step 1: Identify the values

• Data set: 600, 750, 850, 900, 1,000, 1,000

Step 2: Calculate the mean

$\text{Mean}=\frac{600+750+850+900+\mathrm{1,000}+\mathrm{1,000}}{6}=\frac{\mathrm{5,100}}{6}=850$

Step 3: Determine the median

With six values (even number), median is the mean of the third and fourth: (850 + 900) / 2 = 875

Step 4: Identify the mode

1,000 appears twice (most frequent), so mode = 1,000

Step 5: Calculate the range

$\text{Range}=\mathrm{1,000}-600=400$

Understanding index numbers

Index numbers simplify the analysis of data changes over time by expressing values as percentages relative to a base point. They are commonly used in business to track metrics like sales or costs.

Calculating index numbers

$\text{Index number}=\frac{\text{current value}}{\text{base value}}\times 100$

Where:

• Current value = The value for the period being measured
• Base value = The value for the base year (set to 100)

The base year is typically the earliest or a reference year, allowing easy comparison of percentage changes.

Advantages of using index numbers

• Trend identification - They highlight patterns, such as rising profits, making it simpler to spot improvements or declines.
• Simplified comparisons - Converting data to percentages enables quick assessment across different time periods or business areas.
• Business applications - A restaurant might index monthly customer numbers to evaluate growth trends since opening.

Worked example - Calculating index numbers

A tech startup tracks annual revenue (£000s): Year 1: 200; Year 2: 240; Year 3: 280. Using Year 1 as the base year, calculate the index numbers for Years 2 and 3.

Step 1: Identify the values

• Base value (Year 1) = 200 (index = 100)
• Year 2 value = 240
• Year 3 value = 280

Step 2: Calculate index for Year 2

$\text{Index number}=\frac{240}{200}\times 100=120$

Step 3: Calculate index for Year 3

$\text{Index number}=\frac{280}{200}\times 100=140$

Step 4: Interpretation

The index shows a 20% increase from Year 1 to Year 2 and a 40% increase to Year 3, indicating steady revenue growth.

Key business formulas and how to rearrange them

Business formulas often need rearrangement to solve for different variables, such as finding selling prices or break-even points. This process involves isolating the desired variable through algebraic steps.

Basic formulas

Contribution per unit:

$\text{Contribution per unit}=\text{selling price}-\text{variable cost per unit}$

Break-even point:

$\text{Break-even point}=\frac{\text{total fixed costs}}{\text{contribution per unit}}$

Rearranged formulas

Selling price:

$\text{Selling price}=\text{contribution per unit}+\text{variable cost per unit}$

Contribution per unit from break-even:

$\text{Contribution per unit}=\frac{\text{total fixed costs}}{\text{break-even point}}$

Selling price using break-even:

$\text{Selling price}=\frac{\text{total fixed costs}}{\text{break-even point}}+\text{variable cost per unit}$

Steps for rearranging formulas

1. Identify the relevant formula.
2. Isolate the target variable using inverse operations (e.g., multiply to undo division).
3. Substitute known values.
4. Perform the calculation.

Worked example - Rearranging formulas for selling price

A company has total fixed costs of £20,000, variable cost per unit of £5, and a break-even point of 2,500 units. Calculate the required selling price per unit.

Step 1: Identify the values and formula

• Total fixed costs = £20,000
• Variable cost per unit = £5
• Break-even point = 2,500 units

Step 2: Calculate contribution per unit

$\text{Contribution per unit}=\frac{\text{total fixed costs}}{\text{break-even point}}$

$\text{Contribution per unit}=\frac{\pounds \mathrm{20,000}}{\mathrm{2,500}}=\pounds 8$

Step 3: Calculate selling price

$\text{Selling price}=\text{contribution per unit}+\text{variable cost per unit}$

$\text{Selling price}=\pounds 8+\pounds 5=\pounds 13$