Home > Archive > PHP Programming > January 2007 > Calculating some formulas from database data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Calculating some formulas from database data
|
|
| chris_huh 2007-01-30, 6:59 pm |
| I am doing a project on beetle diversity and need to calculate a few
diversity indices for a load of data i have collected. I thought that
maybe i could make a program in php to do that for, and save a bit of
time (as well as prevent calculation errors). I imagine this could be
quite a bit of programming but i have dreamweaver to help me.
Now what i have is a MySQL database full of data on beetle diversity
with the following tables:
Date - the date the sample is from
Habitat - one of 9 habitats that i am testing between (ie. grass,
stones, birch woodland, etc)
Replica - ie 'Repeats', there were two replicas for each habitat from
each date (A and B)
Trap number - from each replica there were 6 traps
Species - the species of beetle that was found in the trap (of course
there are often more than one per trap)
Number of Individuals - the number of individuals of that species
found in that trap
What i need to do is calculate Shannon-Weiner, Shannon Equitability
and Margalefs Diversity indices for each replica from each date for
each habitat (the data for the individual traps will be merged
together).
I have an idea of how to do it but what i am stumbling at is how to
create a recordset which will calculate the total number of
individuals for that species from that replica, date & habitat (I) and
calculate the number of different species for that replica, date &
habitat (S). Once i have S and I i should be able to write the formula
in php to create the indices.
Ideally this could be done in a way to allow for each repeating areas
to be assigned so that all of the indices for that habitat (for each
date and replica) could be shown on one page (to save a lot of
clicking).
Anyone know of a good way of going about this, any help will be
greatly appreciated.
| |
| Captain Paralytic 2007-01-30, 6:59 pm |
|
On 30 Jan, 15:55, "chris_huh" <chris....@gmail.com> wrote:
> I am doing a project on beetle diversity and need to calculate a few
> diversity indices for a load of data i have collected. I thought that
> maybe i could make a program in php to do that for, and save a bit of
> time (as well as prevent calculation errors). I imagine this could be
> quite a bit of programming but i have dreamweaver to help me.
> Now what i have is a MySQL database full of data on beetle diversity
> with the following tables:
>
> Date - the date the sample is from
> Habitat - one of 9 habitats that i am testing between (ie. grass,
> stones, birch woodland, etc)
> Replica - ie 'Repeats', there were two replicas for each habitat from
> each date (A and B)
> Trap number - from each replica there were 6 traps
> Species - the species of beetle that was found in the trap (of course
> there are often more than one per trap)
> Number of Individuals - the number of individuals of that species
> found in that trap
>
> What i need to do is calculate Shannon-Weiner, Shannon Equitability
> and Margalefs Diversity indices for each replica from each date for
> each habitat (the data for the individual traps will be merged
> together).
> I have an idea of how to do it but what i am stumbling at is how to
> create a recordset which will calculate the total number of
> individuals for that species from that replica, date & habitat (I) and
> calculate the number of different species for that replica, date &
> habitat (S). Once i have S and I i should be able to write the formula
> in php to create the indices.
> Ideally this could be done in a way to allow for each repeating areas
> to be assigned so that all of the indices for that habitat (for each
> date and replica) could be shown on one page (to save a lot of
> clicking).
>
> Anyone know of a good way of going about this, any help will be
> greatly appreciated.
Please do NOT multi-post!
Cross-post if you must but DO NOT multi-post!
See: http://www.blakjak.demon.co.uk/mul_crss.htm
| |
| chris_huh 2007-01-30, 6:59 pm |
|
On 30 Jan, 16:17, "Captain Paralytic" <paul_laut...@yahoo.com> wrote:
> On 30 Jan, 15:55, "chris_huh" <chris....@gmail.com> wrote:
>
>
>
>
>
>
> Cross-post if you must but DO NOT multi-post!
>
> See:http://www.blakjak.demon.co.uk/mul_crss.htm
Sorry, i didnt see the cross-post text box until i had pressed submit
|
|
|
|
|