Hi Guys,
I have a table with week 1 to 5.I have calculated the averages of week 1,2,3,4,5 separately in cells B3 to F3. And the average of the averages in cell A3 (value is 74.45).Avg.JPG
When I calculate the average of the entire cells separately its coming different (cell A5 value is 71.91).
Why this difference is coming.?
How can I overcome this.?
Regards,
Devpp
This is normal behaviour.
It's not good practice in general to "average averages" (unless each initial average will contain the same number of elements).
This is because your average of averages will give the same "weight" to an average of 2 values as to another average of 2000.
Calculating the average separately is the best way
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks