I saw the formula above the question, but I can't understand in detail, any one can explain in detail above the formula along with how to analysis with statistical software example using EXCEL or any other software is there pls explain...
Thanking you...
Take the length in cm and weight in gm. Find the log values of both.Draw a scatter diagram and add the trend line . Find the extreme outliers and remove it. Then insert the trend line and get the regression equation. Simple excel you can do this
Hi Raghavan,
Here's a detailed account of a way to do it (I apologize for any statements of the obvious):
Once you've entered weight and length data into corresponding columns in Excel, you'll need to (natural) log transform the data.
In R you can transform the data and fit the regression model in one motion. The code would be "model
Dear Rahavan,
You make it length and weigh relationship analysis in Abee software like that Past. Two column will come that software One column length values you put and other column weight values you put automatically results will come. This is very simple and easy software. Please try..
Regards
K. Silambarasan
l
can you please give me or send me the Abee software for length weight calculation?m
y email is :[email protected]
The formula is so easy to understand and calculation is also very easy.Can you please tell where you are finding the difficulty to calculate it. Are you finding difficult to use Excel?
Thanks dear amit, But,how to remove outliers following the recommendations of Froese (2006) after calculating length weight relationship in ms-excel.
Take the length in cm and weight in gm. Find the log values of both.Draw a scatter diagram and add the trend line . Find the extreme outliers and remove it. Then insert the trend line and get the regression equation. Simple excel you can do this
For L-W relationship first of all you have to take same unit i.e. cm-gm. If you taken the length in mm and wt in gm, then first you convert it to cm. Then take log value of length and wt and do scatter diagram. If some value are more scattered then delete those values. After getting a(log l) and b value, covert a value to 10^a . Then you get actual a value. Then fit tge equation w=al^b. B= 3 indicayes isometric growth. Always do separate and pooled relationship of different sexes of the same species for more scientific result.
Plotting the data of length and then weight in the statistical software of ANOVA in MS-EXCEL or in SPSS 20 or in ezANOVA will solve your problem.
These links may help you
http://www.fishbase.de/manual/FishBaseThe_LENGTH_WEIGHT_Table.htm
https://www.pifsc.noaa.gov/library/pubs/admin/PIFSC_Admin_Rep_12-03.pdf
Article Length- weight relationships and condition factor of eight f...
Article Length–weight relationships for three freshwater fish specie...
Article Length-weight relationships for seven fish species from the ...
having the same issue, using minitab..
Could you please explain where did I get wrong?
I have the log data both for length +weight.
I ve done a regression analysis and obtained the coefficients.
I have the slope 2,706 and intercept 1,49 , then antilog the intercept 0,03.
I ve created a column for predicted length based on the length measurements. Now I would like to calculate the predicted weight using the antilog intercept K3*Length?^Coef2
i wold like to make a scatterplot and add a calculated line but.. its just not working.. :(
- Badges
- Science topic
- Similar topics
- Computer Science and Engineering
- Software