The holiday hangout will go online tomorrow! If there's anything in the regular subforums that you're going to want to access over the holidays, copy it now while it's still accessible.

Don't like the snow? You can make a bookmark with the following text instead of a url: javascript:snowStorm.toggleSnow(). Clicking it will toggle the snow on and off.

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!

Newton
Registered User regular

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.

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.

## Posts

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.