I have this dataset with ~21,000 points. I need to integrate at ~44,000 regular intervals, but the data is spaced irregularly. Here's an image of a small subset for context:
Data.png
The vertical grey lines are the intervals I need to integrate at (1 unit). The circles represent the data points. I'm trying to come up with some sort of algorithm that will allow me generate a new data set. I'm not sure if this is more an Excel programmer question or a math question, so I'm posting this to a math forum as well.
I've attached a CSV of the points in the above image in case you want to experiment. Any ideas?
Bookmarks