370 likes | 1.16k Views
Chapter 15. Data Preparation and Description. Learning Objectives. Understand . . . The importance of editing the collected raw data to detect errors and omissions. How coding is used to assign number and other symbols to answers and to categorize responses.
E N D
Chapter 15 Data Preparation and Description
Learning Objectives Understand . . . • The importance of editing the collected raw data to detect errors and omissions. • How coding is used to assign number and other symbols to answers and to categorize responses. • The use of content analysis to interpret and summarize open questions.
Learning Objectives Understand . . . • Problems with and solutions for “don’t know” responses and handling missing data. • The options for data entry and manipulation.
Monitoring Online Survey Data Online surveys need special editing attention. CfMC provides software and support to research suppliers to prevent interruptions from damaging data .
Accurate Consistent Uniformly entered Arranged for simplification Complete Editing Criteria
Field Editing • Field editing review • Entry gaps identified • Callbacks made • Validate results Ad message: Speed without accuracy won’t help the manager choose the right direction.
Central Editing Be familiar with instructions given to interviewers and coders Do not destroy the original entry Make all editing entries identifiable and in standardized form Initial all answers changed or supplied Place initials and date of editing on each instrument completed
Coding Rules Exhaustive Appropriate to the research problem Categories should be Mutually exclusive Derived from one classification principle
Content Analysis QSR’s XSight software for content analysis.
Types of Content Analysis Syntactical Referential Propositional Thematic
Handling “Don’t Know” Responses Question: Do you have a productive relationship with your present salesperson?
Keyboarding Database Programs Optical Recognition Digital/ Barcodes Voice recognition Data Entry
Missing Data Listwise Deletion Pairwise Deletion Replacement
Bar code Codebook Coding Content analysis Data entry Data field Data file Data preparation Data record Database Don’t know response Editing Missing data Optical character recognition Optical mark recognition Precoding Spreadsheet Voice recognition Key Terms
Appendix 15a Describing Data Statistically
Frequencies A B
Measures of Central Tendency Mean Median Mode
Variance Quartile deviation Standard deviation Interquartile range Range Measures of Variability
Symbols _ _ _
Central tendency Descriptive statistics Deviation scores Frequency distribution Interquartile range (IQR) Kurtosis Median Mode Normal distribution Quartile deviation (Q) Skewness Standard deviation Standard normal distribution Standard score (Z score) Variability Variance Key Terms