The histogram report is for displaying the distribution of values in the query dataset that fall into specific bins (buckets). The summarized values are in the last page (minimum and maximum values, average).

You can also evaluate your query using statistical functions, such as StDev, StDevP, Var, VarP.

 

Statistical functions:

 

StDev and StDevP:

 

These two functions will give an estimation on the scatter of a population or sample population indicated by a set of data that is in a certain field of the query. The function StDevP evaluates population, while the function StDev evaluates sample population.

The scatter indicates the distribution of values of a distribution function around their average. The scatter value is the square root of the difference squares’ weighted mean, with which value the difference of certain values from the average value can be featured.

 

Var and VarP:

 

These two functions will give an estimation on the variance of a population or sample population indicated by a set of data that is in a certain field of the query. The function VarP evaluates population, while the function Var evaluates sample population.

Variance: the degree of one group’s divergence from the mean of the group.