Some advanced functionality is included by default in Gnumeric, through the menu, which would involve entering complex formulae in other worksheets. This feature of Gnumeric makes it popular in the scientific community, and is particularly useful to mathematicians, scientists and statisticians. The Tools>Statistical Analysis has a range of options to choose from. We will show an example or the Forecast function. Go to Tools>Statistical Analysis>Forecast>Expo nential Smoothing. There are five smoothing approaches available, and configured by default. Select one of these, and remember to toggle between the column and row radio button, depending on how your worksheet is laid out.

You can tweak the input in the Input tab. The Options tab has error correction and factor options with reference to the operation. Check the Include Chart checkbox in this tab if you also want the operation to be charted. The Output tab lets you choose the output location. The safest location is a new worksheet, which is the one selected by default. Click on OK A new worksheet should be created, with a neat table, headers and a chart if you have chosen to include one.