Question 1

The Data worksheet is linked to the Data Variables worksheet by: Copy-Paste Special-Paste Link.

Accepted Answer

A) True 
 B)False

Question 2

Data coding refers to the creation of a computer file that holds the raw data taken from all of the acceptable completed questionnaires.

Accepted Answer

A) True 
 B)False

Question 3

Using XL Data Analyst,there must be a ________,a unique,short,single-word description for that variable placed in the first row on the Data worksheet.

Accepted Answer

A) value label 
B) value code 
C) variable label 
D) variable code 
E) value description 
A) value label 
B) value code 
C) variable label 
D) variable code 
E) value description

Question 4

The use of value codes and value labels depends on the nature of the variable.

Accepted Answer

A) True 
 B)False

Question 5

________ refers to the creation of a computer file that holds the raw data taken from all of the acceptable completed questionnaires.

Accepted Answer

A) Data entry 
B) Data coding 
C) Data matrix 
D) Data filing 
E) Data surveying 
A) Data entry 
B) Data coding 
C) Data matrix 
D) Data filing 
E) Data surveying

Question 6

In large-scale projects,and especially in cases in which the data entry is performed by a subcontractor,researchers utilize a data code book which identifies (1)the questions on the questionnaire,(2)the variable name or label that is associated with each question or question part,and (3)the code numbers associated with each possible response to each question.

Accepted Answer

A) True 
 B)False

Question 7

A variable description is limited to one word.

Accepted Answer

A) True 
 B)False

Question 8

Nonresponse,while an issue in the research industry,is certainly not one of the major problems confronting the industry.

Accepted Answer

A) True 
 B)False

Question 9

A variable description is a phrase or sentence that identifies the variable in more detail and refers to the question on the questionnaire.

Accepted Answer

A) True 
 B)False

Question 10

To return to the original data set after using a selected subset for analysis,simply use the Utilities-Unfilter Data operation.

Accepted Answer

A) True 
 B)False

Question 11

Using XL Data Analyst,selecting subsets of the data for analysis requires which of the following operations?

Accepted Answer

A) Utilities-Filter Data 
B) Utilities-Unfilter Data 
C) Selection-Filter Data 
D) Selection-Subset-Analysis 
E) Selection-Data-Subset 
A) Utilities-Filter Data 
B) Utilities-Unfilter Data 
C) Selection-Filter Data 
D) Selection-Subset-Analysis 
E) Selection-Data-Subset

Question 12

Creating a computer file that holds the raw data from all the completed surveys is called data entry.

Accepted Answer

A) True 
 B)False

Question 13

The XL Data Analyst produces tables that can be copied and pasted into word processor applications such as Microsoft Word without the need for extensive reformatting into professionally appearing tables.

Accepted Answer

A) True 
 B)False

Question 14

The refusal rate for telephone survey is estimated to be as high as:

Accepted Answer

A) 30% 
B) 40% 
C) 50% 
D) 60% 
E) 75% 
A) 30% 
B) 40% 
C) 50% 
D) 60% 
E) 75%

Question 15

The way you set up your code book in XL Data Analyst is through the Define Variables worksheet.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is defined as a failure on the part of the prospective respondent to take part in the survey or to answer specific questions on the questionnaire?

Accepted Answer

A) respondent failure 
B) respondent stubbornness 
C) nonresponse 
D) noncompliance 
E) insubordinate 
A) respondent failure 
B) respondent stubbornness 
C) nonresponse 
D) noncompliance 
E) insubordinate

Question 17

Errors in the research process that pertain to anything other than sampling are referred to as non-sampling errors.

Accepted Answer

A) True 
 B)False

Question 18

When a respondent knowingly provides a false answer to a survey question,this is known as an intentional respondent error.

Accepted Answer

A) True 
 B)False

Question 19

One of the reasons your authors created the XL Data Analyst is because practically everyone is familiar with Excel.

Accepted Answer

A) True 
 B)False

Question 20

The Define Variables Worksheet is:

Accepted Answer

A) independent of the Data Worksheet 
B) linked to the Data Worksheet 
C) unavailable in XL Data Analyst 
D) to be used only to do linear programming 
E) available through a third party data collection firm 
A) independent of the Data Worksheet 
B) linked to the Data Worksheet 
C) unavailable in XL Data Analyst 
D) to be used only to do linear programming 
E) available through a third party data collection firm

