Transcript Business Plan

University of Redlands
AFCA Workshops and
Tutorials Series
July 17, 1999
SPSS and Simple Statistics
for Business
Dr. Cliff Kettemborough, Adjunct Lead Faculty
1
University of Redlands
Introduction to Statistics (1 of 6)
• What is Statistics?
– A Branch of Mathematics
– Statistic vs. Statistics
• Data Collection and Organization
July 17, 1999
–
–
–
–
–
Surveys/questionnaires
Other sources of data
Representation of data
Tabular format
Variables
• dependent vs. independent
• type of values
Dr. Cliff Kettemborough, Adjunct Lead Faculty
2
University of Redlands
Introduction to Statistics (2 of 6)
• Type of Statistics
– Descriptive vs. Inferential
– Examples
• Working with tabular data
– Sorting
– Arranging based on desired properties
• Representing Data
July 17, 1999
– Charts: Pie, Histograms, Paretto, Gantt
– Running Charts, Stem-and-Leaf
– Other formats
Dr. Cliff Kettemborough, Adjunct Lead Faculty
3
University of Redlands
Introduction to Statistics (3 of 6)
• Probabilities
July 17, 1999
– Counting Principles
• Permutations, Arrangements, Combinations
– Expectations
– Finite and Continuous Probability
– Events; Independence
• Conditional Probability
• Bayes Formula
• Binomial Distribution
– Random Variables
Dr. Cliff Kettemborough, Adjunct Lead Faculty
4
University of Redlands
Introduction to Statistics (4 of 6)
• Summarization of Data
– Sample vs. Population
– Range, Frequency, and Distribution
– Mean, Mode, Median, as measures of Central
Tendency
– Variations, Deviation, Standard Deviation
• Sampling Methods and Sampling Distributions
July 17, 1999
– Normal Distribution; Properties
– z-values
– t-Student values (small samples)
Dr. Cliff Kettemborough, Adjunct Lead Faculty
5
University of Redlands
Introduction to Statistics (5 of 6)
• Hypothesis Testing: Null and Alternative
–
–
–
–
Types of Errors
One- and Two-Tale Test
Proportions
Sample Size
• Tow populations
July 17, 1999
– F-values
– Chi-Square Distribution
– Correlation: Least Square, Linear, Multi-Linear, NonLinear
Dr. Cliff Kettemborough, Adjunct Lead Faculty
6
University of Redlands
Introduction to Statistics (6 of 6)
– Regression
– Non-normal distributions
• Non-parametric Methods: Analysis of Ranked
Data
–
–
–
–
Index Numbers
Time Series Analysis
Decision Making under Uncertainty
Forecasting
• Statistical Process Control
July 17, 1999
– Using run-charts
– Upper and lower limits
Dr. Cliff Kettemborough, Adjunct Lead Faculty
7
University of Redlands
SPSS - The Basics (1 of 3)
• Student vs. Professional version
• MS Windows Application
– “Look and Feel”
– Common Windows Operations
• File menu: Data vs. Output Window
• Edit menu
• Views...
– Main Functions
July 17, 1999
• Working with Data Window
• Variables and Cases
• Data Editor vs. Output Window
Dr. Cliff Kettemborough, Adjunct Lead Faculty
8
University of Redlands
SPSS - The Basics (2 of 3)
• Computing Simple Statistics
–
–
–
–
–
Summarizing
Computing Central Tendency values
Drawing Simple Graphs
Editing a Graph
Changing the Defaults
• Menus and Dialog Boxes
July 17, 1999
– How they work?
– Changing the Defaults
– Cases: Sorting and Splitting
Dr. Cliff Kettemborough, Adjunct Lead Faculty
9
University of Redlands
SPSS - The Basics (3 of 3)
• Transforming Data Values
• Pivoting Tables
–
–
–
–
–
Creating and Displaying Layers
Editing Pivot Tables
Hiding Rows and Columns
Changing Data Display Formats
Customizing Tables
• Organizing Output Windows
July 17, 1999
Dr. Cliff Kettemborough, Adjunct Lead Faculty
10
University of Redlands
SPSS - Advanced Functions (1 of 2)
• File Menu
– Import and Export formats
• Spreadsheet files
• Database files
• ASCII files: delimited vs. fixed columns
– Edit menu: Options…
• Data Window
July 17, 1999
–
–
–
–
Transpose
More on Variables
Numeric vs. Non-numeric Data
Using Labels
Dr. Cliff Kettemborough, Adjunct Lead Faculty
11
University of Redlands
SPSS - Advanced Functions (2 of 2)
• Computing Advanced Statistics
July 17, 1999
–
–
–
–
–
–
–
–
t-test
ANOVA
Linear models
Correlation
Regression
Classification
Non-parametric tests
Time Series
Dr. Cliff Kettemborough, Adjunct Lead Faculty
12
University of Redlands
SPSS - Wrap-Up (1 of 1)
• Getting and Using Help
• Tutorials
July 17, 1999
Dr. Cliff Kettemborough, Adjunct Lead Faculty
13