Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Projections and growth.
Message
From
06/09/2002 08:40:05
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
03/09/2002 09:19:52
General information
Forum:
Microsoft Office
Category:
Excel
Miscellaneous
Thread ID:
00696171
Message ID:
00697437
Views:
17
>Greetings friends.
>In this occasion I wanted to consult yours, the following thing:
>I have a table with two columns. The first of them represents the months and the second represent the connections happened for that month.
>Does some way exist of carrying out a projection from those connections to 3,6 or 12 months?
>
>TIA.

Check statistical functions. The function which in Spanish is called ESTIMACION.LINEAL() will give you coefficient "m" of the line y = mx + b, for a series of data.

If you expect the growth to be by a certain factor each month (for instance, something like 10% increase per month - but you don't know the percentage yet), use ESTIMACION.LOGARITMICA() instead.

Saludos, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform