I have some data sets I wish to create equations based on (3rd and 4th degree poly for good fit) but can't figure out how.
I've tried the solutions suggested here:
http://www.mrexcel.com/forum/showthread.php?t=396162&highlight=trendline+coefficients
http://www.mrexcel.com/forum/showthread.php?t=485587&highlight=trendline+coefficients
http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/
but they don't seem to work. I get errors when I try to use the LINEST function.
I've copy-pasted one of the data sets into an empty sheet and uploaded it here:
http://www.box.net/shared/tnjgpezc50
What function(s) do I need to use to get the coefficients as listed in the sheet?
Any help is appreciated.
I've tried the solutions suggested here:
http://www.mrexcel.com/forum/showthread.php?t=396162&highlight=trendline+coefficients
http://www.mrexcel.com/forum/showthread.php?t=485587&highlight=trendline+coefficients
http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/
but they don't seem to work. I get errors when I try to use the LINEST function.
I've copy-pasted one of the data sets into an empty sheet and uploaded it here:
http://www.box.net/shared/tnjgpezc50
What function(s) do I need to use to get the coefficients as listed in the sheet?
Any help is appreciated.