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)

Posted on Jan 7, 2023 8:41 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 7, 2023 2:10 PM

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.


4 replies
Question marked as Top-ranking reply

Jan 7, 2023 2:10 PM in response to jdoyle78

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.


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Exponential trendline equation, Numbers version 12.2.1

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.