Cancel
Click the Cancel button to close the dialog box without performing an analysis.
Options
See Options Menu for descriptions of the commands on this menu.
Open Data
Click the Open Data button to display the Select Data Source dialog box, which contains options to choose the spreadsheet on which to perform the analysis. The Select Data Source dialog box contains a list of the spreadsheets that are currently active.
Select Cases
Click the Select Cases button to display the Analysis/Graph Case Selection Conditions dialog box, which is used to create conditions for which cases will be included (or excluded) in the current analysis. More information is available in the case selection conditions overview, syntax summary, and dialog box description.
W
Click the W (Weight) button to display the Analysis/Graph Case Weights dialog box, which contains options to adjust the contribution of individual cases to the outcome of the current analysis by "weighting" those cases in proportion to the values of a selected variable.
Weighted moments
Select the Weighted moments check box to specify that each observation contributes the weighting variable's value for that observation. The weight values need not be integers. This module can use fractional case weights in most computations. Some other modules use case weights as integer case multipliers or frequency values. This check box will only be available after you have defined a weight variable via the W option above.
DF = W-1 / N-1
When the Weighted moments check box is selected, moment statistics (e.g., mean, variance) can be based on the sum of the weight values for the weighting variable (W-1), or on the number of (unweighted) observations (N-1). The sums of squares and cross products will always be based on the weighted values of the respective observations. However, in computations requiring the degrees of freedom (e.g., standard deviation, ANOVA tables), the value for the degrees of freedom can either be computed based on the sum of the weight values, or based on the number of observations. Moment statistics are based on the sum of the weight values for the weighting variable if the W-1 option button is selected, and are based on the number of (unweighted) observations if the N-1 options button is selected. For more information on options for using integer case weights, see also Define Weight.