Excel: How to make a curvefit to sin^4(x) in office 2007 - or any freeware to do it?

Factual Questions
1

I need to fit some data to a sine to the fourth and I can’t get a user defined option in excel (or maybe I’m blind?) - Any of you guys know how to do it or know of any freeware programs that can do the same?

Thanks!

2

If you need the model in the form of y = a (sin x)^4 + b you can simply plot y vs (sin x)^4 , but if you want a model in the form of y = a(sin wx + phi)^4 +b that is hard. Will this help: Re: Sin Fit - NI Community

3

Excel sucks for statistics. Ideally you’d use R instead, but if you have a deadline, the learning curve might be an issue.

sin[sup]4/sup is sort of an unusual function to be regressing against. What makes you think that it’s the right model here?