How to automatically fill in ranges of data in the spreadsheet
Welcome to "KB Articles"
How to automatically fill in ranges of data in the spreadsheet
book
Article ID: KB0081738
calendar_today
Updated On: 07-31-2017
Products
Versions
Spotfire Statistica
13.0 and above
Description
This article explains how to automatically fill in ranges of data in the spreadsheet.
Issue/Introduction
How to automatically fill in ranges of data in the spreadsheet
Resolution
Statistica has a variety of operations that extrapolate (AutoFill) ranges.
Random value fill. Select a block, right-click, and select Fill/Standardize Block - Fill Random Values from the spreadsheet shortcut menu. The currently selected block will be filled with random values (following a uniform distribution) in the range of 0 to 1. An error message is displayed if a block is not selected.
Extrapolation of values (AutoFill). A selected series of values (consisting of at least two values) will be extended if a meaningful pattern is detected. For example, the following numbers: 1.00, 2.00, and 3.00 will be extended to 4.00, 5.00, 6.00, etc. Select the block of values to be extended, click on the small black handle in the lower-right corner, and drag through the next empty cells to extrapolate the values. If no meaningful pattern can be detected, predicted values from a linear trend regression will be used for the extrapolation.
Fill down or right. Select a block of cells containing entries. Using the small black handle on the lower-right corner of the cells, drag either to the right or down to select empty cells. Then select either Fill/Copy Down or Fill/Copy Right from the Edit - Fill/Standardize Block submenu (or the spreadsheet shortcut menu). Both options work in a manner similar to Microsoft Excel's Fill Right and Fill Down facility (also available in Excel from the Edit menu).