# Data Averging method [closed]

I have a series of 2 columns called Amount & Percentage. Now the amount is incrementing with no linear value eg 1659,3167,4495 and I want to have a data for every 1000 that is 1000,2000,3000,4000,5000. It can be done by avreaging the percetage data. How can be done? Then I want to automate it by using c++ but I want a mathematical proof like.

Thanks

-

## closed as off-topic by Ricardo Andrade, Stefan Kohl, quid, Todd Trimble♦Nov 23 at 22:39

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "MathOverflow is for mathematicians to ask each other questions about their research. See Math.StackExchange to ask general questions in mathematics." – Ricardo Andrade, quid, Todd Trimble
If this question can be reworded to fit the rules in the help center, please edit the question.

hmm, that's called linear interpolation: basic statistics. If you can assume that it is a linear relationship, you need to find the best fitting line with $y=mx+b$, which you could do with minimizing the least squares error of the best fit line. Search for linear regression and least squares fitting to figure out more. The FAQs make it look like this doesn't belong here on this website, but on a basic math or homework site instead.