Preparing Data for Quantitative Analysis

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Chapter 10

WE WRITE ESSAYS FOR STUDENTS

Tell us about your assignment and we will find the best writer for your paper.

Write My Essay For Me

Preparing Data for

Quantitative Analysis

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Learning Objectives

• Describe the process for data preparation and analysis

• Discuss validation, editing, and coding of survey data

• Explain data entry procedures and how to detect errors

• Describe data tabulation and analysis approaches

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Value of Preparing Data for Analysis

• Data preparation process – Converting data from a source into usable code for data analysis

– Important in:

• Assessing and controlling data integrity

• Ensuring data quality by detecting potential response and nonresponse biases created by interviewer or respondent errors

• Dealing with inconsistent data from different sources

• Converting data in multiple formats to a single format that can be analyzed

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Exhibit 10.1 – Overview of Data Preparation and Analysis

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Validation

• Determines whether a survey’s interviews or observations were conducted correctly and are free of fraud or bias

– Curbstoning: Cheating or falsification in the data collection process

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Areas Covered by Validation

Fraud Screening Procedure

Completeness Courtesy

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Editing

• Raw data is checked for mistakes made by either the interviewer or the respondent

• By reviewing completed interviews from primary research, the researcher can check several areas of concern

– Asking proper questions and recording answers accurately

– Correct screening of respondents and complete and accurate recording of open-ended questions

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Coding

• Grouping and assigning values to various responses from survey instruments

– Codes are numerical

– Gets tedious if certain issues are not addressed prior to collecting the data

• Well-planned and constructed questionnaire reduces the time spent on coding

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Coding (continued)

• Four-step process to develop codes for responses

– Generate a list of as many potential responses as possible

– Consolidate responses

– Assign a numerical value as a code

– Assign a coded value to each response

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Data Entry

• Tasks involved with the direct input of the coded data into some specified software package

– Allows the research analyst to manipulate and transform the raw data into useful information

• Involves:

– Error detection

– Missing data

– Organizing data

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Error Detection

• Identifies errors from data entry or other sources

• Approaches

– Determine if the software used will perform error edit routines

– Review a printed representation of the entered data

– Run a tabulation of all survey questions to examine the responses for completeness and accuracy

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Missing Data

• Situation in which respondents do not provide an answer to a question

• Counter approaches

– Replace missing value with a value from a similar respondent

– Use the answers to other similar questions as a guide in determining the replacement value

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Missing Data (continued)

– Use mean of a subsample of the respondents with similar characteristics that answered the question to determine a replacement value

– Use mean of the entire sample that answered the question as a replacement value

• Not recommended as it reduces overall variance in the question

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Data Tabulation

• Counting the number of observations or cases that are classified into certain categories

• Forms

– One-way tabulation: Categorization of single variables existing in a study

– Cross-tabulation: Simultaneously treating two or more variables in a study

• Categorizes the number of respondents who have answered two or more questions

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

One-Way Tabulation

• Purposes

– Determine the amount of nonresponse to individual questions

– Locate mistakes in data entry

– Communicate the results of a research project

• Illustrated by constructing a one-way frequency table

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

One-Way Tabulation (continued)

• In reviewing the output, look for:

– Indications of missing data

– Determining valid percentages

– Summary statistics

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Descriptive Statistics

• Used to summarize and describe the data obtained from a sample of respondents

• Measures used to describe data

– Central tendency

– Dispersion

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Graphical Illustration of Data

• Next step following development of frequency tables is to translate them into graphical illustrations

• Powerful for communicating key research results generated from preliminary data analysis

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Marketing Research in Action Deli Depot

• Should the Deli Depot questionnaire have screening questions?

• Run a frequency count on variable X3– Competent Employees

– Do the customers perceive employees to be competent?

Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.

Marketing Research in Action Deli Depot (continued)

• Consider the guidelines on questionnaire design

– How would you improve the Deli Depot questionnaire?

The post Preparing Data for Quantitative Analysis appeared first on Versed Writers.

Let our team of professional writers take care of your essays for you! We provide quality and plagiarism free academic papers written from scratch. Sit back, relax, and leave the writing to us! Meet some of our best research paper writing experts. We obey strict privacy policies to secure every byte of information between you and us.

ORDER ORIGINAL ANSWERS WRITTEN FROM SCRATCH

PLACE YOUR ORDER