Hello,
I am modelling the length of the growth season for 120 different years based on estimated daily temperature. The temperature is estimated from a periodic function: f(x)=D+A*sin(B(x+C), where the constants B and C are the same every year and A and D varies.
So I would like to know when the area under each function equals 1200 as shown in the figure. I think it can be solved by finding the upper limit b in equation 1 when the lower limit a is known. For the year 1990 it would look like equation 2, and b will take a value between a and 365. Do you know how I can calculate this using Excel?
Thanks in advance,