3.2 Initial Computations

  1. Select cell C1 and in the formula bar type in =COUNT(A2:A33).

Note: You can fill in the input range, A2:A33, in the formula count above by manually typing the address of the cells containing the data values. Alternatively, you can select cells that form the Input Range by clicking on A2, holding, and dragging downward until you reach cell A33. Then release.

  1. Type in cell D1 the label Total number of data entries.
  2. Select cell C2 and in the formula bar type in =MIN(A2:A33).
  3. Type in cell D2 the label Min.
  4. Select cell C3 and in the formula bar type in =MAX(A2:A33).
  5. Type in cell D3 the label Max.
  6. Select cell C4 and in the formula bar type in =(C3-C2)/5.
  7. Type in cell D4 the label Width Computation.
    1. Round up the value resulting in cell C4 to the next whole number by using the formula =ROUNDUP(C4,0) in cell C5 the adjusted value for the width.

Note: The formula above uses the cell address (C4) to identify the number to be rounded up with 0 decimal places.

  1. Type in cell D5 the label Width.
A screenshot of the initial computations for constructiong a hstogram.

Figure 3.1: Initial computations for constructing a histogram.