As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options
Help with Excel data
Newton
Registered User regular
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.
Newton on
0
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.