Periodic Signals in Excel
Periodic Signals, What does periodic mean? Repeating, right? Yes, but what about the phase and applications of periodic analysis.
Consider a signal : y=A*cos(ω*t) Where A is a scaling multiplier(Literally, scales the vertical(up/down) axis(points ), ω is the frequency in radians(radians are used because the format actually makes for friendlier math) and t is time, but could be any index(independent(x) axis variable).
Whenever a text says “consider a signal” the author typically wants you to picture the signal in your head or actually plot it. Reading math is pointless if you aren't visualizing the functions response.
cos(ω*t) keep in mind that ω has units of radians/sec. t, in seconds, can take on any value from -infinity to +infinity relative to any other position. Why is it allowed to? because mathematics says so. Is t practically allowed to be anything? This is where understanding the bigger picture (system) view sets the limits and appropriate scale. "y" is the dependant variable. The value of y depends on the value of t in this case. If we are talking about a mechanical wave then ω will typically be less than 1000radians/sec and it probably would not be useful to increment (move forward) t by 0.000000001 seconds. However, if talking about a radio frequency (rf) signal at 15.072e9 rad/s, the 1e-9 time step would step right over cycles.
Mmmkay, don’t just consider the signal, put the signal into Excel (or the Open Office free version) by:
Make a column(A,B,C…) with numbers, representing phase in degrees, from 0-360 (2π radians)
a. Start by filling out the first 3 rows: 0,1,2
b. Highlight the 3 rows and drag down to fill in values to 360
2. Convert the values to radians by multiplying by π/180 (The astute reader knows that there is a radians() command in excel that does the same thing. You should always know (or at least try to) what a function/command is doing.)
a. Type into the first column of row B: =(pi()/180)*
i. Left arrow to grab column A, Row 1
ii. Hit Enter to finish
3) Now in Column C
a. Type =cos(
i. Left arrow to grab column B, Row 1
ii. Hit Enter to finish
b. Highlight Columns A,B and C and drag fill down to row 361
You should have 3 populated columns
4) Select column C by clicking on “C”
a. Insert a line graph by selecting the “insert tab” then selecting the line graph
If everything went right you should get a Cosine wave from 0degrees to 360 degrees
Now, the Cosine signal doesn’t really look like a traditional wave response… How can we improve this? Periodic Examples