3

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 y value!

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~.

enter image description here

  • 4
    I'm voting to close this question as off-topic because it has nothing to do with Apple hardware or software . – IconDaemon Apr 12 '18 at 18:31
  • 1
    I see that you have this tagged under Numbers, but it's unclear if you are using Numbers to generate this graph. Could you rephrase your question in direct relation to Apple Numbers? – drivec Apr 12 '18 at 19:27
  • If your question is not related to Numbers but trend fitting in general, try Cross Validated. – Glorfindel Apr 13 '18 at 7:35
  • @IconDaemon my question relates directly to Numbers, as it's how Numbers is calculating the x value when it's a date, that is the basis for my entire question. – Siyfion Apr 13 '18 at 8:34
  • @drivec Added a bit more to make it very obvious that this is "Numbers" specific. – Siyfion Apr 13 '18 at 8:37

You must log in to answer this question.

Browse other questions tagged .