software

Hello,

Any recommendations for software used in charting composite moving
averages? Most of the software available involves tracking stock
values, and is too much for my needs . My interest is in forecasting
sales for a small business.

Any downloads available that can run on the MICROSFT WORKS SPREADSHEET
application?

Are there downloads available that can run independent of MS
spreadsheets?

Thank-yousocraticquest -

gt; Any recommendations for software used in charting composite moving
gt; averages? lt;

There are at least three ways using Excel: (1) create a chart, choose Add
Trendline, and select the Moving Average type, (2) use the Moving Average
tool of Excel's Analysis ToolPak, (3) use the AVERAGE worksheet function and
then create a Line chart.

- Mike
www.mikemiddleton.com
gt; Are there downloads available that can run independent of MS
gt; spreadsheets?
gt;
gt; Thank-you
gt;
The approximative spline extrapolation option of Rt-Plot might help you.
http:\\www.rt-science.com\rt-plot.html

Regards Horst
Horst Reichert wrote:
gt;gt;Are there downloads available that can run independent of MS
gt;gt;spreadsheets?
gt;gt;
gt;gt;Thank-you
gt;gt;
gt;
gt; The approximative spline extrapolation option of Rt-Plot might help you.
gt; http:\\www.rt-science.com\rt-plot.html
gt;
gt; Regards Horst
gt;
gt;
Why don't you calculate the moving average - with the lags depending on
your choice and not on the limited choices of the program - and chart it
with any decent spreadsheet, such as OpenOffice ?

Frank

gt; Why don't you calculate the moving average - with the lags depending on
gt; your choice and not on the limited choices of the program - and chart it
gt; with any decent spreadsheet, such as OpenOffice ?
gt;
gt; Frank
Please read my post.
I was recomending approximative spline, which is not a moving average.

Regards Horst
Horst Reichert wrote:
gt;gt;Why don't you calculate the moving average - with the lags depending on
gt;gt;your choice and not on the limited choices of the program - and chart it
gt;gt;with any decent spreadsheet, such as OpenOffice ?
gt;gt;
gt;gt;Frank
gt;
gt; Please read my post.
gt; I was recomending approximative spline, which is not a moving average.
gt;
gt; Regards Horst
gt;
gt;
The poster asked:
gt; Any recommendations for software used in charting composite moving
gt; averages? ...
gt;
Spline regression is of course a possible solution. I dont know how many
people have a working knowledge of this type of stats work.

gt; Any downloads available that can run on the MICROSFT WORKS SPREADSHEET
gt; application?
gt;
gt; Are there downloads available that can run independent of MS
gt; spreadsheets?

Yes, OpenOffice

Cheers,
Frank


socraticquest wrote:
gt; Hello,
gt;
gt; Any recommendations for software used in charting composite moving
gt; averages? Most of the software available involves tracking stock
gt; values, and is too much for my needs . My interest is in forecasting
gt; sales for a small business.
gt;
gt; Any downloads available that can run on the MICROSFT WORKS SPREADSHEET
gt; application?
gt;
gt; Are there downloads available that can run independent of MS
gt; spreadsheets?
gt;
gt; Thank-you

There is a piece of Freeware called FreeFore available from

www.autobox.com/freef.exe

which will optimize the moving average equation ...i.e. it will find
out how many

periods you should use and what the optimal weights are for each of
thise periods ...

This is also called BOX-JENKINS .

HTH

DAVE R
AFS CO
www.autobox.com
socraticquest wrote:
gt; Hello,
gt;
gt; Any recommendations for software used in charting composite moving
gt; averages? Most of the software available involves tracking stock
gt; values, and is too much for my needs . My interest is in forecasting
gt; sales for a small business.
gt;
gt; Any downloads available that can run on the MICROSFT WORKS SPREADSHEET
gt; application?
gt;
gt; Are there downloads available that can run independent of MS
gt; spreadsheets?
gt;
gt; Thank-you

Well, Excel can do it, and you can maybe get a price break as an
upgrade from Works?