Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

statistical function to show if a customer is making fewer orders?

Discussion in 'Information Technology' started by James, Jul 28, 2006.

  1. James

    James
    Expand Collapse
    Guest

    anyone know of a statistical function to show if a customer is making fewer
    orders as the years go by? i.e.
    CustomerName NumOfOrders2004 NumOfOrders2005 NumOfOrders2006
    StatGauge
    Customer1 100 50
    25 Something that shows it declining
    Customer2 50 75
    100 Something that shows it increasing
     
  2. Loading...


  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Would checking to see if the last increment (Year, Month) is less than the
    average do it for you?

    "James" wrote:

    > anyone know of a statistical function to show if a customer is making fewer
    > orders as the years go by? i.e.
    > CustomerName NumOfOrders2004 NumOfOrders2005 NumOfOrders2006
    > StatGauge
    > Customer1 100 50
    > 25 Something that shows it declining
    > Customer2 50 75
    > 100 Something that shows it increasing
    >
    >
    >
    >
     
  4. James

    James
    Expand Collapse
    Guest

    that's a very good idea. however, is there a way i can get a more accurate
    result of a gradual loss of all the years? would that be standard deviation?


    "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
    news:3C13244B-4AA1-4E50-A73D-4C4C6038CA5F@microsoft.com...
    > Would checking to see if the last increment (Year, Month) is less than the
    > average do it for you?
    >
    > "James" wrote:
    >
    >> anyone know of a statistical function to show if a customer is making
    >> fewer
    >> orders as the years go by? i.e.
    >> CustomerName NumOfOrders2004 NumOfOrders2005 NumOfOrders2006
    >> StatGauge
    >> Customer1 100 50
    >> 25 Something that shows it declining
    >> Customer2 50 75
    >> 100 Something that shows it increasing
    >>
    >>
    >>
    >>
     
  5. James A. Fortune

    James A. Fortune
    Expand Collapse
    Guest

    James wrote:
    > anyone know of a statistical function to show if a customer is making fewer
    > orders as the years go by? i.e.
    > CustomerName NumOfOrders2004 NumOfOrders2005 NumOfOrders2006
    > StatGauge
    > Customer1 100 50
    > 25 Something that shows it declining
    > Customer2 50 75
    > 100 Something that shows it increasing


    I hope KARL doesn't mind me butting in. Try the information at the
    following thread:

    http://groups.google.com/group/comp...9cf2a74193d/35f7af5f9a498f39#35f7af5f9a498f39

    James A. Fortune
    MPAPoster@FortuneJames.com
     

Share This Page