help on averaging function
Dave,
Which one of the similar sample average deems to fit the OP,,timewise...?
just curious really!
--
regards,
driller
*****
- dive with Jonathan Seagull
"Dave Thomas" wrote:
To extend your example:
Month 1. $200 Loss
Month 2. $100 Loss
Month 3. $0 Broke even
Month 4. $200 Profit
Month 5. $400 Profit.
Average Profit (including 0), $60, (excluding 0), $75.
"MartinW" wrote in message
...
Actually, yes I am assuming that. In practical terms, it wouldn't make
sense to average both positive and negative numbers and omit zero.
Hi Chip,
Where would zero come into the following?
1st Month: $100 loss
2nd Month: $100 loss
3rd Month: $500 profit
3 monthly average profit would be $100 profit.
Regards
Martin
|