MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Create a Formula


Posted by Vic Blosser on January 31, 2002 8:19 AM

Is there a way to have Excel create a best fit formula for a data table?


Posted by Vic Blosser on January 31, 2002 8:26 AM


I should also add that the intent is to be able to calculate values in between the given data points.
A B
10000000000 8
150000000 12
11000000 16
2200000 20
196000 28
68800 36
29400 48

What value of A is produced by a B value of 30?

Posted by Steve Hartman on January 31, 2002 8:34 AM

The TREND function uses a least squares fit as does LINEST. The LOGEST function uses exponential regression for it's fit.