Using STdev wrong or apparatus error?

Click For Summary
SUMMARY

The discussion centers on the correct method for calculating the standard error of the mean (SEM) for measurements of a capillary tube's radius. The user initially considers using the standard deviation (STDev) divided by the square root of (n-1) to obtain the SEM but is confused by the high error percentages resulting from this method. Expert advice confirms that while the STDev calculation is correct, the significant variation in radius measurements suggests that the apparatus error should not be solely relied upon. Instead, the user should propagate the error from the actual measurements to obtain a more accurate representation of the error in the calculated radius.

PREREQUISITES
  • Understanding of standard deviation (STDev) calculations
  • Knowledge of error propagation techniques
  • Familiarity with Excel functions, specifically =STDEV()
  • Basic principles of measurement accuracy and significant figures
NEXT STEPS
  • Research error propagation methods in experimental physics
  • Learn advanced Excel techniques for statistical analysis
  • Study the implications of significant figures in measurement reporting
  • Explore the concept of systematic versus random errors in measurements
USEFUL FOR

Researchers, laboratory technicians, and students involved in experimental physics or engineering who need to accurately assess measurement errors and apply statistical methods to their data analysis.

CricK0es
Messages
54
Reaction score
3

Homework Statement


I have 3 (n) measurements of the radius of a capillary tube, and I'm wondering whether I should take the STDev of these values and then divide by sqrt(n-1) to obtain a standard error, and use this as my error on the mean...
or
Do I propagate the apparatus error through and use that as my error on the mean?

Left ------------ Right----------Adj. Diam----Radius
0.062700 ---- 0.061140 ---- 0.00156 ---- 0.00078
0.065000 ---- 0.062330 ---- 0.00267 ---- 0.00134
0.064610 ---- 0.063100 ---- 0.00151 ---- 0.00076

Mean-------St. dev--------St error
0.00096----0.000328-----0.000232
=24.23513% error!

When using the SE, my error propagates through to give ~94% error on the value I wish to obtain. When using the apparatus error, it's only 5.16%; and I'm sure the rest of my spreadsheet is correct. So, I'm not sure what I'm doing in this regard. Any guidance would be appreciated... Seems simple, I know; just doesn't fit. I was expecting an SE on my mean of around 5%...

Homework Equations


Using excel, so =STDEV(-,-) ; where I input the 3 values for my radii
SE = STDEV / sqrt(2)

The Attempt at a Solution



Above... Sorry, realized my little table copy/paste didn't come out well [/B]
 
Last edited:
Physics news on Phys.org
The STDEV procedure you have used is correct; there is a rather large standard deviation on your radius values. Unless this is simply a measurement error, it looks as if your capillary radius might actually be varying along the capillary. In that case, using the apparatus error ignores a significant factor of the actual error, and is not the right way to go.
 
  • Like
Likes   Reactions: CricK0es
I assume you measured two quantities, one labeled "Left" and one labeled "Right". These are your actual measurements and you should find the std on these. Then propagate the error for the calculated (as opposed to measured) radius as
$$\delta R~= \sqrt{[\delta(Left)]^2+ [\delta(Right)]^2} $$
The error is 84%, a huge number, but not surprising considering that the middle measurement results in a radius that is almost twice as large as the other two. Also, in view of the accuracy of your measurements, you should trim the number of your reported significant figures appropriately.
 
  • Like
Likes   Reactions: CricK0es

Similar threads

Replies
15
Views
2K
  • · Replies 15 ·
Replies
15
Views
4K
  • · Replies 6 ·
Replies
6
Views
1K
  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 6 ·
Replies
6
Views
5K
Replies
2
Views
2K
  • · Replies 5 ·
Replies
5
Views
7K
  • · Replies 13 ·
Replies
13
Views
2K
  • · Replies 10 ·
Replies
10
Views
3K
  • · Replies 5 ·
Replies
5
Views
2K