Statistical Analysis

• The Gnumeric Manual, version 1.8
• Advanced Analysis

The data analysis tools package contains tools for statistical data analysis and data sampling. To use these tools select the Data Analysis... item in the Tools menu. This yields a list of tools to choose from. Select one of the tools from the list and press the OK button or double-click on the tool. The tools are described below.

Figure 6-16 Statistical Analysis Tools

All tools have the same output options (see Figure 6-17). The results can be printed into a new sheet, into a new workbook, or into a given output range on a sheet of the current workbook. To select the output method select one of the radio buttons inside the Output frame. If you have chosen “Output Range” you must also enter a single range in the entry field.

Select the Autofit Columns option to automatically adjust the widths of the columns in the output range.

You will normally want to select the Clear Output Range option, since otherwise some of the cells with existing content will remain in the output range.

The Retain Output Range Formatting and Retain Output Range Comments options are useful if you have already preformatted the output range.

Most analysis tools also provide a choice whether they will enter formulas or just values in the cells. By default Gnumeric will usually enter formulas. These formulas will automatically reevaluate when the data change. For some tools, the formulas also permit modification of certain parameters.

Figure 6-17 Common output options of the data analysis tools

To enter a range into an entry field, you can either type the range specification into the text field, or click in the text field and then select the range on the sheet (see Figure 6-18).

Figure 6-18 Specifying Ranges

Some entry fields accept lists of ranges. To enter these lists, select one range, type a comma, and then select the next range. At any time, you may switch to another sheet of the workbook.