Forum Discussion
Averaging data
hello, I am new in this forum. I want to average every 143 cell from a raw data which has around 300000 cells. Is any way to do it without writting the command every 143 cells? Thank you for yo...
If you actually want to average every day then insert a pivot table.
"Date and Tme" in rows area.
Group "Date and Tme" into days, months and years.
"Average Wind Speed, m/s" into values area.
Change the field settings to "Average".
The problem with your data is that your first day only hast 123 values.
And there are more days with number of values different from 144.