Frequency distribution by Rule Sturgess

Frequency distribution by Rule Sturges
To construct a frequency distribution by rule Sturgess need to find three data.

1. The number of classes (k).

To calculate the number of classes needed in our distribution the following formula is used

   k = 1 + 3.322 log n

Where n is the amount of data in our sample , the value of k must be an integer , therefore , you should always round up to the nearest whole number.

2. The range of our data (R).

Range is as follows :

R = higher value - lower value


3. The amplitude of each class. (A).

To the extent the following is done :

A = k / R

The explanation of the construction of the frequency distribution by rule Sturgess with Excel.