Interpolation of data on Excel for analysis of Load Displacement

  • Thread starter leon313
  • Start date
  • #1
2
0

Main Question or Discussion Point

I don't need any help for the engineering maths I'll be doing after but if I anyone could advise me on how to write a program that would take a set of x and y values and then give me back the y values at certain intervals on the x axis I would be very grateful. I've got colossal amounts of data that needs sorting before I can use it.

Thanks!
 

Answers and Replies

  • #2
berkeman
Mentor
56,654
6,558
I don't need any help for the engineering maths I'll be doing after but if I anyone could advise me on how to write a program that would take a set of x and y values and then give me back the y values at certain intervals on the x axis I would be very grateful. I've got colossal amounts of data that needs sorting before I can use it.

Thanks!
Welcome to the PF. I'm not sure I understand your question. What format is the data in? Is it already in Excel in two columns? Or is it in a clear text file in CSV or some other format?

And you want the output of your program to be what? An Excel spreadsheet with an interpolated y data column next to some pre-set x data (regular interval) column?
 
  • #3
stewartcs
Science Advisor
2,177
3
I don't need any help for the engineering maths I'll be doing after but if I anyone could advise me on how to write a program that would take a set of x and y values and then give me back the y values at certain intervals on the x axis I would be very grateful. I've got colossal amounts of data that needs sorting before I can use it.

Thanks!
If you have the math worked out then most of the work will be in making the program interface. Is that what you need help with? If so, it sounds more like a programming issue. If so, then what language are you familiar with?

CS
 
  • #4
86
0
Just do a least squares regression on the data set, and get a function for y(x). Then plug in values of x to the function you get and there's your interpolated outputs!
 
  • #5
2
0
What I have is a few different sets of data, all with two columns in. My problem is that to take an average of all the different data sets, I need x values at set intervals, whereas at the minute I may have a y value at x = 0.9 and another at x = 1.1 and need the value at 1.0. This isn't a problem obviously to interpolate by hand but the values are to a few decimal places and to do the whole lot by hand would take quite a while. I'm pretty clueless with how to use Excel VBA to help me with it. So the output needs to be An Excel spreadsheet with an interpolated y data column next to some pre-set x data (regular interval) column as berkeman suggested.

Thanks again.
 
  • #6
hotvette
Homework Helper
990
3
If you are using Windows XP, the link below has an Excel add-in called XNUMBERS that contains built in interpolation functions.

http://digilander.libero.it/foxes/SoftwareDownload.htm

Look for the item at the top of the list called "XNUMBERS 5.6 - Multi Precision Floating Point Computing and Numerical Methods for EXCEL"

There is also an excellent tutorial:

http://digilander.libero.it/foxes/Documents.htm

Look for the item called “Numeric calculus in Excel” Xnumbers Tutorial vol.1,Oct. 2007 by Foxes Team.
 

Related Threads for: Interpolation of data on Excel for analysis of Load Displacement

  • Last Post
Replies
3
Views
2K
Replies
5
Views
5K
Replies
3
Views
791
Replies
3
Views
1K
  • Last Post
Replies
6
Views
3K
Replies
2
Views
2K
Replies
1
Views
2K
  • Last Post
Replies
6
Views
3K
Top