几何尺寸与公差论坛

 找回密码
 注册
查看: 1374|回复: 0

curve fitting models-excel

[复制链接]
发表于 2009-9-5 20:54:08 | 显示全部楼层 |阅读模式
curve fitting models-excel
does anybody have a source of good curve fitting tools that could be used in excel (or similar).  i have table curve 2d and 3d, but not for the most recent version of windows, and as such, i can't use them (despite their ease of use).
any ideas out there (i.e. without paying $500...again).
check out our whitepaper library.
this question comes up from time to time in the "engineering spreadsheets" forum (and elsewhere).  see, for example, threads:
   724-97493
   770-82803
   770-142106
if you need to do a lot of curve fitting, a specialised tool would be best.  if your need is either only occasional or particularly exotic, then excel can probably do the job (but at a cost of considerably more time for each curve).
excel already has curve fitting tools such as polynomials and log. if you want more specialised fitting curves such as trigonometric curves then look at the basics of least squares regression and derive the coefficients you'll need from first principles.
corus
an extension to corus:... and fourier transformation.
m777182
look at the linest function.  it can do a lot more than just linear equations.  i can find the coefficients of polynomials and non-linear equations too.  i think linest is an add on so you may have to install it off your office cd.
guys,
i heard about minitab and mathcad. do this have curve fitting features?
mathcad -- yes
ttfn
minitab can do it, but i can't re  
i found a site that can do curve fitting for more diffciult data. it's on nlreg.com. the price is $140 but you can download a trial version for 30 days, allowing only 50 data points. failing that, try
i don't do much curve fitting, but i have had a lot of luck with a program called curveexpert1.3
you can download it here:
the website i just posted looks like it may charge you to download, but i am positive that i downloaded it for free.  i'm sure it's out there somewhere  
minitab does have curve fitting and its real simple to do
you could use origin from originlab (
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|Archiver|小黑屋|几何尺寸与公差论坛

GMT+8, 2024-5-7 03:30 , Processed in 0.080184 second(s), 19 queries .

Powered by Discuz! X3.4 Licensed

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表