Maple Sound Wave Regression Lab | Excel & MAPLE Solutions

AI Thread Summary
The discussion centers on a lab involving sound probes that generated data points for waveform analysis using Excel. Participants seek methods to determine the waveform equation while incorporating uncertainty in coefficients, similar to the LINEST function. There is interest in performing trigonometric regression in Excel or using MAPLE, although some express uncertainty about using MAPLE effectively. A suggestion is made to measure or estimate key parameters such as period, amplitude, phase, and DC offset for a good approximation, especially since the data appears consistent and relatively noise-free. The emphasis remains on the importance of addressing uncertainty as highlighted by the instructor.
oxnume
Messages
19
Reaction score
0
We did a lab that involved using sound probes that gave us a bunch of data points which we were able to plot into a waveform using excel. However, we have to determine the equation of the waveform and it is expected that we include the uncertainty of the coefficients (much like using the LINEST command in excel) so is there a way to do trig regression in excel or maybe MAPLE (which I already have but don't know how to use)?
 

Attachments

  • graph.png
    graph.png
    4.9 KB · Views: 386
Last edited:
Physics news on Phys.org
I am actually looking for the same thing too! Anyone knows how to?
 
Why bother? Measure/calculate/estimate the period, amplitude, phase and DC offset and you can get a good approximation from that. The plot looks fairly noise free and consistent in its data.
 
Our teacher is very keen on the uncertainty :(
 

Similar threads

Logarithmic Regression Question (TI-84 Plus Graphing Calculator)
Replies
4
Views
2K
MHB Forecasting metric using regression. Is this a sound approach?
Replies
3
Views
2K
MATLAB MATLAB API For Wave Flume Data Analysis
Replies
3
Views
3K
B Waves in space
Replies
10
Views
3K
Sound Wave Interference and Finding the Path Differences with Diagrams
Replies
20
Views
5K
Measuring the Speed of Sound in Water, Using Faraday's Law
Replies
14
Views
3K
MATLAB MATLAB Code For Analyzing Experimental Data
Replies
12
Views
3K
Sound waves in a 'compressed' liquid
Replies
6
Views
2K
Data analysis by guessing, checking and fixing
Replies
5
Views
3K
Answering Sound Wave Questions
Replies
6
Views
2K

Hot Threads

Recent Insights

Back
Top