How many times will the line travel between A and B

  • Context: Undergrad 
  • Thread starter Thread starter Konstantine
  • Start date Start date
  • Tags Tags
    Line Travel
Click For Summary
SUMMARY

The discussion centers on calculating the number of times a sine wave intersects two horizontal lines using a dataset of 200,000 Y values in Excel. The user, Ed, seeks a theoretical equation or Excel formula to determine these intersections. Key considerations include the frequency of the sine wave and whether the peaks and troughs consistently exceed the defined lines. The discussion emphasizes the importance of defining segments based on the wave's behavior relative to the horizontal lines.

PREREQUISITES
  • Understanding of sine wave properties and behavior
  • Familiarity with Excel formulas and functions
  • Basic knowledge of frequency and amplitude in waveforms
  • Ability to interpret graphical data representations
NEXT STEPS
  • Research how to use Excel's COUNTIF function to count intersections
  • Learn about sine wave equations and their graphical representations
  • Explore the concept of wave frequency and its impact on intersections
  • Investigate mathematical modeling techniques for wave analysis
USEFUL FOR

Mathematicians, data analysts, Excel users, and anyone involved in wave analysis or graphical data interpretation will benefit from this discussion.

Konstantine
Messages
1
Reaction score
0
Hi,

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.
Thanks,
Ed
 

Attachments

  • maths1.jpg
    maths1.jpg
    16.7 KB · Views: 463
Physics news on Phys.org
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'?
 

Similar threads

High School Need help with understanding time travel
  • · Replies 8 ·
Replies
8
Views
3K
Switching reference frames between two intersecting lines
  • · Replies 10 ·
Replies
10
Views
1K
Undergrad Difference between Time, Arrival-Time & Inter-Arrival-Time in Poisson Process
  • · Replies 8 ·
Replies
8
Views
3K
Undergrad Time travel is a fact or fiction.?
  • · Replies 9 ·
Replies
9
Views
3K
Graduate Voltage and current waves in a transmission line
  • · Replies 4 ·
Replies
4
Views
3K
MHB Working out Trend line on a Scatter Graph
  • · Replies 7 ·
Replies
7
Views
3K
Line voltage in 3 phase as single sine wave
  • · Replies 15 ·
Replies
15
Views
6K
Undergrad Do Electric field lines propagate by themselves away from a charge?
  • · Replies 73 ·
3
Replies
73
Views
6K
Undergrad Magnetic Flux - Misleading Definition or what?
  • · Replies 24 ·
Replies
24
Views
2K
Undergrad Some questions about absorption lines
  • · Replies 4 ·
Replies
4
Views
2K