So I have a chart that I have created in Numbers, with a trendline using a polynomial function, and I've got it to display the formula, but I cannot for the life of me, figure out what
x value I'm supposed to use to get the resulting
x is a date / time, so clearly it must be something related to the date value. But I've tried using ms since the unix epoch, secs since the unix epoch, etc. each to no avail. Some "other" spreadsheet tools make it clear how they convert dates into numbers when creating polynomial trendlines, Numbers however, does not.
Does anyone know what the hell value I am supposed to use!?
For those that might not be able to read the graph easily, an
x value of 01/01/2019 00:00:00 should give a
y value of 1,000~.