Doing Statistical Analysis with MS Excel - Making a histogram continued
(Page 3 of 4 )
Step 4. Make the bin data table using the bin statistics. Since the actual data table has been placed in Cell A1 to Cell A20, the bin table should be placed starting on cell B1 to B23. See below:
35.7
35.8
35.9
36
36.1
36.2
36.3
36.4
36.5
36.6
36.7
36.8
36.9
37
37.2
37.3
37.4
37.5
37.6
37.7
37.8
37.9
The bin table should be arranged like the one above.
Step 5. If you are done with the bin table, you can compute the FREQUENCY. This will count the number of data occurrences within the specific bin data range. In our example, use cell C1 to place this frequency formula:
=frequency(A1:A20,B1:B23)
Then select (selecting the cells will highlight the cells) starting with cell C1 and going down to cell 23. Then follow the steps below:
- Press F2.
- Press Ctrl - Shift (together).
- Press Enter.
The procedure above will produce the frequency data table in column C. Look at the screen shot below; your analysis in your Excel spreadsheet should be similar (particularly in column C where the frequency data table is computed).
We've almost finished; we still have to plot the frequency vs. the actual data bin table.
Step 6. To generate the histogram plot, follow the simple steps below:
- Go to Insert -> Chart -> Column (this is the chart type), and then click NEXT.
- Click the "SERIES" tab, and remove Series 1 and Series 2, because they are redundant data in the histogram.
- Click on the "Category (X-axis)," and then select B1 to B23, which is the bin range data.
- Finally, for the name, you can change it from "Series3" to "histogram."
Now you have the histogram plot generated.
Next: How to make a correlation plot and regression analysis >>
More BrainDump Articles
More By Codex-M
