Ch-10 的Data preparation,Frequancy and Cross tabulation.pptVIP

Chapter Ten Data Analysis: Data Preparation Frequency Distribution, and Cross-Tabulation Preliminary Plan of Data Analysis Questionnaire Checking Editing Coding Transcribing Data Cleaning Selecting a Data Analysis Strategy Data Preparation Process Data Preparation Process Coding The assignment of a code, usually a number to represent a specific response to a specific question. Coding structured questions Coding open-ended questions Treatment of Unsatisfactory Responses Treatment of Unsatisfactory Responses Return to the Field Discard Unsatisfactory Respondents Assign Missing Values Substitute a Neutral Value Casewise Deletion Treatment of Unsatisfactory Responses Pairwise Deletion Calculate the Frequency for Each Value of the Variable Calculate the Percentage and Cumulative Percentage for Each Value, Adjusting for Any Missing Values Plot the Frequency Histogram Calculate the Descriptive Statistics, Measures of Location and Variability Conducting Frequency Analysis Conducting Frequency Analysis Statistics Associated with Frequency Distribution Measures of Location Mean Mode Median Measures of Variability Range Variance Standard Deviation Skewness of a Distribution Skewness of a Distribution Statistics Associated with Cross-Tabulation Chi-Square The statistic used to test the statistical significance of the observed association in a cross-tabulation. Phi Coefficient It measures the strength of association between the variables in the special case of 2 x 2 table. Cramer’s V This is a modified version of the phi correlation coefficient and can be used in tables larger than 2 x 2. V 0.3 – low association; 0.3 V 0.6 – moderate association; V ).6 – strong association. Running Case-Bank of America 1.Many of the importance items have more than 10 percent of the values missing. Identify these items. How would you address these missing values? 2.Recode the following demographic characteristics into the cate