Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

How many times will the line travel between A and B

  1. Dec 9, 2015 #1

    I'm new to the forum and have a maths question. So basically, X is the time axis (per minute) and Y is the price axis. I have a data set of 200,000 Y values in excel. If I were to draw two horizontal lines through the sine like wave, how many times will the line travel between A and B?? I need a theoretical equation, or excel formula to work it out.
    Image is posted below

    Help will be greatly appreciated.

    Attached Files:

  2. jcsd
  3. Dec 9, 2015 #2


    User Avatar
    Gold Member

    Is the data you have a perfect sine wave? What is it's frequency? Do the peaks and troughs of the data always fall outside of the lines?

    If the peak of the wave at some point doesn't reach the topmost line, are these contiguous points still considered part of a segment that 'travels between the lines'?
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook