Uncertainty Qns: Measurement & Data Analysis in Excel

  • Context: High School 
  • Thread starter Thread starter Drooling
  • Start date Start date
Click For Summary
SUMMARY

This discussion focuses on addressing uncertainty in measurements and data analysis using Microsoft Excel. Participants emphasize the importance of understanding standard deviation as a measure of uncertainty, highlighting that repeated measurements can provide a general estimate of this value. Additionally, the conversation points out that uncertainty can also arise from the significant figures of initial values, reinforcing that the precision of input values directly affects the reliability of calculated results.

PREREQUISITES
  • Understanding of standard deviation in statistical analysis
  • Familiarity with significant figures in measurements
  • Basic proficiency in Microsoft Excel functions and formulas
  • Knowledge of data analysis concepts
NEXT STEPS
  • Learn how to calculate standard deviation in Microsoft Excel
  • Explore the use of Excel functions for handling significant figures
  • Research methods for visualizing uncertainty in data analysis
  • Study best practices for reporting measurement uncertainty in scientific contexts
USEFUL FOR

This discussion is beneficial for data analysts, researchers, and students who are involved in measurements and data analysis, particularly those using Microsoft Excel to quantify and communicate uncertainty in their results.

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.
 

Similar threads

Undergrad Propagation of uncertainty in the slope
  • · Replies 6 ·
Replies
6
Views
3K
Undergrad Why Do Physicists Use Gaussian Error Distributions?
  • · Replies 5 ·
Replies
5
Views
3K
Undergrad Significant figures and uncertainty in measurements
  • · Replies 13 ·
Replies
13
Views
4K
Undergrad Understanding Measurement Uncertainty: Calculating Accuracy and Precision
  • · Replies 5 ·
Replies
5
Views
2K
Graduate Individual Measurement Uncertainty vs. Standard Error of Regression
  • · Replies 10 ·
Replies
10
Views
8K
Undergrad Measurement for uncertainty in nonlinear model
  • · Replies 4 ·
Replies
4
Views
2K
Undergrad Uncertainty Analysis: Understanding Errors in Quantity Measurements
  • · Replies 3 ·
Replies
3
Views
2K
High School How Do You Properly Calculate Uncertainty in Measurements?
  • · Replies 1 ·
Replies
1
Views
2K
Data transfer from MS Excel to PSPP
  • · Replies 16 ·
Replies
16
Views
5K
Python Interesting article how to use Pandas with Excel sheets
  • · Replies 1 ·
Replies
1
Views
2K