Scattergrams
Different (exponential, logarithmic, polynomial, power and moving average) regression types are supported whenever there is only one X-field. Optionally, the regression line and its confidence bands may be displayed and colour coded. Confidence bands refer to the confidence of the mean, not the data set.
Input/Output
File
On the Input/Output tab of the Scattergrams form, select a file Type and double-click (or click on the Select icon) to select the name of the source File. If required, define a Filter to selectively control which records to process.
Axis
Use the Axis grid to enter (or double-click to select) the name of the field that will be used to plot the Y axis, and the names of the fields that will be plotted along the X axis.
You can use the mouse with the SHIFT or CTRL key to multi-select the fields. This will add multiple rows to the grid simultaneously, for each selected field.
Note The fields you multi-select may overwrite existing row/field selections. The safest way is to append a row to the list before multi-selecting fields.
If more than one X field is specified, you can specify which field to draw.
Select a display mode for the Y axis field.
Select a display mode for the X axis field(s).
Note that default labels in charts often use the input field name to label the data being plotted. If these fields are expressions, then the expressions will be used as the label text. To avoid this, you can use an additional attribute to define the label. See: Output Field Name Attributes
You can use field values directly or you can take natural logs of the data before it is displayed. To use the graph values as they occur, choose NORMAL. Choose NATURAL LOG to convert the values in the X or Y fields before they are displayed.
Numeric Exceptions
(Optionally) Use the Numeric Exceptions group to control the way that non-numeric values are handled. Non-numeric values include characters, blanks, and values preceded by a less than sign (<).
Multi-chart layout
Select this option to add a graph to the chart for each combination of the listed fields. To avoid cluttering the chart, the following options are provided:
Scale chart elements
In Multi-layout mode, select this option to scale the axis title/label and point sizes with the size of the charts.
Hide axis labels
In Multi-layout mode, select this option to reduce clutter by hiding the axis labels and ticks.
Report file
Whenever you create a report file in a multiple regression (where there is more than one X-axis field), interactively changing the X- or Y-axis field names will append the new combination to the report. This facility provides a way to quickly accumulate the reports corresponding to each X/Y field combination. However, the report file will grow very quickly, so you should avoid using a report file until you have finished exploring your data.
Enter (double-click or click on the Select icon) to select the name of the Report File that will be written as a result of the process. To see the contents of the file, right-click in the file box and select View (F8).
The Report Viewer is opened for any Statistical function that generates a Report file. Click the Form button on the Viewer toolbar to re-open the form, adjust the parameters of the Statistical calculation, and then choose to overwrite or append to the output in the Viewer window.
Forms
Click the Forms button to select and open a saved form set, or if a form set has been loaded, save the current form set.
OK
When you have set display options and customised the appearance of the chart, click the OK button to run the regression.
Various statistics are calculated and displayed in a Properties pane to the right of the chart. If you have specified a Report file name, a summary report containing the calculated statistics is also generated.
In addition to reporting the standard deviation and mean of the Y variable, the coefficient of determination (R2) and the between groups variance (S2) are also reported.