"Curve Fitting"
Author |
Message |
whoareyou
|
Posted: Tue May 10, 2011 8:27 pm Post subject: "Curve Fitting" |
|
|
So apparently, Excel 2007 doesn't have the option to do sinusoidal regressions with data on a scatter plot. I tried searching Google for programs that can do this, but nothing seems proper. I was wondering if anyone here know any program (Windows) that can do curve-fitting, particularly sinusoidal regressions. |
|
|
|
|
|
Sponsor Sponsor
|
|
|
apython1992
|
Posted: Wed May 11, 2011 6:53 am Post subject: RE:"Curve Fitting" |
|
|
TI-83 would do that, I believe. |
|
|
|
|
|
DemonWasp
|
|
|
|
|
whoareyou
|
Posted: Wed May 11, 2011 4:40 pm Post subject: RE:"Curve Fitting" |
|
|
So I got the program, now I'm just wondering how to use it. lol. Where do you input the data, and how do you do ...
code: |
> with(Statistics):
X:= [0.1, 0.2, 0.3, 0.5, 0.9, 1.5];
Y:= [2.2, 2.0, 1.7, 1.4, 1.2, 2.4];
f:= Fit(a*sin(b*x+c)+d, X, Y, x);
f := -1.15580028879341712*sin(2.22069518969496293*x-.130332816749035546)+2.32490667588415256
> with(plots):
display(pointplot(zip(`[]`,X,Y),symbol=circle), plot(f, x = 0 .. 1.6));
|
Sorry, I've never used this program before, and I don't think I can import my Excel data into it. Btw, I have Maple 13.
And the TI-83 is a calculator, right? We used those graphing calculators in class; I know those could do it, but when we had the assignment, we never got to use them over the weekend, and my teacher said Excel could do it, but she lied |
|
|
|
|
|
|
|