Vanilla Forums has been nominated for a second time in the CMS Critic "Critic's Choice" awards, and we need your vote! Read more here, and then do the thing (please).
Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!

Help with Excel data

NewtonNewton Registered User regular
edited February 2008 in Help / Advice Forum
I have an excel spreadsheet of data that I need to calculate more values from. Currently, the x-values are increasing in steps of 10 like so:

400 80
410 72
420 91
etc...

I need to fill in the data so that x-values have a step size of 1 assuming a linear relationship between adjacent y values. Is there a built in function that will let me do this easily? All I can really think of doing is graphing adjacent points and getting an equation for a line connecting the points to find the ones in between. That seems like a very crude method, though.

Newton on

Posts

  • DaenrisDaenris Registered User regular
    edited February 2008
    You could use the forecast or trend functions.

    Or, alternatively, if you want only a linear relationship between every 2 y values, you just take the difference, divide by the number of steps, and calculate each new y by adding that step value to the previous one.

Sign In or Register to comment.