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:
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 Simpson's rule based algorithm that will allow me generate a new data set. I'm not sure if this is more an Excel programmer question instead, so I'm posting this to an excel forum as well.
I've attached a CSV of the points in the above image in case you want to experiment. Any ideas?
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 Simpson's rule based algorithm that will allow me generate a new data set. I'm not sure if this is more an Excel programmer question instead, so I'm posting this to an excel forum as well.
I've attached a CSV of the points in the above image in case you want to experiment. Any ideas?