15.2 - Averages, Index Numbers & Rearranging Formulas
Measures of central tendency - Mean, median, and mode
Measures of central tendency summarise a data set by identifying a typical or central value. These include the mean, median, and mode, each providing different insights into the data.
Mean
The mean is calculated by summing all values in a data set and dividing by the number of values.
For example, if 5 workers complete tasks in 4, 7, 2, 6, and 8 hours, the mean time is (4 + 7 + 2 + 6 + 8) ÷ 5 = 27 ÷ 5 = 5.4 hours.
Median
The median is the middle value when data is arranged in ascending order. If there is an even number of values, it is the average of the two middle ones.
For instance, a delivery firm might order package weights as 1 kg, 2 kg, 3 kg, 5 kg, and 8 kg. The median is 3 kg, helping to identify typical weights for planning.
Mode
The mode is the value that appears most frequently in a data set.
A shoe shop, for example, might find that size 7 is the modal size sold, prompting them to stock more of this size to meet customer demand.
Measure of dispersion - Range
The range measures the spread of data by calculating the difference between the highest and lowest values. It is often used with measures of central tendency to give a fuller picture of variation.
While not an average, it highlights data variability. For example, if sales figures range from £200 to £800, the range is £600, indicating significant fluctuation.
Confidence intervals
A confidence interval provides a range around an estimated value to indicate the level of uncertainty. It shows how reliable the estimate is, often at a specified confidence level like 95%.
For example, a restaurant chain might estimate 3200 customers for a promotion, with a 95% confidence interval of 2900 to 3500, meaning they are 95% sure the actual number will fall within this range.
Index numbers and their calculation
Index numbers simplify the tracking of changes in data, such as revenue or profits, over time by expressing values as percentages relative to a base year.
Purpose and advantages of index numbers
Index numbers highlight percentage changes, making trends easy to spot. The base year is set at 100, and subsequent years are compared to it. This approach helps businesses quickly identify growth or decline patterns.
Formula for calculating an index number
Where:
- Current year value = The figure for the year being indexed (£)
- Base year value = The figure for the chosen base year (£)
Worked example - Calculating index numbers
A retail business has annual profits of £35,000 in the base year (year 1), £38,500 in year 2, and £42,000 in year 3. Calculate the index numbers for years 2 and 3.
Step 1: Identify the values
- Base year profit (year 1) = £35,000
- Year 2 profit = £38,500
- Year 3 profit = £42,000
Step 2: Calculate index for year 2
Step 3: Calculate index for year 3
Step 4: Interpretation
The index shows a 10% increase by year 2 and a 20% increase by year 3 compared to the base year.
Rearranging formulas in break-even analysis
Formulas in break-even analysis can be rearranged to solve for different variables, such as selling price. This helps businesses set prices or determine costs to achieve break-even.
Contribution per unit formula
Where:
- Contribution per unit = Amount each unit contributes to fixed costs (£)
- Selling price per unit = Price per item sold (£)
- Variable costs per unit = Costs varying with output (£)
Rearranged to find selling price:
Break-even output formula
Where:
- Break-even output = Units needed to cover costs
- Fixed costs = Costs unchanged by output (£)
- Contribution per unit = As defined above (£)
Rearranged to find contribution per unit:
Combined formula for selling price
This combines the rearranged formulas to calculate the required selling price for a target break-even point.
Worked example - Calculating selling price using rearranged formulas
A business has fixed costs of £15,000 and variable costs of £2.50 per item. They aim to break even after selling 5,000 items. Calculate the required selling price per item.
Step 1: Identify the values
- Fixed costs = £15,000
- Variable costs per unit = £2.50
- Break-even output = 5,000 units
Step 2: Calculate contribution per unit
Step 3: Calculate selling price per unit
Step 4: Interpretation
The business needs to sell each item for £5.50 to break even at 5,000 units.