How to use the Histogram add-in Excel?

[Flaco]

Hello friends,
I am new user to the basics of the computer. I have done some basic things in Microsoft Office. In that I always find an Excel as tough part. I know some basic things in it. Now I have been told to use the histogram add-in excel. I am not having any idea about it nor I know what does that mean. So thought that you guys may help me.!! So please tell me how to use the Histogram add-in Excel? Reply me as early as possible.!!

[Zenon]

Before using the Histogram tool, you must ensure that the Analysis ToolPak is installed. To verify the Analysis ToolPak is installed, follow these steps :

1. In Microsoft Office Excel 2003 and in earlier versions of Excel, click Add-Ins on the Tools menu. In Microsoft Office Excel 2007, follow these steps:
   • Click the Microsoft Office Button, click Excel Options.
   • Click on the supplements category.
   • In the Manage list, select Excel Add-ins, then click Search.
2. In Ins dialog box, make sure the box next to Analysis ToolPak is selected on supplements available. Click OK.

[Kirmiac]

I would like to discuss about the Analysis ToolPak in details. For the utility analysis appears in the Add-Ins dialog box, it must be installed on your computer. If you do not see the utility in the analysis Ins dialog box, run the installation program for Microsoft Excel and add this component to the list of installed components. Hope that you got the point that I was trying to explain you.!!

[HellBoy21]

Follow the steps that can be useful for creating the a histogram Excel :

1. Type the following data into a new worksheet :
   

   A1: 87 B1: 20
        A2: 27 B2: 40
        A3: 45 B3: 60
        A4: 62 B4: 80
        A5: 3 B5:
        A6: 52 B6:
        A7: 20 B7:
        A8: 43 B8:
        A9: 74 B9:
       A10: 61 B10:

2. In Excel 2003 and in earlier versions of Excel, click Data Analysis on the Tools menu.
3. In Excel 2007, click Data Analysis in the Analysis group on the Data tab.
4. In the dialog box data analysis, click Histogram, and then click OK.
5. In the Input Range box, type A1: A10.
6. In the Bin Range box, type B1: B4.
7. Under Output Options, click New Workbook, select the checkbox graphic output, and then click OK.

[chroma]

Excel counts the number of data points in each bin of data. A data point is included in a bin specific data if the number exceeds the lower limit and less than or equal to the upper limit of the bin data. In the above example given by the 'HellBoy21' the bin corresponding to data values from 0 to 20 contains two data points, 3 and 20. If you omit the bin range, Excel creates a set of evenly distributed bins between the minimum and maximum data.

[kattman]

You will not be able to create the Histogram chart if you specify options to create the table histogram in the same workbook as your data. Data Analysis tools such as ANOVA, Fourier Analysis, Histogram, and ttest, operate by using data from a single worksheet. You can send the resulting data to a worksheet range, new worksheet, or new workbook. If you choose to send the new data to a new worksheet and you are in group edit mode, new blank worksheets will be created equal to the number of grouped sheets.