Sound Wave Regression Lab | Excel & MAPLE Solutions

In summary, the conversation discussed completing a lab that involved using sound probes to collect data points and plotting them into a waveform using excel. The next step was to determine the equation of the waveform and include the uncertainty of the coefficients, similar to using the LINEST command in excel. The individuals were wondering if it was possible to do trig regression in excel or MAPLE, as well as discussing alternative methods such as estimating the period, amplitude, phase, and DC offset from the data. The conversation ended with mentioning the teacher's emphasis on including uncertainty.
  • #1
oxnume
20
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: 342
Last edited:
Physics news on Phys.org
  • #2
I am actually looking for the same thing too! Anyone knows how to?
 
  • #3
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.
 
  • #4
Our teacher is very keen on the uncertainty :(
 

Related to Sound Wave Regression Lab | Excel & MAPLE Solutions

What is the purpose of the Sound Wave Regression Lab?

The purpose of the Sound Wave Regression Lab is to analyze sound wave data using Excel and MAPLE software to create regression models and understand the relationship between the variables of sound frequency and amplitude.

What skills are required to complete the Sound Wave Regression Lab?

To complete the Sound Wave Regression Lab, one should have a basic understanding of sound waves and their properties, as well as some familiarity with Excel and MAPLE software. Knowledge of regression analysis and mathematical modeling is also helpful.

Can the Sound Wave Regression Lab be completed without prior programming experience?

Yes, the Sound Wave Regression Lab can be completed without prior programming experience. The lab provides step-by-step instructions for using Excel and MAPLE, and no prior knowledge of programming is required.

What are the benefits of using regression analysis in the Sound Wave Regression Lab?

Regression analysis allows for the creation of a mathematical model that can accurately predict the relationship between sound frequency and amplitude. This can provide valuable insights and help in understanding the behavior of sound waves.

Are the results of the Sound Wave Regression Lab accurate?

The accuracy of the results in the Sound Wave Regression Lab depends on the accuracy of the data collected and the assumptions made in the regression model. It is important to carefully consider and validate the data and model to ensure accurate results.

Similar threads

  • Astronomy and Astrophysics
Replies
10
Views
262
  • Set Theory, Logic, Probability, Statistics
Replies
3
Views
2K
  • MATLAB, Maple, Mathematica, LaTeX
Replies
3
Views
2K
  • Introductory Physics Homework Help
Replies
2
Views
2K
Replies
14
Views
2K
  • Set Theory, Logic, Probability, Statistics
Replies
1
Views
1K
  • Introductory Physics Homework Help
Replies
20
Views
2K
  • MATLAB, Maple, Mathematica, LaTeX
Replies
12
Views
3K
  • STEM Educators and Teaching
Replies
5
Views
716
  • Mechanics
Replies
6
Views
2K
Back
Top