MKTG 323 FINAL (10-12) TEXAS A&M UNIVERSITY
QUESTIONS AND CORRECT DETAILED ANSWERS WITH
RATIONALES (VERIFIED ANSWERS) ALREADY GRADED A+
columns Ans✓✓✓identified with alphabetic headings
rows Ans✓✓✓identified with numeric headings
cells Ans✓✓✓intersection of columns and rows
cell reference Ans✓✓✓A2, C12, F30
Types of data in cells Ans✓✓✓- text (labels)
- number data (constants)
- formuals (mathematical equations that do all the work)
coding Ans✓✓✓involves grouping and assigning value to various
resposes form the survey instrument
(responses are numerical 0-9)
Dummy Variables Ans✓✓✓You'll have one column in excel and ever a
"1" for females and "0" for males
Central Tendency Ans✓✓✓locates the "center" of a distribution of
values
, Mean Ans✓✓✓arithmetic average
Median Ans✓✓✓middle value of rank ordered distribution
Mode Ans✓✓✓response most often given to a question
nominal scales Ans✓✓✓Ex: Y/N, Freshman/Sophomore/Junior/Sr
Ordinal Scale Ans✓✓✓Ranked preference from 1 to 3
Interval Scale Ans✓✓✓Likert scale with 7 scales (strongly
agree...strongly disagree)
Ratio Scale Ans✓✓✓Ex: age 21
Interval or ratio scaled variables Ans✓✓✓Mean, median, mode
Nominal data and ordinal data Ans✓✓✓-can't compute mean
-can compute median and mode
Dispersion Ans✓✓✓the spread of values around the central tendency
QUESTIONS AND CORRECT DETAILED ANSWERS WITH
RATIONALES (VERIFIED ANSWERS) ALREADY GRADED A+
columns Ans✓✓✓identified with alphabetic headings
rows Ans✓✓✓identified with numeric headings
cells Ans✓✓✓intersection of columns and rows
cell reference Ans✓✓✓A2, C12, F30
Types of data in cells Ans✓✓✓- text (labels)
- number data (constants)
- formuals (mathematical equations that do all the work)
coding Ans✓✓✓involves grouping and assigning value to various
resposes form the survey instrument
(responses are numerical 0-9)
Dummy Variables Ans✓✓✓You'll have one column in excel and ever a
"1" for females and "0" for males
Central Tendency Ans✓✓✓locates the "center" of a distribution of
values
, Mean Ans✓✓✓arithmetic average
Median Ans✓✓✓middle value of rank ordered distribution
Mode Ans✓✓✓response most often given to a question
nominal scales Ans✓✓✓Ex: Y/N, Freshman/Sophomore/Junior/Sr
Ordinal Scale Ans✓✓✓Ranked preference from 1 to 3
Interval Scale Ans✓✓✓Likert scale with 7 scales (strongly
agree...strongly disagree)
Ratio Scale Ans✓✓✓Ex: age 21
Interval or ratio scaled variables Ans✓✓✓Mean, median, mode
Nominal data and ordinal data Ans✓✓✓-can't compute mean
-can compute median and mode
Dispersion Ans✓✓✓the spread of values around the central tendency
