hello everyone,
I have a problem solving my trendline equation where our teacher told us to do it manually by substituting the value of x to get y. The trendline has a polynomial type line where the equation has E's..I tried to use growth and trend but seems it doesn't work..or maybe there are some tricks that i don't know yet.Here's the data:
Discharge Depth Top Width Ave velocity

m3/s m m m/s
100 2.45 141.0 0.29
300 2.99 143.9 0.70
500 3.42 146.0 1.00
750 3.84 148.0 1.32
1000 4.20 149.8 1.59
2000 5.25 155.1 2.46
3000 6.17 159.8 3.04


I want to get the depth and velocity @ 40m3/s.. I got 2.85 at depth which I think it doesn't make sense using growth..please help me.