STATISTICS FOR MANAGERS USING
MICROSOFT EXCEL PRACTICE EXAM 2026
PREMIUM QUESTIONS AND ACCURATE
ANSWERS ONE HUNDRED PERCENT CORRECT
◉ data is a set of n observations in one
variable, e.g., height of Grade 3 pupils, GWA of
second year students, etc.
Answer: Univariate
◉ data is a set of n observations
involving two variables, e.g., height and weight
of newly born babies, monthly income and
expenses of selected employees.
Answer: Bivariate
◉ More than 2 Variables.
Answer: Multivariate
◉ In Organizing Univariate Categorical Data what are the different
visual tools which will allow us to present data with one variable?.
, Answer: summary table
bar chart,
pie chart
◉ this table indicates the frequency,
amount, or percentage of items in a set of
categories so that you can see differences
between categories..
Answer: summary table
◉ In Organizing bivariate Categorical Data what are the different
visual tools which will allow us to present data with two variable?.
Answer: Cross Tabulation (Contingency Table)
A side-by-side bar chart
◉ presents the joint distribution of two categorical variables.
Rows represent categories of one variable
Columns represent categories of the second variable
Each cell shows the frequency for a specific category combination.
Answer: Cross Tabulation (Contingency Table)
◉ When to use a specific graph?:
MICROSOFT EXCEL PRACTICE EXAM 2026
PREMIUM QUESTIONS AND ACCURATE
ANSWERS ONE HUNDRED PERCENT CORRECT
◉ data is a set of n observations in one
variable, e.g., height of Grade 3 pupils, GWA of
second year students, etc.
Answer: Univariate
◉ data is a set of n observations
involving two variables, e.g., height and weight
of newly born babies, monthly income and
expenses of selected employees.
Answer: Bivariate
◉ More than 2 Variables.
Answer: Multivariate
◉ In Organizing Univariate Categorical Data what are the different
visual tools which will allow us to present data with one variable?.
, Answer: summary table
bar chart,
pie chart
◉ this table indicates the frequency,
amount, or percentage of items in a set of
categories so that you can see differences
between categories..
Answer: summary table
◉ In Organizing bivariate Categorical Data what are the different
visual tools which will allow us to present data with two variable?.
Answer: Cross Tabulation (Contingency Table)
A side-by-side bar chart
◉ presents the joint distribution of two categorical variables.
Rows represent categories of one variable
Columns represent categories of the second variable
Each cell shows the frequency for a specific category combination.
Answer: Cross Tabulation (Contingency Table)
◉ When to use a specific graph?:
