DA: Statistics Summary (Windows 7, Teaching Lab PC's)

 

Launch Excel via PHstat

Click on File, Options

Enable Analysis and Solver Add-ins

Data Classification (p32, p81)

1. Categorical- ex: separated by region, customer type 
1. Use Proportions to describe this data-type 
2. Cross Tabulation- tabular method that displays the number of observations in a data set for different subcategories of two or more categorical variables
3. The subcategories of the variables must be ME and exhaustive, meaning that each observation can be classified in only one sub-category
4. Common Marketing Research Tool
2. Ordinal- ex: ranking data (1st - Last)
3. Interval-  no natural zero. ex: temperature in C or Fahrenheit
4. Ratio- have a natural zero. Sales dollars ($0 is natural zero for 0 sales activity)
5. Types of Data
1. Cross-sectional- data that are collected over a single period of time
2. Time-series- data collected over time
6. Number of Variables
1. Univariate- single variable
2. Multivariate- two or more variables