Formulas, Transformations, Recoding, Verifying, Cleaning Data

• How do I calculate (transform) values of a variable?
  
• Can STATISTICA automatically recalculate all spreadsheet formulas when the data change?
  
• What is the simplest way to recode values of a variable (e.g., split a continuous variable into categories)?
  
• How do I create values of a new variable based on conditions met by other variables?
  
• What syntax can be used to create case selection/verification/recode conditions (or to calculate variable values using spreadsheet formulas)?
  
• How can I verify and "clean" data?
  
• How do I perform a multiple sort?
  
• How do I rank-order values of a variable (replace values with their ranks)?
  
• How do I transpose data (convert cases into variables)?
  
• How do I automatically fill ranges of data in the spreadsheet?
  
• How does the extrapolation of blocks (AutoFill) work?
  A horizontal or vertical series in a block can be extrapolated 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 (example, you can extend a series such as 1, 2, 3 to include 4, 5, 6, ).
• How do I standardize values in a block?
  

Copyright © 2021. Cloud Software Group, Inc. All Rights Reserved.