This course deals with the computer implementation of common statistical procedures through software packages such as SPSS, BMDP or SAS. The use of basic descriptive statistics, frequency and contingency tables, correlation, regression, analysis of variance and other procedures is illustrated throughout case studies and laboratory assignments. Attention is paid to design of experiments, selection and appropriate statistical procedures, and interpretation of results. No previous computer experience required. Three lecture hours per week. Credit for this course may not be applied to the Major or Minor in Computer Studies.
Prerequisite: One course in applied statistics.   (Currently approved courses are MAT 247, ECO 303, CRJ 401, PSY 203, SOC 206.)

Note:   This course was previously numbered CSC 232.

• Windows introduction/review
• Spreadsheet unit (LOTUS or EXCEL)
  • entering data into a spreadsheet
  • entering values, labels, formulas
  • insert and delete rows and columns
  • copy and move cells
  • change the width of a column
  • format a worksheet
  • using simple functions
  • creating graphs and charts (line, pie, bar, 3D-bar and radar)
  • enhancement of graphs and charts
  • saving and printing a worksheet
• SPSS topics
  • working with SPSS data files: retrieval, storage, printing
  • using SPSS Data Editor
  • entering data
  • naming and defining data types, variables and value labels
  • saving data file
  • modifying data values
  • sort, split, aggregate, recode, select cases based on conditional expressions
  • using statistical procedures
    • FREQUENCIES
    • CROSSTABS
    • DESCRIPTIVES
      • mean, median, mode, sum, standard deviation, variance
      • range, minimum, maximum, skewness, kurtosis, quartiles, percentiles
  • comparison of means
    • Independent Samples T-Test
    • Paired Sample T-Test
    • One-Sample T-Test
    • One way ANOVA
  • CORRELATION
    • Pearson's, Kendall's,Spearman
  • REGRESSION
    • linear and non-linear estimates
    • confidence intervals, line fit
  • working with SPSS graphs and charts
  • working with SPSS output
  • navigation and editing in the output window
  • saving the output
• MINITAB topics
  • data file retrieval and storage
  • descriptive statistics
  • mathematical manipulation of data, random number generator
  • regression
  • scatter plot
  • viewing graphics, Showcase
• INTERNET topics
  • introduction to search engines
  • research on availability of statistical procedures .

• AMSTAT News: Journal of the American Statistical Society.
• Berenson, Mark; Levine, David; Krehbiel, Timothy.   Basic Business Statistics and Student CD-ROM.   Ninth Edition.   Prentice Hall, 2004.
• Grauer, R,; Barber, M.   Exploring LOTUS.   Prentice Hall.
• Green, Samuel & Salkind, Neil.   Using SPSS for Windows and Macintosh: Analyzing and Understanding Data. Fourth Edition.   Prentice Hall, 2005.
• McKenzie, John; Goldman, Robert; A. Minitab, Inc.   Student's Guide to Minitab + Student Edition of Minitab R14,A   Addison-Wesley, 2005.
• Norusis, Marija.   SPSS 12.0 Guide to Data Analysis.   Prentice Hall, 2004.
• Triola, Mario F.   Essentials of Statistics.   2nd Edition.   Addison-Wesley, 2005.
• Velleman, Paul.   ActivStats for SPSS 2003-2004 Release.   Addison-Wesley, 2004.