User manual SPSS BASE 14.0

[. . . ] SPSS Base 14. 0 User's Guide For more information about SPSS® software products, please visit our Web site at http://www. spss. com or contact SPSS Inc. 233 South Wacker Drive, 11th Floor Chicago, IL 60606-6412 Tel: (312) 651-3000 Fax: (312) 651-3668 SPSS is a registered trademark and the other product names are the trademarks of SPSS Inc. No material describing such software may be produced or distributed without the written permission of the owners of the trademark and license rights in the software and the copyrights in the published materials. Use, duplication, or disclosure by the Government is subject to restrictions as set forth in subdivision (c) (1) (ii) of The Rights in Technical Data and Computer Software clause at 52. 227-7013. [. . . ] Cell counts are normally integer values, since they represent the number of cases in each cell. But if the data file is currently weighted by a weight variable with fractional values (for example, 1. 25), cell counts can also be fractional values. You can truncate or round either before or after calculating the cell counts or use fractional cell counts for both table display and statistical calculations. Round cell counts. Case weights are used as is but the accumulated weights in the cells are rounded before computing any statistics. Truncate cell counts. Case weights are used as is but the accumulated weights in the cells are truncated before computing any statistics. Round case weights. Case weights are used as is and fractional cell counts are used. However, when Exact Statistics (available only with the Exact Tests option) are requested, the accumulated weights in the cells are either truncated or rounded before computing the Exact test statistics. 347 Crosstabs Crosstabs Table Format Figure 17-5 Crosstabs Table Format dialog box You can arrange rows in ascending or descending order of the values of the row variable. Summarize 18 Chapter The Summarize procedure calculates subgroup statistics for variables within categories of one or more grouping variables. Summary statistics for each variable across all categories are also displayed. With large datasets, you can choose to list only the first n cases. Example. What is the average product sales amount by region and customer industry? You might discover that the average sales amount is slightly higher in the western region than in other regions, with corporate customers in the western region yielding the highest average sales amount. Statistics. Sum, number of cases, mean, median, grouped median, standard error of the mean, minimum, maximum, range, variable value of the first category of the grouping variable, variable value of the last category of the grouping variable, standard deviation, variance, kurtosis, standard error of kurtosis, skewness, standard error of skewness, percentage of total sum, percentage of total N, percentage of sum in, percentage of N in, geometric mean, and harmonic mean. Grouping variables are categorical variables whose values can be numeric or short string. Some of the optional subgroup statistics, such as the mean and standard deviation, are based on normal theory and are appropriate for quantitative variables with symmetric distributions. Robust statistics, such as the median and the range, are appropriate for quantitative variables that may or may not meet the assumption of normality. 349 350 Chapter 18 Figure 18-1 Summarize output To Obtain Case Summaries E From the menus choose: Analyze Reports Case Summaries. . . Figure 18-2 Summarize Cases dialog box 351 Summarize E Select one or more variables. Optionally, you can: Select one or more grouping variables to divide your data into subgroups. Click Options to change the output title, add a caption below the output, or exclude cases with missing values. You can raise or lower the value for Limit cases to first n or deselect that item to list all cases. Summarize Options Figure 18-3 Summarize Cases Options dialog box Summarize allows you to change the title of your output or add a caption that will appear below the output table. You can control line wrapping in titles and captions by typing \n wherever you want to insert a line break in the text. You can also choose to display or suppress subheadings for totals and to include or exclude cases with missing values for any of the variables used in any of the analyses. Often it is desirable to denote missing cases in output with a period or an asterisk. Enter a character, phrase, or code that you would like to have appear when a value is missing; otherwise, no special treatment is applied to missing cases in the output. 352 Chapter 18 Summarize Statistics Figure 18-4 Summarize Cases Statistics dialog box You can choose one or more of the following subgroup statistics for the variables within each category of each grouping variable: sum, number of cases, mean, median, grouped median, standard error of the mean, minimum, maximum, range, variable value of the first category of the grouping variable, variable value of the last category of the grouping variable, standard deviation, variance, kurtosis, standard error of kurtosis, skewness, standard error of skewness, percentage of total sum, percentage of total N, percentage of sum in, percentage of N in, geometric mean, harmonic mean. The order in which the statistics appear in the Cell Statistics list is the order in which they will be displayed in the output. Summary statistics are also displayed for each variable across all categories. First. [. . . ] You can use the Database Access Administrator to specify up to three different views per database: enterprise level, department level, and personal level. Both the Database Access Administrator and the Database Wizard recognize these files by the following names: Enterprise level: dba01. inf Department level: dba02. inf Personal level: dba03. inf Each file contains level-specific information about any number of data sources. For example, your dba03. inf file could contain personal view information for a corporate accounts database, your company's hourlog database, and a database that you use to keep track of your CD collection. When you open the Database Access Administrator, it will search your system's path for these files and automatically display information for all three views of any data source that you have configured. Inheritance and priorities. [. . . ]