Grouped objects share the same parameter set so that changes in any object affect all objects in its group. Figure 5 shows a spreadsheet used to estimate a monopolist s demand and cost functions. To input data, users point and click on cells and type labels, numbers, formulas, or commands. The data appears in the input bar above the cells. Users can change data in the cells by backspacing over existing data and inputting new values.
Labels consist of a letter followed by letters or numbers.
The spreadsheet has many standard mathematical commands, trigonometric functions and transformation operators that can be included in formulas. Each pair of coordinates is the first and last observation in a series, separated by a colon. A rows 2 through 20, on the dependent variables with observations in columns C and D, rows 2 through 20. Table 6 shows the form and parameters of a tag calling and inserting data and formulas in a spreadsheet. The remaining statements specify values for some of the cells.