WPC 300 LATEST EXAM TEST 2026/2027 QUESTIONS AND
SOLUTIONS RATED A+
✔✔Significance F - ✔✔This is the p-value for the null hypothesis that the model as a
whole is irrelevant. Null hypothesis can't be rejected and all coefficients are zero
✔✔Adjusted R-squared - ✔✔correlation coefficient squared and adjusted for the
number of independent variables used to make the estimate
✔✔Sensitivity Analysis - ✔✔a special case of what-if analysis, is the study of the impact
on other variables when one variable is changed repeatedly
✔✔wisdom of crowds - ✔✔under the right circumstances, groups are smarter than the
smartest people in them, meaning that large numbers of consumers can predict
successful products
✔✔Data visualization principles - ✔✔tell a story, graphical integrity, minimize graphical
complexity
✔✔Focuses of visualizations - ✔✔Conceptual- Ideas. Teach and simplify
Data-driven- Stats, machine learning. Inform and enlighten
Declarative- Documenting and designing. Affirm.
Exploratory- Prototyping. Discover.
✔✔Everyday dataviz - ✔✔INFO TYPE: Simple, low volume
TYPICAL SETTING: Formal, presentations
PRIMARY SKILLS: Design, storytelling
GOALS: Affirming, setting context
✔✔Visual structure - ✔✔Situation -> Observations -> Resolutions (recommendations)
✔✔Bar chart - ✔✔A form of graph in which numeric values are represented by
horizontal or vertical rectangles. Used to compare items
✔✔Column chart - ✔✔a chart that uses bars of varying height to illustrate values in a
worksheet. Compares items especially good for tracking over time
✔✔Pie Chart - ✔✔Used to show percentages of part to the whole
✔✔Line chart - ✔✔Show trends over time
✔✔Combo chart - ✔✔Chart that contains two chart types, such as column and line, to
depict two types of data, such as individual data points and percentages.
, ✔✔Radar chart - ✔✔compares aggregate values of three or more variables represented
on axes starting from the same point
✔✔Tree maps - ✔✔are good for showing hierarchical information, such as when
illustrating the hierarchy chart of employees in a company.
✔✔Scatter plot - ✔✔A graph with points plotted to show a possible relationship between
two sets of data.
✔✔Box and whisker - ✔✔A graph that displays the highest and lowest quarters of data
as whiskers, the middle two quarters of the data as a box, and the median
✔✔Histogram - ✔✔A graph of vertical bars representing the frequency distribution of a
set of data.
✔✔Your quality of synthesis affects the quality of your - ✔✔decision-making
✔✔One-Day Answer - ✔✔Uses situation, observations, and implications to reason thru
it. Clarify which understandings are emerging and what the unknowns still are
✔✔deductive reasoning - ✔✔reasoning in which a conclusion is reached by stating a
general principle and then applying that principle to a specific case (The sun rises every
morning; therefore, the sun will rise on Tuesday morning.)
✔✔indeductive reasoning - ✔✔using specific observations to make generalizations
✔✔Revealed approach - ✔✔Provide evidence for each yes/no & reveal the answer.
Best for difficult audiences.
✔✔Bin range - ✔✔List of values that specifies low and high values for each column in a
histogram.
✔✔Area chart - ✔✔plots a category as it changes and trends over time
✔✔waterfall chart - ✔✔used to track the effect of adding and subtracting values within a
sum
✔✔Sparkline Chart - ✔✔Provides a simple way to show trends and variations in a range
of data within a single cell
✔✔Workplan Best Practices - ✔✔-Dont do analyses that are not guided by v clear and
testable hypothesis
-Have a clear understanding of the question
-Do knock-out analysis first
SOLUTIONS RATED A+
✔✔Significance F - ✔✔This is the p-value for the null hypothesis that the model as a
whole is irrelevant. Null hypothesis can't be rejected and all coefficients are zero
✔✔Adjusted R-squared - ✔✔correlation coefficient squared and adjusted for the
number of independent variables used to make the estimate
✔✔Sensitivity Analysis - ✔✔a special case of what-if analysis, is the study of the impact
on other variables when one variable is changed repeatedly
✔✔wisdom of crowds - ✔✔under the right circumstances, groups are smarter than the
smartest people in them, meaning that large numbers of consumers can predict
successful products
✔✔Data visualization principles - ✔✔tell a story, graphical integrity, minimize graphical
complexity
✔✔Focuses of visualizations - ✔✔Conceptual- Ideas. Teach and simplify
Data-driven- Stats, machine learning. Inform and enlighten
Declarative- Documenting and designing. Affirm.
Exploratory- Prototyping. Discover.
✔✔Everyday dataviz - ✔✔INFO TYPE: Simple, low volume
TYPICAL SETTING: Formal, presentations
PRIMARY SKILLS: Design, storytelling
GOALS: Affirming, setting context
✔✔Visual structure - ✔✔Situation -> Observations -> Resolutions (recommendations)
✔✔Bar chart - ✔✔A form of graph in which numeric values are represented by
horizontal or vertical rectangles. Used to compare items
✔✔Column chart - ✔✔a chart that uses bars of varying height to illustrate values in a
worksheet. Compares items especially good for tracking over time
✔✔Pie Chart - ✔✔Used to show percentages of part to the whole
✔✔Line chart - ✔✔Show trends over time
✔✔Combo chart - ✔✔Chart that contains two chart types, such as column and line, to
depict two types of data, such as individual data points and percentages.
, ✔✔Radar chart - ✔✔compares aggregate values of three or more variables represented
on axes starting from the same point
✔✔Tree maps - ✔✔are good for showing hierarchical information, such as when
illustrating the hierarchy chart of employees in a company.
✔✔Scatter plot - ✔✔A graph with points plotted to show a possible relationship between
two sets of data.
✔✔Box and whisker - ✔✔A graph that displays the highest and lowest quarters of data
as whiskers, the middle two quarters of the data as a box, and the median
✔✔Histogram - ✔✔A graph of vertical bars representing the frequency distribution of a
set of data.
✔✔Your quality of synthesis affects the quality of your - ✔✔decision-making
✔✔One-Day Answer - ✔✔Uses situation, observations, and implications to reason thru
it. Clarify which understandings are emerging and what the unknowns still are
✔✔deductive reasoning - ✔✔reasoning in which a conclusion is reached by stating a
general principle and then applying that principle to a specific case (The sun rises every
morning; therefore, the sun will rise on Tuesday morning.)
✔✔indeductive reasoning - ✔✔using specific observations to make generalizations
✔✔Revealed approach - ✔✔Provide evidence for each yes/no & reveal the answer.
Best for difficult audiences.
✔✔Bin range - ✔✔List of values that specifies low and high values for each column in a
histogram.
✔✔Area chart - ✔✔plots a category as it changes and trends over time
✔✔waterfall chart - ✔✔used to track the effect of adding and subtracting values within a
sum
✔✔Sparkline Chart - ✔✔Provides a simple way to show trends and variations in a range
of data within a single cell
✔✔Workplan Best Practices - ✔✔-Dont do analyses that are not guided by v clear and
testable hypothesis
-Have a clear understanding of the question
-Do knock-out analysis first
