How to automatically fill in ranges of data in the spreadsheet

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).