The Data worksheet is linked to the Data Variables worksheet by: Copy-Paste Special-Paste Link.

Data coding refers to the creation of a computer file that holds the raw data taken from all of the acceptable completed questionnaires.

Using XL Data Analyst,there must be a ________,a unique,short,single-word description for that variable placed in the first row on the Data worksheet.

The use of value codes and value labels depends on the nature of the variable.

________ refers to the creation of a computer file that holds the raw data taken from all of the acceptable completed questionnaires.

A variable description is limited to one word.

Nonresponse,while an issue in the research industry,is certainly not one of the major problems confronting the industry.

A variable description is a phrase or sentence that identifies the variable in more detail and refers to the question on the questionnaire.

To return to the original data set after using a selected subset for analysis,simply use the Utilities-Unfilter Data operation.

Using XL Data Analyst,selecting subsets of the data for analysis requires which of the following operations?

Creating a computer file that holds the raw data from all the completed surveys is called data entry.

The XL Data Analyst produces tables that can be copied and pasted into word processor applications such as Microsoft Word without the need for extensive reformatting into professionally appearing tables.

The refusal rate for telephone survey is estimated to be as high as:

The way you set up your code book in XL Data Analyst is through the Define Variables worksheet.

Which of the following is defined as a failure on the part of the prospective respondent to take part in the survey or to answer specific questions on the questionnaire?

Errors in the research process that pertain to anything other than sampling are referred to as non-sampling errors.

When a respondent knowingly provides a false answer to a survey question,this is known as an intentional respondent error.

One of the reasons your authors created the XL Data Analyst is because practically everyone is familiar with Excel.

The Define Variables Worksheet is:

An Introduction to Marketing Research

The Marketing Research Industry

The Marketing Research Process Including the Problem and Research Objectives

Research Design Alternatives and Qualitative Research

Information Types and Sources: Secondary Data and Standardized Information

Data Collection Methods

Measurement Scales

Designing Data Collection Forms

Determining Sample Size and the Sample Plan

Summarizing Your Data

Generalizing Your Findings

Determining Relationships

Finding Differences

Preparing and Presenting Your Research Report

Filters

Exam 10: Data Issues and Inputting Data Into Xl Data Analyst

The Data worksheet is linked to the Data Variables worksheet by: Copy-Paste Special-Paste Link.

Data coding refers to the creation of a computer file that holds the raw data taken from all of the acceptable completed questionnaires.

Using XL Data Analyst,there must be a ________,a unique,short,single-word description for that variable placed in the first row on the Data worksheet.

The use of value codes and value labels depends on the nature of the variable.

________ refers to the creation of a computer file that holds the raw data taken from all of the acceptable completed questionnaires.

A variable description is limited to one word.

Nonresponse,while an issue in the research industry,is certainly not one of the major problems confronting the industry.

A variable description is a phrase or sentence that identifies the variable in more detail and refers to the question on the questionnaire.

To return to the original data set after using a selected subset for analysis,simply use the Utilities-Unfilter Data operation.

Using XL Data Analyst,selecting subsets of the data for analysis requires which of the following operations?

Creating a computer file that holds the raw data from all the completed surveys is called data entry.

The XL Data Analyst produces tables that can be copied and pasted into word processor applications such as Microsoft Word without the need for extensive reformatting into professionally appearing tables.

The refusal rate for telephone survey is estimated to be as high as:

The way you set up your code book in XL Data Analyst is through the Define Variables worksheet.

Which of the following is defined as a failure on the part of the prospective respondent to take part in the survey or to answer specific questions on the questionnaire?

Errors in the research process that pertain to anything other than sampling are referred to as non-sampling errors.

When a respondent knowingly provides a false answer to a survey question,this is known as an intentional respondent error.

One of the reasons your authors created the XL Data Analyst is because practically everyone is familiar with Excel.

The Define Variables Worksheet is:

An Introduction to Marketing Research

The Marketing Research Industry

The Marketing Research Process Including the Problem and Research Objectives

Research Design Alternatives and Qualitative Research

Information Types and Sources: Secondary Data and Standardized Information

Data Collection Methods

Measurement Scales

Designing Data Collection Forms

Determining Sample Size and the Sample Plan

Summarizing Your Data

Generalizing Your Findings

Determining Relationships

Finding Differences

Preparing and Presenting Your Research Report

Filters