I have a series of excel data (X,Y) more than 1000 rows. They are forces and deformation. Do you know empirically what is the best curve fitting method?
Finally, I want to merge data from other files and correlate them with the X,Y excel files and fill the gaps where necessary or interpolate.
E.g. if we know that for X = 5 and Y= 3 point of a curve is equal to 5 Newton of Force, then how many Newtons of Force are equal to X = 5 and Y = 2.5 (data coming from the new data set).
Any ideas please? Better coming with a piece of code