| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Profit Margin Trend
Hi, just to add to Toppers advice, if you have the analysis tool pack
add-in installed then you can use some of the tools included with it. Look in the tools menu for 'Data Analysis'. It has exponential smoothing and some other useful forecasting tools. If this forecasting is vital, that is worth some investment of time, you may want to look into something like double exponential smoothing. See the links below: Single Exponential Smoothing: http://www.itl.nist.gov/div898/handb...on4/pmc431.htm Double Exponential Smoothing: http://www.itl.nist.gov/div898/handb...on4/pmc433.htm HTH--Lonnie M. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i set up a profit margin formula | Excel Discussion (Misc queries) | |||
| Profit Margin | Excel Discussion (Misc queries) | |||
| Textbox margin overwritten by auto-margin | Excel Programming | |||
| gross profit margin formula | Excel Discussion (Misc queries) | |||
| Help: Profit margin | Excel Programming | |||
Threaded Mode
