Tuesday, December 25, 2012

How to Make a Histogram in Excel 2003

1. Open an Excel workbook. Click the Windows 'Start' button, click 'All programs,' click 'Microsoft Office' and then click 'Microsoft Office Excel 2003.' Alternatively, you can double-click the Excel shortcut icon on your computer's desktop.
2. Click 'Tools' in the menu bar to open a drop-down menu, then click the 'Add-ins' option. You must first add this feature to Excel before a histogram can be created.
3. Click the check box next to 'Analysis Toolpak' and click the 'OK' button in the Add-Ins window. This particular add-in will be loaded in to Excel.
4. Click 'Tools' in the menu bar a second time, then click 'Data Analysis.' This opens a new window. Click 'Histogram' in the list of options in the window and click 'OK.' This opens the Histogram window.
5. Enter cell names in the Input Range field. This is the data you want to analyze. You can enter these by dragging your mouse over the cells in your Excel worksheet. They will automatically load into the Histogram window.
6. Enter cells names in the Bin Range field as you did with the cells for the Input Range. These are the numbers you want to use as intervals in the histogram.
7. Select your output options. You have two main choices for what the output will look like: a table or a chart histogram. 'Pareto' will output your data in a table in descending order of frequency. 'Chart Output' is just that. The 'Cumulative Percentage' option can add this percentage to your table or chart. You can also have your histogram appear in a new workbook, and you can name it if desired. Click the check boxes of the output options you want, then click the 'OK' button. Your histogram will be generated.

Blogger news