Calculating Future Price from the Past Numbers.

I have posted about makeing "Eye-level Predictions" in previous posts.
This time I have calculated falling price of certain mobile phone with graph.

My goal? Identify current price of mobile phone with little price reference online.

First graph was just taken from the net and shows falling price of random cell phone that may be somehow similar to falling prices of other mobile phones.

Next were spotted specifications of phone and below were prices of people commenting from 2007-2010. I took as data all prices and their dates of mention. Any price mentioned counted! Some people were selling, some wanted to say how expensive it was when they buy it, some how cheap did they get it.

Here is the graph generated from this data in spreadsheet software Gnumeric that generated graph from two colums containing dates and prices. 5 prices&times were only used and line was spine interpolated and increased pixel witdh to increase graph smothness.

Conclusion:As you might see "the big price fall" is in first year, price goes slowly down afterwards and maybe even stops falling afterwhile? Interesting, as tech grows there may be space for your pentium 166 again same time..

Diamond prices go up. There are less mines and more and more people buying. Safe or treasure map needed.

read:Eye level projection of how tall will be buildings