In large data spreadsheets, it is impossible to view everything at once. Splitting the view of the data into multiple panes can help with tasks such as reviewing and cleaning the data. In STATISTICA spreadsheets, viewing multiple panes within the data is easy. The various panes can be scrolled independently.
Using any STATISTICA spreadsheet, multiple pane views can be created. For this example, the Census.sta example data set is used. It is a large data set with 41 variables and 59,594 cases. As seen below, the first variable is AAGE, or age. Assume that we are interested in viewing this variable close to variable number 40, WKSWORK, or weeks worked in the past year.
It is possible to move variables within a spreadsheet, but more simply, I can create a split in the variable view. This split makes it possible to scroll through the variables from two separate reference points. To do this, drag the small rectangle at the bottom left of the spreadsheet to the right.
Drop it just past the AAGE variable. Then scroll in the right pane to WKSWORK.
With the split scrolling panes, it is easy to view data in a new way. Variables can be compared side by side, possibly revealing interesting relationships. Many of the children in the census data (AAGE<18) worked 0 weeks in the past year (WKSWORK=0). This, of course, is an expected relationship.
Similarly, the data view can be split horizontally. The split pane button for defining two case views is in the upper-right corner of the spreadsheet.
Drag it down to create a second scrolling point in the spreadsheet for rows.
With split scrolling, viewing the data becomes more flexible. This can help in preparing data for analysis.