If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table.

Converts a hexadecimal number to binary. Syntax. HEX2BIN (number, [places]) The HEX2BIN function syntax has the following arguments: Number Required. The hexadecimal number you want to convert. Number cannot contain more than 10 characters. The most significant bit of number is the sign bit (40th bit from the right).

FREQUENCY(data_array, bins_array) The FREQUENCY function syntax has the following arguments: data_array Required. An array of or reference to a set of values for which you want to count frequencies. If data_array contains no values, FREQUENCY returns an array of zeros.

How to create a histogram chart in Excel that shows frequency generated from two types of data (data to analyze and data that represents intervals to measure frequency).

Double-click the second series; it should be labeled "- Bin" in the legend. In the Format Data Series dialog box, click the Axis tab. Click Secondary Axis, and then click OK. You now have a chart that compares a given data set to a bell curve.

Right-click inside the text box and then click the formatting options that you want. You can also use the formatting buttons on the Ribbon ( Home tab, Font group). To format the whole title, you can right-click it, click Format Chart Title, and then select the formatting options that you want.

If you select two columns of numbers, rather than one of numbers and one of corresponding text categories, Excel will chart your data in bins, just like a histogram. You can then adjust these bins. Click Insert > Insert Statistic Chart, and then under Histogram, pick Pareto.

Create a chart with recommended charts. This article describes the different types of charts in Excel and other Office programs. Read a description of the available chart types in Office.

Excel functions (alphabetical) Lists Text functions, such as the Clean, Proper, and Trim functions.

Microsoft 3D Maps for Excel is a three-dimensional (3D) data visualization tool that lets you look at information in new ways. 3D Maps lets you discover insights you might not see in traditional two-dimensional (2D) tables and charts.