• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculating average(s) of top 25 % animals

A

AndrejLav

New Member
Hi
I am working with dairy cows. In a herd of 25 cows (7 are dry) I want to calculate the average(s) of milk yield for top 25 %, middle top 25%, middle bottom 25 % and bottom 25 % of cows. For each of these 4 groups I want to calculate also average milk fat and milk protein percentages, average urea and somatic cell contents and average days in milk and average parity. I was able to sort animals by milk yield using LARGE function and I was also able to link appropriate milk fat, protein, urea, somatic cell counts and parity and days in milk to the cows listed by LARGE function. But how to calculate these for four goroup remains unanswered. Both tables (raw and sorted) are in the appended file
Thanks for the tips in advance
Regards
Andrej
 

Attachments

Hi ,

From your data , which are the cows which are dry ? Are they cows 1 , 4 , 6 , 12 , 20 and 21 ? In which case there are only 6 dry cows , not 7.

Are these 6 cows to be excluded from all calculations ? If so , then we are left with 18 cows , since there are only 24 cows in all , not 25 ; what is the definition of 25 % ?

Can we take the top 4 , the next 5 , the next 5 and the bottom 4 ?

Narayan
 
NARAYANK991 said:
Hi ,

From your data , which are the cows which are dry ? Are they cows 1 , 4 , 6 , 12 , 20 and 21 ? In which case there are only 6 dry cows , not 7.

Are these 6 cows to be excluded from all calculations ? If so , then we are left with 18 cows , since there are only 24 cows in all , not 25 ; what is the definition of 25 % ?

Can we take the top 4 , the next 5 , the next 5 and the bottom 4 ?

Narayan
Click to expand...
Yes. The dry cows are 1,4,6, 12, 20 and 21. They are six indeed (my mistake). they should be excluded from calculations and we have thus 18 cow. I want a calculation of averages for four classes (top and bottom 25 % according to milk yield, two middle classes - top and bottom 4, and two times middle 5). However, the number of cows in lactationis not constant and will change on monthly basis.
 
You must log in or register to reply here.
Back
Top