Analyze Google Analytics graphs

Let's see how to analyze google analytics graphs.
For easier recognizing of graph function, smoothen graph.
How to smoothen google analytics graphs and make it less bouncy?

Requrements:
google analytics account
gnumeric


First select graph you want to smoothen in your google analytics:

Export data with TSV (or CSV) and save it to hard drive. Open file with gnumeric (or other spreedsheet editor)

and select values (not dates):

 Numbers from google analytics and the same graph (only a bit stretched)

Insert chart and select area graph. This will generate similar graph as seen on Google Analytics.

To smoothen graph, smoothen its values. Click on Tools->Statistical Analysis->Forecast->Exponential smoothing. This takes some time.. Then generate graph from smoothen values. (values on the left on bottom picture)

Smoothen values and their graph (note:at the end of graph line falls, but it's just last day&bad forecasting function)

At the end of graph is also "forecast" but it was not generated successfully, as values wont decrease that much.

Conclusion on graphs. As seen on third graph, values are decreasing but also decreasing is decreasing (it's not falling in linear fashion).  This means that this website will get plenty of more traffic in next years.. And that was what what we looked for.