I have three Excel columns of data from an experiment with a pendulum: time, angle displacement, and angular velocity. I was wondering if there is a way in Excel to calculate and then graph the period (and, if possible, display the function for the graph)... I realize it's kinda a dumb question. I'm still new at Excel. Thanks for any pointers u can give!
Asked
Active
Viewed 3,628 times
2
-
What do you mean by "graph the period"? It should be a single value for a simple pendulum. – AbdelAziz AbdelLatef Sep 14 '19 at 23:34
-
If you have the formula for calculating the period then you can easily put that into a cell and drag down - then analyze the differences if any between values for the sources of error. – Solar Mike Sep 15 '19 at 07:34
-
I need to graph the period because it changes between measurements; the graph of angle displacement over time change has a decreasing frequency over the 200 entries. I’m using the period formula separately; I want to compare the theory to the experimental. I I tried the Fourier series but it just told me it need a 2^n number of entries to work... :( – wolfwoof Sep 15 '19 at 18:25
1 Answers
2
In case the Analysis ToolPak is installed, one can use Tools->Data Analysis->Fourier Analysis. If the data is a superposition of harmonic functions (sin,cos), the corresponding frequencies (or inverse periods) will appear as peaks in the Fourier analysis.
Gianluca
- 536
- 4
- 7
-
Very nice. It looks like I need to use =IMABS() on the resulting table of complex numbers. – trindflo Nov 02 '22 at 17:44