I have a set of x values and a set of y values. I've been told that the formula is of the form y=1.04x+b and I'd like Excel to calculate the b that gives the closest fit. When I chart the numbers, Excel is suggesting things like y=1.086x+16.5 and I just need to tweak the slope of the line a little bit and see what the best fitting y intercept would be.
Can I do this in Excel?
See the Excel Help on the LINEST Function.
This link might be help: Excel Array Formula Series #13: LINEST function
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks