Uncertainty Qns: Measurement & Data Analysis in Excel

  • Thread starter Thread starter Drooling
  • Start date Start date
AI Thread Summary
Uncertainty in measurements and data analysis in Excel can be addressed by estimating the standard deviation from repeated measurements, which provides a basis for calculating uncertainty. The discussion highlights that uncertainty can also arise from the significant figures of initial values used in calculations. It emphasizes that the certainty of results is limited by the precision of the input data. Participants seek clarification on specific methods for implementing these concepts in Excel. Understanding these principles is essential for accurate data analysis and measurement reporting.
Drooling
Messages
3
Reaction score
0
How do we do uncertainity questions in measurements and data analysis( in microsoft excel spreadsheet)?

Any kind soul willing to help?
 
Physics news on Phys.org
Drooling said:
How do we do uncertainity questions in measurements and data analysis( in microsoft excel spreadsheet)?

Any kind soul willing to help?


Could you be a bit more specific? What exactly do you mean by "uncertainty?"

If a measurement has been completed enough times to get a general estimate of the standard deviation of values, any measurement you get will have an uncertainty commensurate with its standard deviation.

You can have uncertainty that stems from the significant figures in your initial values. You can't really be anymore certain about the values you equate than you are about the values you plug into the equation.
 
So I know that electrons are fundamental, there's no 'material' that makes them up, it's like talking about a colour itself rather than a car or a flower. Now protons and neutrons and quarks and whatever other stuff is there fundamentally, I want someone to kind of teach me these, I have a lot of questions that books might not give the answer in the way I understand. Thanks
Back
Top