To follow Dieter's comment,

You can in fact fit a data to a sine in Excel using LINEST. I've done it. I don't recommend it :-) .

What I did was create columns containing sin(x) and cos(x) , roughly speaking, and fit using

LINEST([y=values],{sines, cosines},...)

Ya need the cosines or something similar to get rid of phase ambiguity.


But using either FFTs or glm()  should do fine.

And stay away from Excel!  :-(

Carl

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to