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.
Method used to create the histogram of Gretchen's data
Given:
The table from Gretchen's data is presented as follows;
[tex]\begin{tabular}{|c|c|} \underline{ Member}& \underline{Number of Days}\\x_1&2\\x_2&4\\x_3&7\\x_4&8\\x_5&12\\x_6&15\\x_7&10\\x_8&7\\x_9&9\\x_{10}&6\\x_{11}&13\\x_{12}&3\\x_{13}&8\\x_{14}&10\\x_{15}&10\end{array}\right][/tex]
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:
https://brainly.com/question/25069221
https://brainly.com/question/4601962
