What is the statistical name for a deviation calculation from target value - calculated by replacing mean value in the expression of standard deviation with target value?
The case: I have 10 temperature measurement points. To start experiment I want them to be close to 50 C within 2*sigma.
In excel for certain case with 2 temperature values where cell containing target value of 50 is B46, and temperature data is taken from row 49, it looks like:
=SQRT((1/2)*SUM(((E49-$B$46)^2);((F49-$B$46)^2)))
It's fine to write it for 10 values, but i would like to know how to calculate this for a long column and is there a name for it in statistics?
This looks similar to a chi-squared calculation. Be aware that statistically 1 in 20 values must lie outside +/- 2 sigma.
There may be a mistake in this command line:
=SQRT((1/2)*SUM(((E49-$B$46)^2);((F49-$B$46)^2)))
The colon (;) between (E49-B46)2 and (F49-B46)2 may be a typo. Double check the operator symbol whether it is +. The equation looks like an attempt to write:
The difference between the expected and the observed is generally called error. There are several tools to calculate this error. See link.
LINK:
https://en.wikipedia.org/wiki/Mean_squared_error
https://en.wikipedia.org/wiki/Root-mean-square_deviation
- Badges
- Science topic
- Similar topics
- Mathematics
- Statistics