How can I easily calculate daily and monthly solar radiation from experimental data given as in every 10-minutes interval of time or every hour?
consider day length 10 hours and data are given in W/m2
Can I directly implement the average function in Excel or is there some other way we can do it?