sine wave trendline

  • Thread starter Thread starter dumb_founded
  • Start date Start date
D

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?
 
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
 
dumb_founded said:
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?
Click to expand...

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.
 
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
 
Back
Top