Re: Rate of increase/decrease for a set of values - Mailing list pgsql-novice

From ...tharas
Subject Re: Rate of increase/decrease for a set of values
Date
Msg-id 82d9696a0907182007r648b79f0q84c3cf73a96bedd3@mail.gmail.com
Whole thread Raw
In response to Re: Rate of increase/decrease for a set of values  (Jasen Betts <jasen@xnet.co.nz>)
List 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@xnet.co.nz> wrote:
On 2009-07-14, thara <tharas@cdactvm.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice



--
.regards
.thara s pillai

pgsql-novice by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Selecting time periods
Next
From: "tgs"
Date:
Subject: trouble connecting to DB