Programming C, C++, Java, PHP, Ruby, Turing, VB
Computer Science Canada 
Programming C, C++, Java, PHP, Ruby, Turing, VB  

Username:   Password: 
 RegisterRegister   
 "Curve Fitting"
Index -> General Discussion
View previous topic Printable versionDownload TopicSubscribe to this topicPrivate MessagesRefresh page View next topic
Author Message
whoareyou




PostPosted: 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
Sponsor
sponsor
apython1992




PostPosted: Wed May 11, 2011 6:53 am   Post subject: RE:"Curve Fitting"

TI-83 would do that, I believe.
DemonWasp




PostPosted: Wed May 11, 2011 9:26 am   Post subject: RE:"Curve Fitting"

Maple can do it: http://www.mapleprimes.com/questions/36795-How-Do-I-Perform-A-Sine-Regression-ie--line-Of-Best-Fit
whoareyou




PostPosted: 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 Sad
Display posts from previous:   
   Index -> General Discussion
View previous topic Tell A FriendPrintable versionDownload TopicSubscribe to this topicPrivate MessagesRefresh page View next topic

Page 1 of 1  [ 4 Posts ]
Jump to:   


Style:  
Search: