sine wave trendline

[dumb_founded]

I would like to fit a trigonometric function to some data points in
Excel. I can't find an option that would allow me to do so. Any
suggestions?

 

[OJ]

Hi,
try clicking on the the "fx" on the formula bar and choosing "Math &
Trig" in the category box...then you have a list of Excels trig
functions...

hth,
OJ

 

[Harlan Grove]

I would like to fit a trigonometric function to some data points in
Excel. I can't find an option that would allow me to do so. Any
suggestions?

Isn't the standard approach to fitting periodic functions Fourier Analysis?
The Data Analysis ToolPak (part of the Analysis ToolPak, which you'd need to
install via Tools > Add-Ins) includes Fourier Analysis.

 

[Jerry W. Lewis]

You can do a least squares fit of any parametric function
f(xData,parameters) by reserving a group of cells to hold trial values
for the parameters and using Solver to minimize the sum of squared
deviations =SUMPRODUCT((yData-f(xData,parameters))^2) by changing values
of parameters.

Jerry