|
Oscillatory data can be analyzed using Maple or some other package
by plotting an integer number of cycles of the data (such as peak to peak) with
the time adjusted to start at t=0 and the average subtracted to center the
oscillations about the time axis. The appropriate oscillatory
function (with or without a decaying amplitude depending upon the data set)
can then be graphed over the data.
Worksheets for Mock Data -
Computer Lab #2.
-
Maple Worksheet - In this
worksheet the txt data file is read into Maple, plotted and ready for analysis as the sample shows.
Sample File data1.txt
-
Excel Example - Here is an
example of how MS Excel can be used. One can create the desired data
in one Excel worksheet. This data can then be pasted into the sample Excel
data analysis sheet. The data will be in two
columns ready for analysis. The above file shows a sample of how such
an analysis might look. Do not print the entire data sheet!
Worksheets for SID Data -
Computer Lab #3.
This is the data that the groups have collected. See
below how one can work with the SID data in either Excel or Maple.
Note: Data taken at 50 Hz records times in units of microseconds, while
the 20 Hz data is recorded in seconds. The spring constant for this
set is 23.1 N/m. Tabulated Results
-
Maple Worksheet - In this
worksheet the SID data file is read into Maple, converted to a txt
file and then plotted and ready for analysis as the sample shows.
-
Excel Example - Here is an
example of how MS Excel can be used. One can click on the above data
file, highlight just the data and not the heading material, and copy
the data. One can paste the data into Excel. Select the column the
data is in and select Text to Columns under the Data menu. Click Next
and select Comma delimited. Click Finish and the data will be in two
columns ready for analysis. The above file shows a sample of how such
an analysis might look. Do not print the entire data sheet!
Top
|