UCF QMB 3200 Midterm Exam Study
Guide 2024 - Stacey Brook (150 Q&A
+ Excel Formulas) with Detailed
Rationales Already Graded A+ |
2025-2026 Updated
Master the UCF QMB 3200 Midterm with this comprehensive 150-question study bank
tailored for Professor Stacey Brook’s course. This guide covers core conceptual areas including
Descriptive, Predictive, and Prescriptive analytics, Big Data Vs, Probability Laws, and
Discrete/Continuous distributions. Includes exact Excel formula syntax (AVERAGE,
NORM.DIST, BINOM.DIST) and detailed rationales for every answer. Perfect for students
looking for conceptual clarity without manual calculations.
,Part 1: Data Analytics & Big Data
1. Which area of analytics uses optimization models to identify the best possible course of
action?
A. Descriptive
B. Predictive
C. Prescriptive Analytics
D. Diagnostic
Rationale: Prescriptive analytics goes beyond forecasting to recommend specific actions
to achieve an optimal outcome.
2. What term describes analytical techniques that use models constructed from past data
to forecast future events?
A. Predictive Analytics
B. Descriptive Analytics
C. Prescriptive Analytics
D. Big Data
Rationale: Predictive analytics focuses on identifying patterns in historical data to
estimate future occurrences or impacts.
3. A set of data that cannot be managed or processed with common software in a
reasonable amount of time is called:
A. Small Data
B. Big Data
C. Quantitative Data
D. Discrete Data
Rationale: Big data is defined by its volume, velocity, and variety, making it difficult to
process with standard tools.
4. Which "V" of Big Data refers to the speed at which data is collected and processed?
A. Volume
B. Velocity
C. Variety
D. Veracity
Rationale: Velocity relates to the high frequency and rapid rate at which data is
generated and must be handled.
5. The facts and figures collected, analyzed, and summarized for presentation and
interpretation are known as:
A. Information
, B. Statistics
C. Data
D. Variables
Rationale: Data serves as the raw input for all statistical analysis and decision-making
processes.
Part 2: Data Types & Scales
6. Data collected at the same or approximately the same point in time is referred to as:
A. Cross-sectional data
B. Time series data
C. Panel data
D. Nominal data
Rationale: Cross-sectional data captures a "snapshot" of multiple elements at a single
moment.
7. If a researcher tracks the stock price of Apple Inc. daily over the last five years, they are
collecting:
A. Cross-sectional data
B. Categorical data
C. Time series data
D. Discrete data
Rationale: Time series data consists of observations of a single variable taken over
successive points in time.
8. Which type of data uses labels or names to identify an attribute of each element?
A. Quantitative
B. Categorical
C. Continuous
D. Ratio
Rationale: Categorical data (also called qualitative) groups elements into non-numeric
categories.
9. Which scale of measurement has all the properties of interval data, and the ratio of two
values is meaningful?
A. Nominal
B. Ordinal
C. Interval
D. Ratio
, Rationale: The ratio scale is the highest level of measurement and includes a true zero
point, allowing for multiplication and division.
10. A characteristic of interest for the elements in a study is called a(n):
A. Observation
B. Variable
C. Dataset
D. Sample
Rationale: A variable is the specific trait (e.g., height, price) being measured for the
elements.
Part 3: Descriptive Statistics & Excel Formulas
11. Which Excel formula is used to calculate the arithmetic mean of a range?
A. =MEAN(range)
B. =AVERAGE(range)
C. =MEDIAN(range)
D. =SUM(range)
Rationale: In Excel, the =AVERAGE() function computes the sum of values divided by the
count.
12. To find the middle value in a dataset that has been arranged in ascending order, which
Excel formula should be used?
A. =MODE.SNGL(range)
B. =AVERAGE(range)
C. =MEDIAN(range)
D. =STDEV.S(range)
Rationale: The =MEDIAN() function identifies the 50th percentile or middle value.
13. Which of the following is NOT resistant to outliers in a dataset?
A. Median
B. Mean
C. Interquartile Range
D. Mode
Rationale: The mean is highly sensitive to extreme values (outliers) because it
incorporates every value into the calculation.
14. The difference between the largest and smallest data values is the:
A. Variance
B. Standard Deviation
C. Range
Guide 2024 - Stacey Brook (150 Q&A
+ Excel Formulas) with Detailed
Rationales Already Graded A+ |
2025-2026 Updated
Master the UCF QMB 3200 Midterm with this comprehensive 150-question study bank
tailored for Professor Stacey Brook’s course. This guide covers core conceptual areas including
Descriptive, Predictive, and Prescriptive analytics, Big Data Vs, Probability Laws, and
Discrete/Continuous distributions. Includes exact Excel formula syntax (AVERAGE,
NORM.DIST, BINOM.DIST) and detailed rationales for every answer. Perfect for students
looking for conceptual clarity without manual calculations.
,Part 1: Data Analytics & Big Data
1. Which area of analytics uses optimization models to identify the best possible course of
action?
A. Descriptive
B. Predictive
C. Prescriptive Analytics
D. Diagnostic
Rationale: Prescriptive analytics goes beyond forecasting to recommend specific actions
to achieve an optimal outcome.
2. What term describes analytical techniques that use models constructed from past data
to forecast future events?
A. Predictive Analytics
B. Descriptive Analytics
C. Prescriptive Analytics
D. Big Data
Rationale: Predictive analytics focuses on identifying patterns in historical data to
estimate future occurrences or impacts.
3. A set of data that cannot be managed or processed with common software in a
reasonable amount of time is called:
A. Small Data
B. Big Data
C. Quantitative Data
D. Discrete Data
Rationale: Big data is defined by its volume, velocity, and variety, making it difficult to
process with standard tools.
4. Which "V" of Big Data refers to the speed at which data is collected and processed?
A. Volume
B. Velocity
C. Variety
D. Veracity
Rationale: Velocity relates to the high frequency and rapid rate at which data is
generated and must be handled.
5. The facts and figures collected, analyzed, and summarized for presentation and
interpretation are known as:
A. Information
, B. Statistics
C. Data
D. Variables
Rationale: Data serves as the raw input for all statistical analysis and decision-making
processes.
Part 2: Data Types & Scales
6. Data collected at the same or approximately the same point in time is referred to as:
A. Cross-sectional data
B. Time series data
C. Panel data
D. Nominal data
Rationale: Cross-sectional data captures a "snapshot" of multiple elements at a single
moment.
7. If a researcher tracks the stock price of Apple Inc. daily over the last five years, they are
collecting:
A. Cross-sectional data
B. Categorical data
C. Time series data
D. Discrete data
Rationale: Time series data consists of observations of a single variable taken over
successive points in time.
8. Which type of data uses labels or names to identify an attribute of each element?
A. Quantitative
B. Categorical
C. Continuous
D. Ratio
Rationale: Categorical data (also called qualitative) groups elements into non-numeric
categories.
9. Which scale of measurement has all the properties of interval data, and the ratio of two
values is meaningful?
A. Nominal
B. Ordinal
C. Interval
D. Ratio
, Rationale: The ratio scale is the highest level of measurement and includes a true zero
point, allowing for multiplication and division.
10. A characteristic of interest for the elements in a study is called a(n):
A. Observation
B. Variable
C. Dataset
D. Sample
Rationale: A variable is the specific trait (e.g., height, price) being measured for the
elements.
Part 3: Descriptive Statistics & Excel Formulas
11. Which Excel formula is used to calculate the arithmetic mean of a range?
A. =MEAN(range)
B. =AVERAGE(range)
C. =MEDIAN(range)
D. =SUM(range)
Rationale: In Excel, the =AVERAGE() function computes the sum of values divided by the
count.
12. To find the middle value in a dataset that has been arranged in ascending order, which
Excel formula should be used?
A. =MODE.SNGL(range)
B. =AVERAGE(range)
C. =MEDIAN(range)
D. =STDEV.S(range)
Rationale: The =MEDIAN() function identifies the 50th percentile or middle value.
13. Which of the following is NOT resistant to outliers in a dataset?
A. Median
B. Mean
C. Interquartile Range
D. Mode
Rationale: The mean is highly sensitive to extreme values (outliers) because it
incorporates every value into the calculation.
14. The difference between the largest and smallest data values is the:
A. Variance
B. Standard Deviation
C. Range
