• 544K Members
• 6,077 Online
• 648K Conversations

Highlighted
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
Highlighted

# 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.

Highlighted

# 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.

Highlighted

# 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
History and Data
rosenbloomsnka in Microsoft To Do on
0 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies