#1   Report Post  
Posted to microsoft.public.excel.misc
florin
 
Posts: n/a
Default frequency

Hi all,

is there a way in Excel for computing the frequency/period from a dataset
that represents a periodic signal?

Thanks,

Cheers,
Florin
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default frequency

The easiest way is to measure and then average the peak-to-peak distances
directly from the data.

You could also try to fit a model to the data using any standard linear or
non-linear technique to fit the parameters. This qwould require either
programming or the clever use of Solver.
--
Gary's Student


"florin" wrote:

Hi all,

is there a way in Excel for computing the frequency/period from a dataset
that represents a periodic signal?

Thanks,

Cheers,
Florin

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
histograms - frequency and relative frequency? confusedstudent Excel Discussion (Misc queries) 2 February 8th 06 08:20 AM
3-D Frequency Chart in VBA [email protected] Charts and Charting in Excel 0 July 5th 05 05:19 PM
Frequency function Pritesh Excel Discussion (Misc queries) 2 April 18th 05 09:53 PM
Frequency for Histograms in Excel Jim Charts and Charting in Excel 7 February 24th 05 07:33 PM
Cumulative Frequency Chris Grant Charts and Charting in Excel 2 February 3rd 05 05:49 AM


All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"