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. The SOFTWARE and documentation are provided with RESTRICTED RIGHTS. [. . . ] 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. All levels of the grouping variable are crosstabulated. You can choose the order in which the statistics are displayed. Summary statistics for each variable across all categories are also displayed. Data values in each category can be listed or suppressed. 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. The number of categories should be reasonably small. The other variables should be able to be ranked. 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. Click Statistics for optional statistics. Select Display cases to list the cases in each subgroup. By default, the system lists only the first 100 cases in your file. 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. [. . . ] 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. Whenever you use the Database Wizard, it presents the lowest-level view of your data source that it can find on your system's path, where the levels are (from highest to lowest) enterprise, department, and personal. Each 701 702 Appendix A level's file holds information about all of your data sources for that level. [. . . ]