The number of bins in the histogram determines the width of the bins and
the frequency (number of members) in a bin.
- Please find attached the graph of the histogram of Gretchen's data created with MS Excel.
Given:
The table from Gretchen's data is presented as follows;
The required number of bins = 8 bins
The steps to create the histogram using MS Excel;
- Enter the 15 dataset for the number of days as presented in the above table in a column on the worksheet.
- Select the dataset entered into the cells from above then select the Insert menu.
- In the Chart section of the insert menu click on the Histogram icon to view the quick options for histograms type charts.
- Select the Histogram option from the drop down menu from the quick options for histograms, to create an histogram chart.
- Right-click the histogram created from the previous step, then select Format Chart Area from the pop up menu.
- In the Format Chart Area task pane, click on the arrow next to Chart Options, then select Horizontal Axis from the options menu.
- Click on the histogram icon under Axis Options, then click on arrow button besides Axis Option sub menu, to display the axis options.
- Click on the Number of bins radio button then enter 8, to create an histogram having 8 bins.
The histogram of Gretchen's data having eight bins created with MS Excel is attached.
Learn more about creating a histogram chart here:
