How is SVB integrated with Statistica data (input), analyses and output?
The Statistica libraries contain all functions that allow you to fully program and customize your Statistica application; these functions can be called from other applications that support the standard Visual Basic language, such as Microsoft Visual Basic, Microsoft Excel, etc.
- Organization of SVB programs
- Statistica Visual Basic is organized around analysis objects (see also
What is meant by the term "object model?"); for example, to run an analysis with the Statistica Basic Statistics module, you would first create an analysis object with the constant scBasicStatistics and (optionally) with a data file name (location of the file containing the input spreadsheet). For a complete list of modules (reference libraries) see
Statistica Libraries and Modules. To make access to the thousands of Statistical functions and options available in the Statistica system as convenient as possible, SVB maintains a very close correspondence between the dialogs as they are presented during interactive analyses, and the flow of the SVB program. In a sense, once an analysis has been created, such as an analysis via the Basic Statistics module, you simply "program the dialogs" for the respective Statistical analysis. Put another way, if you were to do the analysis by hand, then, after invoking the Basic Statistics module, you would follow through a sequence of dialogs to specify the desired analysis.
You can think of each dialog as a property (see also What are properties, what are methods?) of the (e.g., Basic Statistics) analysis, and of each option, selection, etc. on that dialog as a property of that dialog. Thus, you first invoke a module by declaring the respective analysis object, and then set the desired options etc. as properties of the analysis (and the dialogs of that analysis). Note that when designing actual programs, the automatic macro recording facilities of Statistica will do most of the programming work for you. You simply run the desired analyses interactively, and then create the macro for those analyses (see How can I record my analysis in an SVB program?); that macro will contain all of the programming code to recreate the analysis step by step, and it can easily be edited (copied, pasted) to create the desired customized application.
- Moving between implied dialogs of the statistics module
- To move from one dialog to the next when running Statistica interactively, you click the OK button (to move forward to the next dialog) and the Cancel button (to return to the previous dialog). SVB has two methods to accomplish this that belong to the analysis object: Run (to move forward to the next dialog) and GoBack (to return to the previous dialog).
- Creating output documents
- Most results from Statistica analyses are presented in results spreadsheets and graphs. When running Statistica interactively, you would create results spreadsheets and graphs by clicking on the respective buttons on the results dialogs. In SVB, each results "button" can be (implicitly) clicked by executing the respective method that is part of the respective dialog. For example, every results dialog in Statistica has a Summary button (identified by the icon) to create the most "important" results from the respective analysis. In SVB, every results dialog has a Summary method to do the same.
- Results spreadsheets and graphs
- Each method that can be used to produce results spreadsheets and graphs (e.g., the Summary method) will return a Collection of spreadsheet objects, graph objects, or spreadsheet and graph objects (see also What are collections?). Note that even if the respective results spreadsheet or graph consists of only a single document, it will still be returned as a collection. Thus, you can use the standard Visual Basic conventions to retrieve individual objects from the collection, etc.
- RouteOutput method, and AnalysisOutput objects
- When running Statistica interactively, the output spreadsheets and graphs can be sent to workbooks (by default), stand-alone windows, reports, etc., depending on the selection of options on the Analysis/Graph Output Manager dialog. The choices of options in that dialog are implemented by the AnalysisOutput object, which can be used as a "container" for the results spreadsheets and graphs. Typically, a summary results spreadsheet or graphs collection would be recorded in an Analysis Macro or Master Macro as:
newanalysis.RouteOutput(newanalysis.Dialog.Summary).Visible=True
The RouteOutput method takes as an argument the Summary collection (of spreadsheets, graphs, or both) and places it into the workbook, report, etc. depending on the current selections on the Analysis/Graph Output Manager dialog. The RouteOutput method actually returns an object of type AnalysisOutput which itself has a number of methods and properties to make it fully "programmable."
Note: the actual selections on the Analysis/Graph Output Manager dialog are typically recorded via the OutputOption object. Specifically, those options will be recorded either as part of Analysis Macros if they are set or changed via Options - Output for the specific analysis, or they will be recorded as part of Master Macros if they are set or changed in a specific analysis as well as via the Output tab of the Options dialog (accessed from the Tools - Options menu). - Manipulating and editing Statistica documents
- Spreadsheets and graphs are only two of the document types that Statistica uses to handle input and output of Statistical analyses. Other document types are (text) reports and workbooks, which are used to organize and manage all other documents. There are a large number of properties and methods available for each of these types of documents that are used to customize your results or to access aspects of your results for further processing.