Trend Calculation?

I store 3-4 months worth of accuracy values in a table. I would like to be
able to display the information as a rolling average, which I can, but also
show the trend. Any ideas would be appreciatted as at the moment I am stumped.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Dear Rob:

As far as I know, the term "trend" is not a specific mathematical or
business term that would indicate exactly what you want. Is it a
difference, a difference expressed as a percent change, or what? If based
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10300-trend-calculation.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10300
on a difference, is it a difference between successive values, or from a
baseline?

Please explain, give some source data, and the results that should be
produced. Perhaps then someone can offer you some assistance.

Tom Ellison


"AirgasRob" wrote in message
news:5A213648-B840-481A-BE60-AF673BD27962@microsoft.com...
>I store 3-4 months worth of accuracy values in a table. I would like to be
> able to display the information as a rolling average, which I can, but
> also
> show the trend. Any ideas would be appreciatted as at the moment I am
> stumped.

AirgasRob wrote:
> I store 3-4 months worth of accuracy values in a table. I would like to be
> able to display the information as a rolling average, which I can, but also
> show the trend. Any ideas would be appreciatted as at the moment I am stumped.

See if:

http://groups.google.com/group/comp....f7af5f9a498f39
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10300
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10300

is what you have in mind.

James A. Fortune
MPAPoster@FortuneJames.com

I'm sure I will have lots of questions but this should keep me busy for most
of the day...thank you very much!

Tom what I am trying to do is show the user if their accuracy is increasing
or decreasing over time without having to show them all the results of each
month.

"James A. Fortune" wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10300
> AirgasRob wrote:
> > I store 3-4 months worth of accuracy values in a table. I would like to be
> > able to display the information as a rolling average, which I can, but also
> > show the trend. Any ideas would be appreciatted as at the moment I am stumped.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10300
>
> See if:
>
> http://groups.google.com/group/comp....f7af5f9a498f39
>
> is what you have in mind.
>
> James A. Fortune
> MPAPoster@FortuneJames.com
>