Re: Rate of increase/decrease for a set of values

From: "(dot)(dot)(dot)tharas" <tharasp(at)gmail(dot)com>
To: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Rate of increase/decrease for a set of values
Date: 2009-07-19 03:07:02
Message-ID: 82d9696a0907182007r648b79f0q84c3cf73a96bedd3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

Thanks Jasen Betts. Did you mean the difference between the maximum and
minimum of number of registrations divided by the time interval? If I got
the following number of registrations in a week as

*Survey Date NoOfFeverCaseRegistrations
12/07/09 30
13/07/09 70
14/07/09 20
15/07/09 90
16/07/09 40
17/07/09 50
18/07/09 20*

Although the survey does not indicate a steady increase of fever cases
during this week, there is a tremendous increase on dates 13/07/09 and
15/07/09. Considering the whole week, I feel I should say there is an
unusual increase in number of case registrations. How I can I do this. Can I
use any statistical deviation measure for this? Have a great day. Thanks.

On Sat, Jul 18, 2009 at 7:41 PM, Jasen Betts <jasen(at)xnet(dot)co(dot)nz> wrote:

> On 2009-07-14, thara <tharas(at)cdactvm(dot)in> wrote:
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_01DB_01CA048E.D3744500
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > Hello all,
> >
> > I have a table with two columns - one for survey date and the other one =
> > for the number of fever cases registered on that date. Now, I would like
> =
> > to know the overall rate of increase/decrease in the fever cases =
> > registered in a particular interval (say, between two dates). Which =
> > statistical measure I can use for computing this.
>
> the difference divided by the time elapsed?
>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

--
.regards
.thara s pillai

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message tgs 2009-07-19 06:12:25 trouble connecting to DB
Previous Message Jasen Betts 2009-07-18 14:43:09 Re: Selecting time periods