Sound Wave Regression Lab | Excel & MAPLE Solutions

Click For Summary

Discussion Overview

The discussion revolves around a lab involving sound probes and the analysis of waveform data using Excel and MAPLE. Participants are seeking methods to determine the equation of the waveform while incorporating uncertainty in the coefficients.

Discussion Character

  • Homework-related, Technical explanation

Main Points Raised

  • One participant inquires about performing trigonometric regression in Excel or MAPLE to find the equation of the waveform and include uncertainty in the coefficients.
  • Another participant expresses a similar need for assistance with the regression process.
  • One participant suggests that instead of regression, measuring or estimating the period, amplitude, phase, and DC offset could provide a good approximation of the waveform.
  • A later reply notes that the teacher places significant emphasis on accounting for uncertainty in the analysis.

Areas of Agreement / Disagreement

There is no consensus on the best approach to take for the waveform analysis, as participants present differing methods and priorities regarding uncertainty.

Contextual Notes

Participants have not detailed specific methods for performing trigonometric regression in Excel or MAPLE, and there may be assumptions regarding the data quality and characteristics of the waveform that are not explicitly stated.

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: 410
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

Replies
4
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
Replies
20
Views
5K
  • · Replies 12 ·
Replies
12
Views
4K
  • · Replies 14 ·
Replies
14
Views
3K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 5 ·
Replies
5
Views
4K
  • · Replies 6 ·
Replies
6
Views
3K
Replies
10
Views
9K