How does a moving average reveal the underlying trend in sales data?

It smooths out fluctuations by calculating the mean of a set number of consecutive periods, removing short-term variations to show the general direction of sales over time.

State the formula for calculating a three-period moving average.

3-period MA = (Y₁ + Y₂ + Y₃) ÷ 3, where Y₁, Y₂, and Y₃ are three consecutive data points.

What does each term represent in the three-period moving average formula?

Y₁, Y₂, and Y₃ represent three consecutive data points (such as sales figures for three consecutive months or years), and dividing by three gives the average.

Calculate the three-period moving average when first period value = 490, second period value = 150, third period value = 180.

Three-period moving average = (490 + 150 + 180) ÷ 3 = 273.

State the formula for calculating a four-quarter moving average.

4-quarter MA = (Q₁ + Q₂ + Q₃ + Q₄) ÷ 4, where Q₁ to Q₄ are four consecutive quarterly data points.

When would a business use a four-quarter moving average rather than a three-period moving average?

When analysing quarterly sales data to smooth out seasonal variations that occur across the four quarters of a year.

Edexcel A-Level Business 9BS0

Meeting Customer Needs

Topic overview The market Market research Market positioning

The Market

Topic overview Demand Supply Markets Price elasticity of demand Income elasticity of demand

Marketing Mix and Strategy

Topic overview Product/service design Branding and promotion Pricing strategies Distribution Marketing strategy

Managing People

Topic overview Approaches to staffing Recruitment, selection and training Organisational design Motivation in theory and practice Leadership

Entrepreneurs and Leaders

Topic overview Role of an entrepreneur Entrepreneurial motives and characteristics Business objectives Forms of business Business choices Moving from entrepreneur to leader

Raising Finance

Topic overview Internal finance External finance Liability Planning

Financial Planning

Topic overview Sales forecasting Sales, revenue and costs Break-even Budgets

Managing Finance

Topic overview Profit Liquidity Business failure

Resource Management

Topic overview Production, productivity and efficiency Capacity utilisation Stock control Quality management

External Influences

Topic overview Economic influences Legislation The competitive environment

Business Objectives and Strategy

Topic overview Corporate objectives Theories of corporate strategy SWOT analysis Impact of external influences

Business Growth

Topic overview Growth Mergers and takeovers Organic growth Reasons for staying small

Decision-Making Techniques

Topic overview Quantitative sales forecasting Investment appraisal Decision trees Critical Path Analysis

Influences on Business Decisions

Topic overview Corporate influences Corporate culture Shareholders versus stakeholders Business ethics

Assessing Competitiveness

Topic overview Interpretation of financial statements Ratio analysis Human resources

Managing Change

Topic overview Causes and effects of change Key factors in change Scenario planning

Globalisation

Topic overview Growing economies International trade and business growth Factors contributing to increased globalisation Protectionism Trading blocs

Global Markets and Business Expansion

Topic overview Conditions that prompt trade Assessment of a country as a market Assessment of a country as a production location Reasons for global mergers or joint ventures Global competitiveness

Global Marketing

Topic overview Marketing Niche markets Cultural/social factors

Global Industries and Companies

Topic overview The impact of MNCs Ethics Controlling MNCs

Decision-Making Techniques

Quantitative sales forecasting

6 things to know
Paper 2 and Paper 3

Overview

Moving averages, scatter graphs and lines of best fit, extrapolation, and the limitations that come from relying on past data.

What you need to know

Answer each one before you reveal it.

Your recallNot started

Numbers

How is a three-period moving average calculated?

Process

What is extrapolation, what does it assume, and why does it become less reliable over time?

Evaluation

What limits a quantitative forecast?

Process

What types of qualitative factors do quantitative forecasting methods ignore?

Numbers

State the four-quarter moving-average formula.

Numbers

State the three-period moving-average formula.

Questions from this subtopic

Each one with the model answer underneath.

1
How does a moving average reveal the underlying trend in sales data?
Model answer
It smooths out fluctuations by calculating the mean of a set number of consecutive periods, removing short-term variations to show the general direction of sales over time.
2
State the formula for calculating a three-period moving average.
Model answer
3-period MA = (Y₁ + Y₂ + Y₃) ÷ 3, where Y₁, Y₂, and Y₃ are three consecutive data points.
3
What does each term represent in the three-period moving average formula?
Model answer
Y₁, Y₂, and Y₃ represent three consecutive data points (such as sales figures for three consecutive months or years), and dividing by three gives the average.
4
Calculate the three-period moving average when first period value = 490, second period value = 150, third period value = 180.
Model answer
Three-period moving average = (490 + 150 + 180) ÷ 3 = 273.
5
State the formula for calculating a four-quarter moving average.
Model answer
4-quarter MA = (Q₁ + Q₂ + Q₃ + Q₄) ÷ 4, where Q₁ to Q₄ are four consecutive quarterly data points.
6
When would a business use a four-quarter moving average rather than a three-period moving average?
Model answer
When analysing quarterly sales data to smooth out seasonal variations that occur across the four quarters of a year.

See the rest and revise

Other ways to work this

The same content, four other ways.

What is inside Levo

Six ways to work the same material.

1Closed book

2Open book

3Closed book

The 3-step method, run for you

Answer cold, learn it, then prove it stuck. Levo tracks the jump between your first attempt and your last.

Meeting Customer Needs

The Market

Marketing Mix and Strategy

Managing People

Cram a whole paper in one sitting

Sort every topic into what you know and what you do not, then drill only the weak ones.

Net gain = − initial cost.

EMVNPVARR

Blank Blitz makes facts automatic

Rapid timed gap-fills on the terms and numbers you need to recall without thinking.

AGross profit equals revenue minus cost of sales.

BOperating profit equals gross profit minus operating expenses.

CNet profit equals operating profit minus interest and taxation.

Build It gets the exam shape right

Assemble a full-mark answer from its marking points, in the order an examiner wants them.

Tariff means a tax imposed on imported goods.

TrueFalse

Test It catches misconceptions

Spot the fault in a statement. The traps are the mistakes students actually make.

721941163128510

Brain Breaks between sessions

Short focus games to reset attention, so the next set lands better than the last.

Every question in Decision-Making Techniques, on a schedule.

Attempt a question from memory, write the correct version, then attempt it again. Levo records the jump between your first attempt and your last, and brings each question back on the day you are due to forget it.

Start revising, £5 a month See how the method works

Or £46 a year, about £3.83 a month. Cancel anytime.