3

For each year the given dataset contains the average price for the item sold, take this for example:

╔══════╦═══════════════╗
║ Year ║ Cost of flerg ║
╠══════╬═══════════════╣
║ 2007 ║            13 ║
║ 2008 ║             7 ║
║ 2009 ║             8 ║
║ 2010 ║             9 ║
║ 2011 ║            12 ║
║ 2012 ║            13 ║
║ 2013 ║             9 ║
║ 2014 ║            11 ║
║ 2015 ║            14 ║
╚══════╩═══════════════╝

Now I want to estimate how much it'll be worth in 2016, 2017, ...

I have looked at some linear regression functions, but they only produce a slope and intercept number for a graph.

So does anyone know of a way to go about this?

Jelle De Loecker
  • 20,999
  • 27
  • 100
  • 142

1 Answers1

0

You could try to fit a line through the points using the least squares method, which assumes you know the approximate law of the dataset distribution.

You could also try training a small perceptron or a neural network (depending on whether you think it is a linear distribution or not). However, this assumes you have a significant training set.

You could also try with a simple genetic algorithm to obtain an mathematical expression that tries to predict the next value based on the previous n. However, this has similar issues to the perceptron approach, as you may lack an adequate size of the training set.

Otherwise, it is probably impossible to predict the future elements without knowing more about the problem. If you know more about the problem, then you can use that information to model the predictor.

Igor Ševo
  • 5,459
  • 3
  • 35
  • 80