Spreadsheets and Statistics
- Macro (SVB) Programs Example - Basic Spreadsheet Manipulation
This example application shows how to do some basic spreadsheet manipulation such as adding and deleting variables. Open the adstudy.sta data file: - Macro (SVB) Program Examples - Creating a Random Sized Spreadsheet
- Macro (SVB) Programs Example - Resize a Spreadsheet
- Macro (SVB) Programs Example - Auto-Fitting a Spreadsheet's Variable Columns
This example will iterate through all of the open, individual spreadsheets and auto-fit each variable column to the proper width. - Macro (SVB) Programs Example - Converting a Spreadsheet's Data Type
- Macro (SVB) Programs Example - Creating Sample Statistics (Descriptives and Correlations)
- Macro (SVB) Programs Example - Creating a Custom Spreadsheet
- Macro (SVB) Programs Example - Formatting Cells in Spreadsheets
- Macro (SVB) Programs Example - Accessing Results Spreadsheet Data
Here is an example of how the values in a results spreadsheet can be used as input data for another analysis; specifically, this program makes a results spreadsheet with descriptive statistics, and then use the column of means from that results spreadsheet to produce a normal probability plot (of means). - Macro SVB Programs Examples - Searching a Spreadsheet's Cells for a Value
This example will search for a specific string with the active individual spreadsheet. If the string is located, the cell is highlighted and the macro continues its search through the remaining cells in the spreadsheet. In this example, an input box is displayed that prompts you for a value; once that value has been entered, the entire spreadsheet is searched and each occurrence is selected. - Macro (SVB) Programs Example - Inserting an Array into a Spreadsheet
This example demonstrates creating an array, resizing it to the size of a 10x10 Statistica Spreadsheet, filling it with numbers, and copying its contents to a new spreadsheet: - Macro (SVB) Programs Example - Retrieving a Collection of Spreadsheets
- Macro (SVB) Programs Example - Customizing a Simple Descriptive Statistics Macro
- Macro (SVB) Programs Example - Accessing Multiple Modules in a Single Program
- Macro (SVB) Programs Example - Creating a Cell-Function Spreadsheet
One of the most basic functions of the designated spreadsheet software (such as Microsoft Excel) is to automatically recompute cells in the data file when any of the input data (cells) are changed. For example, you can set up a complex budget for a project so that when you change the values for particular budget items, the entire budget is recomputed based on the newly supplied values. - Macro (SVB) Programs Example - Creating a Self-Updating Dataset
Copyright © 2021. Cloud Software Group, Inc. All Rights Reserved.