Thread: Rate of increase/decrease for a set of values
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.
Thanks all. Have a great day!
Thara.
Thara.
______________________________________ Scanned and protected by Email scanner
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?
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.
--
.regards
.thara s pillai
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>the difference divided by the time elapsed?
> 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.
--
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