Timeline for How does Excel interpolate / imputate missing values in time-series when fitting a line to a plot?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 30, 2018 at 15:23 | comment | added | whuber♦ | Re the edit: older versions of Excel used to interpret blanks (or even non-numeric values) as zeros. Starting around 15 years ago (as I recall) it started behaving a little better by just ignoring them. | |
| Sep 29, 2018 at 22:57 | history | edited | mc51 | CC BY-SA 4.0 |
Visualization of correct answer / Excel's behaviour
|
| Sep 29, 2018 at 22:52 | vote | accept | mc51 | ||
| Sep 29, 2018 at 17:27 | answer | added | user12075 | timeline score: 5 | |
| Sep 29, 2018 at 15:51 | comment | added | whuber♦ | Look at the interpolating equation in the upper right corner of the plot. It is fit using ordinary least squares (OLS). The Excel help page explains this. | |
| Sep 29, 2018 at 14:44 | history | edited | mc51 | CC BY-SA 4.0 |
edited title
|
| Sep 29, 2018 at 14:40 | review | First posts | |||
| Sep 29, 2018 at 21:35 | |||||
| Sep 29, 2018 at 14:39 | history | asked | mc51 | CC BY-SA 4.0 |