• 409K Members
• 10.2K Online
• 465K Conversations

New Contributor

# Projecting Data Figures - Years in Advance

Hello everyone!

I'm sailing into unchartered territory in Excel and am quite stumped and endless searching on the internet hasn't helped me too much to find the answer that I'm after.

I'm needing to project future year totals from the data I've been provided.

I've got figures of jobs per industry from years 2012/2013 and then in 2017/2018 which leads to a positive or negative change after 5 years.

I'd like to forecast what changes there'd be in another 5 or so years time but can't get my head around on how to do it exactly.

Any information would be very much appriected!

I've attached my excel spreadsheet with the relevant data that I'd like to project from.

3 Replies

# Re: Projecting Data Figures - Years in Advance

@Jamos7  A forecast based on only two data points from the past will be very, very vague.

One possibility would be to apply the same change percentage to the forecast value, i.e. if the change in the last 5 year period was -12%, apply that percentage to the latest value.

# Re: Projecting Data Figures - Years in Advance

Thanks for the reply @Ingeborg Hawighorst

Realised I've missed out some of the data!

Somehow I need to create a linear model that predicts the number of people employed (FTE Number) for future years based off business activity (Bus number - in the 2018 and 2017 columns).

If that makes any sense as I'm struggling to wrap my head around it with no 2017 data as to how many staff were employed per industry for that year.

# Re: Projecting Data Figures - Years in Advance

@Jamos7  As I said above, any forecast based on just two past data points will be very difficult, but if you don't even have two data points, then a crystal ball might be more help than Excel.

Sorry to be so blunt, but Excel is great at crunching numbers. It can do forecasts and predictions, too, but  it really needs data for that.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
17 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies