While comparing energy balance in a large scale eddy covariance time series data set using linear regression (Net radiaiton vs. sum of sensible and letent heat fluxes), I noticed that with time the energy balance is deteorating.
In this relation, the slope of the regression line is a measure of the energy balance closure.
Further, to compare the slope changes (energy balance closure changes with time), I took sub-samples of the data and developed regression relationships for them with the same intercept as in the origial equation (that is, with fixed intercept) to look at the slope changes with time.
Do you think this is a right way to look at slope changes in sub-samples of large datasets using the microsoft Excel?