4. Observe: construct a histogram
Excel offers a graphical style that allows you to see the histogram relative to the simulated values. It's easy to use, but it can be useful to know how to construct a histogram from a series of data. The procedure is as follows:
find the "Min" and "Max" of the simulated series (Column A, for example): MIN(A:A), MAX(A:A) ;
determine the number of classes (n = number of simulated values): NB Classes = ENT(1 + LOG10( n ) * 10/3).
There are other ways of determining the number of classes in a histogram. This one, derived from Sturges' rule, is given as an example:
determine the "PAS" width of classes: PAS = [MAX(A:A) – MIN(A:A)]/ NB Classes ...
Exclusive to subscribers. 97% yet to be discovered!
Already subscribed? Log in!
Observe: construct a histogram
Defining a confidence interval
Article included in this offer
"Laboratory quality and safety procedures"
(
142 articles
)
Updated and enriched with articles validated by our scientific committees
A set of exclusive tools to complement the resources
Bibliography
Covariance evaluation by means of uncertainty assessment DUBOIS (C.), LEBLOND (L.), POU (J.M.) and FERRERO (A.), in IEEE Instrumentation & Measurement Magazine, vol. 19, no . 6, pp. 12-18, December 2016
JCGM 100:2008(E)...
Exclusive to subscribers. 97% yet to be discovered!
Already subscribed? Log in!
