I searched through the archives but I couldn't really find what I am looking for. I have several different issues all related to this same question.

I'll start with the one that I think is the simplest. I have data that consists of a set of coordinates that is indirectly related to an angular measurement. The data set that I have consists of four sets of coordinates and four coresponding angles. The data is below. Angle, 43.09, 34.83, 26.8, 18.08, X, 174.24, 187.45, 202.18, 213.87, Y, 140.13, 121.84, 103.3, 81.46, How can I get excel to give me values for X and Y based on an angle that I input, such as 22.45. Plotting a graph of the X and Y gives a curved output, so the methods that I know of do not seem to be working.

I have other more complex sets of data with complex curves that I would like to use a similar method to mine data. Please let me know your thoughts Excel Ninjas Thanks! With only four data points, no method will give you a good estimate. You might try Newton's methods for approximation. (It involves a term for the first derivative) but with so few data points, it would probably be no more accurate than normal linear interpolation. Fancy mathematics can not substitute for a lack of data. What is this, some kind of spiral?

I noticed that R gets smaller as theta increases. I should have been more descriptive, sorry about that.

My angular bounds are at about 55 degrees and 10 degrees. I will not input any angular data outside those bounds. If I have to, I can keep my angular inputs between 43,09 and 18.08 to simplify the calculation. My thought process / hope in asking this question is as follows: I can visually see a curve plotted on my screen by excel when I plot an XY scatter of the X data vs angle, adn Y data vs angle.

Squares curve fitting using a fifth degree polynomial is shown in the following figure. In summary, the linear interpolation formula is to obtain for. • Note: With. A control system application involving interpolation is in setting up a safe.

Is there a way to automatically update a cell with data for X and Y at some point on that curve, given a corresponding angular measurement? I can see the data on my screen, how do I get it into a cell automatically? I'll try to search for a newtonian method for approximation and see what I can find. I'm not exactly a practicing mathematician, so forgive me if my questions seem naive.

Here is another issue that I am hoping an answer exists for. This is basically the same question that I have above, just a different twist. I have data for spring rate curves of air springs. This data is detailed, but not detailed enough.

What I am looking to do is have a cell in another worksheet be able to reference the data below, and give a Net Force output for any given Travel that I input (within the range of 0 to 1.5 Travel). For example, If I input 0.0125 travel, I would like an output in Net Force that follows the curve fit to the data. If I use a linear interpolation, I can get semi-accurate results, but setting up the linear interpolation is time consuming because I need to know exactly what travel increments I am looking for net force outputs on, and then add a line to allow for the interpolation.

Free Download Edio SC3000/SC3000L Audio Driver 5. (Sound Card). Set of files packing the drivers for Edio SC3000/SC3000L Audio. Windows XP file size. Download GENIUS Sound Card drivers, firmware. Genius Sound Maker Value 5.1 Sound Card Driver 1.0 for Windows 7 28,466 downloads. Sound Card| GENIUS. Genius product support helps you to download Drivers, Manuals and Applications. You can find FAQ here about how to use the product. Sound Maker Value 5.1. Genius sc3000 sound card driver windows 7. Genius Sound / Audio Free Driver Download| Keep your Genius Sound / Audio drivers up to date with the world's most popular driver download site.

There has to be a better way. Code: 0.5-0.8: y = 410.26x3 - 714.49x2 + 745.06x + 106.01 0.8-1.5: y = 497.53x4 - 1716.8x3 + 2504.2x2 - 1358.2x + 614.02As you can see the result is good for the middle part and not bad for the right part. If it's not enough for the right part you can use a higher degree polynomial or you can subdivide it further. I used the trendline in the scatter graph to get the polynomials. Hope this helps PGC ******** ******************** ************************************************************************> Microsoft Excel - Book1.xls ___Running: xl2000: OS = Windows XP ( F)ile ( E)dit ( V)iew ( I)nsert ( O)ptions ( T)ools ( D)ata ( W)indow ( H)elp.