ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Averaging None consistant data (https://www.excelbanter.com/excel-discussion-misc-queries/187452-averaging-none-consistant-data.html)

Tom Red

Averaging None consistant data
 
Is anyone aware of a method to produce averages from non consistant data.
The data Im currently looking at has returned values at anytime of day if a
certain cirteria was met. Because of this, there is no consistency in the
data and I cannot easily produce hourly averages without some form of
interpolation. I have looked at possibly using moving averages, but Im
unsure how to extract the average line for analysis.

Any ideas?
--
123


All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com