2024 /2025 | © copyright | This work may not be copied for profit gain | Excel!
WPC 300 Final Exam Questions & 100%
Correct Answers- Latest Test | Graded A+ |
Passed
In an agile approach of analytics what is the first step of the process?
✓ -:- Perform business discovery
In an ETL process, data is loaded into a final target database such as:
✓ -:- Data warehouse
What are the four types of data analytical method?
✓ -:- Descriptive, explanatory, predictive and prescriptive
Which of the following is an example of secondary data?
✓ -:- Firm's proprietary data
Which of the following data analysis models use optimization techniques?
✓ -:- Prescriptive analytics
1|Page | Grade A+| 2024/2025
,2024 /2025 | © copyright | This work may not be copied for profit gain | Excel!
Predictive analytics may be applied to __________, which is a set of techniques that use
descriptive data and forecasts to identify the decisions most likely to result in the best
performance.
✓ -:- Prescriptive analytics
Target is examining their online sales data during the pandemic to understand what
happened. Which kind of analytical technique are they using?
✓ -:- Descriptive analytics
Costco wants to know how to stock their warehouses for a future pandemic and are using
current sales data to help them project the needs. Which kind of analytical technique are
they using?
✓ -:- Predictive analytics
Your professor is considering purchasing a self-driving car that can figure out the best route
and the optimum safe way to drive there without human intervention. What kind of
analytics is the car using to do this?
✓ -:- Prescriptive analytics
Which of the following question(s) can be better answered using data in order to reach an
evidence-based conclusion?
2|Page | Grade A+| 2024/2025
, 2024 /2025 | © copyright | This work may not be copied for profit gain | Excel!
✓ -:- All of the answer selections are correct.
Deleting the grid lines in a chart
✓ -:- Increases the data-ink ratio
When the lie-factor of a graphical chart is more than 1,
✓ -:- the size of the effect shown in the graph is bigger than the actual effect in the
data.
Which are useful principles for data visualization?
✓ -:- The graph suggests a possible true effect
Which of the following statement(s) about charts is false?
✓ -:- None of the other answers are false
In order for a chart to have graphical integrity, the lie factor must be:
✓ -:- close to 1
What best describes the nature of a rose diagram?
3|Page | Grade A+| 2024/2025
WPC 300 Final Exam Questions & 100%
Correct Answers- Latest Test | Graded A+ |
Passed
In an agile approach of analytics what is the first step of the process?
✓ -:- Perform business discovery
In an ETL process, data is loaded into a final target database such as:
✓ -:- Data warehouse
What are the four types of data analytical method?
✓ -:- Descriptive, explanatory, predictive and prescriptive
Which of the following is an example of secondary data?
✓ -:- Firm's proprietary data
Which of the following data analysis models use optimization techniques?
✓ -:- Prescriptive analytics
1|Page | Grade A+| 2024/2025
,2024 /2025 | © copyright | This work may not be copied for profit gain | Excel!
Predictive analytics may be applied to __________, which is a set of techniques that use
descriptive data and forecasts to identify the decisions most likely to result in the best
performance.
✓ -:- Prescriptive analytics
Target is examining their online sales data during the pandemic to understand what
happened. Which kind of analytical technique are they using?
✓ -:- Descriptive analytics
Costco wants to know how to stock their warehouses for a future pandemic and are using
current sales data to help them project the needs. Which kind of analytical technique are
they using?
✓ -:- Predictive analytics
Your professor is considering purchasing a self-driving car that can figure out the best route
and the optimum safe way to drive there without human intervention. What kind of
analytics is the car using to do this?
✓ -:- Prescriptive analytics
Which of the following question(s) can be better answered using data in order to reach an
evidence-based conclusion?
2|Page | Grade A+| 2024/2025
, 2024 /2025 | © copyright | This work may not be copied for profit gain | Excel!
✓ -:- All of the answer selections are correct.
Deleting the grid lines in a chart
✓ -:- Increases the data-ink ratio
When the lie-factor of a graphical chart is more than 1,
✓ -:- the size of the effect shown in the graph is bigger than the actual effect in the
data.
Which are useful principles for data visualization?
✓ -:- The graph suggests a possible true effect
Which of the following statement(s) about charts is false?
✓ -:- None of the other answers are false
In order for a chart to have graphical integrity, the lie factor must be:
✓ -:- close to 1
What best describes the nature of a rose diagram?
3|Page | Grade A+| 2024/2025
