Excel Percentage Averages
Closed
Twiggi
-
Aug 13, 2009 at 03:24 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 13, 2009 at 07:30 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 13, 2009 at 07:30 AM
Related:
- Excel Percentage Averages
- Excel date format dd.mm.yyyy - Guide
- Percentage to paisa calculator - Office Software Forum
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Screenshot in excel - Guide
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Aug 13, 2009 at 07:30 AM
Aug 13, 2009 at 07:30 AM
first 0/0 gives error. if here is no purchase and no recceipt that mean there is not transaction. that must be removed from the data base. So there are only three transactions.
secondly it is only what exactly you want average of percentages or do you want overall percentage. If it is former you can have your view. If it is second interpretation ratio of sums is better . there will be difference because
a1/b1+a2/b2+a3/b3 is not equal to (a1+a2+a3)/(b1+b2+b3)
in most cases ratio of the sums are used.
secondly it is only what exactly you want average of percentages or do you want overall percentage. If it is former you can have your view. If it is second interpretation ratio of sums is better . there will be difference because
a1/b1+a2/b2+a3/b3 is not equal to (a1+a2+a3)/(b1+b2+b3)
in most cases ratio of the sums are used.