Exponential trendline equation, Numbers version 12.2.1
The trendline equation only shows "y=0" for an exponential fit. Linear fits work fine. What is wrong?
iMac (24-inch, M1, 2021, 2 ports)
The trendline equation only shows "y=0" for an exponential fit. Linear fits work fine. What is wrong?
iMac (24-inch, M1, 2021, 2 ports)
With data similar to yours I get the same result. Given that it came up with a trendline, it should have provided the formula that goes with it. With my rough data I get a trendline of y=1.75E-27*e^(0.032*x). Yours would be similar. While it is a very small number multiplied by a very large number, neither one is near any limits of computing. Works fine in Excel. Looks like a bug. Use the menu item Numbers->Provide Numbers Feedback to report it.
If you need the trendline equation, it can be calculated in the table without too much trouble.
With data similar to yours I get the same result. Given that it came up with a trendline, it should have provided the formula that goes with it. With my rough data I get a trendline of y=1.75E-27*e^(0.032*x). Yours would be similar. While it is a very small number multiplied by a very large number, neither one is near any limits of computing. Works fine in Excel. Looks like a bug. Use the menu item Numbers->Provide Numbers Feedback to report it.
If you need the trendline equation, it can be calculated in the table without too much trouble.
It's hard to know what is "wrong" without some details on what you are doing. Can you post a screenshot?
SG
b (cell D2) =SLOPE(C,A)
a (cell D3) =EXP(INTERCEPT(C,A))
y=a*e^(bx)
Sure, here's a screen shot. Upper left shows "y=0" where the trendline equation is supposed to me. Linear fits post the trendline equation properly, but not for exponential fits like in this example, the consumer price index since 1928. Thanks for taking a look.
Exponential trendline equation, Numbers version 12.2.1