Written by: STATISTICA 7/26/2010 2:06 PM
Sometimes your data has a pattern, but this pattern isn't expressed within a variable.
Maybe every other row is an "away" game for your baseball data set. Or maybe you have genetic data broken into 5 segments.
Regardless, you have some type of data grouping that is known but not recorded.
So, typically you start by adding a new variable to your data set. Then you add data to this variable by using autofill.
A horizontal or vertical series in a block can be extrapolated (autofilled) by dragging the block Fill Handle (a small solid square located on the lower-right corner of the block). After selecting the block, point at the Fill Handle. When the mouse pointer changes to a plus sign , drag to the last cell(s) to which you want to extrapolate the data. STATISTICA can create series of values such as sequential numbers, linear extrapolations, and dates.
To create the pattern, you should have at least 3 rows of data.
1, 3, 5 is turned into 1, 3, 5, 7, 9, 11, 13, 15, 17, 19.
If the initial selection contains repeated values, these values are duplicated in the extended block.
Non-identical values are extended by linear trend regression to compute extrapolated values for the series.
/angela waner
Image Credit: http://www.flickr.com/photos/webtreatsetc/4721242479/
0 comment(s) so far...