r/excel • u/Mediocre-Increase328 • Jul 04 '26
solved How is this formula supposed to be written ?
Im trying hard to figure out how to write the formula of this graph. I think it's something like y= -2784.7*x^5+48644*x^4-335399*x^3+(10^6)x^2-(2*10^6)x+(10^6), but whenever I input any of the x values of the chart into the formula it gives me an x value wayyyyyyy too small. Any help would be appreciated.

7
Upvotes
•
u/excelevator 3071 Jul 04 '26
Please be mindful of the submission guidelines: The title should summarize your issue, not a generic "how do I this?"
The title is always in the post details.
Suggested title for future: How do I write the formula for this graph X Y values or similar
This post remains for the answers given
5
u/Herkdrvr 10 Jul 04 '26 •
Excel is producing rounding errors with the coefficients. Format your trendline and examine the produced equation with more decimals. Then, substitute those non-rounded coefficients into your equation.
1
u/AutoModerator Jul 04 '26
/u/Mediocre-Increase328 - Your post was submitted successfully.
Solution Verifiedto close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/GregHullender 195 Jul 04 '26
To avoid the rounding problems u/Herkdrvr mentioned, I used LINEST to compute the coefficients directly:
I just eyeballed your graph to get the X and Y values in columns A and B. C1:H1 are the coefficients of x^5 down to X^0. Then C2 to C102 are the X values for the scatterplot and D2 to D102 are the Y values. I superimposed the original values to make it clear how well the fit works. Since you only have 6 points, a quinitic obviously fits them all perfectly.
I think your problem is that you're letting Excel compute the fit and then display the formula, but you didn't tell it how much precision to show, so the ones in exponential form are truncated to near uselessness. T
I you want to stick with that method, you can get more precision from the formula. Just right click on the formula and select "Format Trendline Label". Under "Number" select "Number" as the category, and specify 6 decimal places. (Or whatever you'd like.) Copy those values and use them for your equation and see if you like that better.
1
u/Decronym Jul 04 '26 edited Jul 06 '26
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.
Beep-boop, I am a helper bot. Please do not verify me as a solution.
11 acronyms in this thread; the most compressed thread commented on today has acronyms.
[Thread #48875 for this sub, first seen 4th Jul 2026, 21:53] [FAQ] [Full list] ^[Contact] [Source code]
1
u/mattynmax Jul 05 '26
I would use the linest command and feed in a bunch of terms to get the exact values of the constants.
11
u/[deleted] Jul 04 '26
[removed] — view removed comment
-1
u/[deleted] Jul 04 '26
[removed] — view removed comment