How Do I Create a Histogram Using Continuous Data in Excel 2007?
With the Microsoft Office Excel 2007 spreadsheet application you can create and format a variety of charts and graphs to represent the data that you enter into the workbook. An easy way to analyze continuous data is to create a histogram. A histogram is a column chart that displays a frequency table. The data that you want analyzed is entered into an input data column, and the frequency intervals for the continuous data are entered into the bin numbers column of the spreadsheet. Open the Microsoft Excel 2007 application on your computer. Enter the continuous data into the spreadsheet. Make sure to create one column with an input range of continuous data and another column with a bin range of data, which must be entered in ascending order. Click on the “Data” tab and then click on the “Data Analysis” option from the “Analysis” group. The Analysis Tools dialog box will then appear. Click on the “Histogram” option and then click on the “OK” option. Click on the “Collapse Dialog” button in
