Analytics, 5th Edition by Jeffrey D. Camm,
James J. Cochran, Michael J. Fry, Jeffrey W.
Ohlmann; ISBN13: 9780357902202. (Full
Chapters included Chapter 1 to 17).
Excel solutions included... 1. Introduction. 2. Descriptive Statistics. 3. Data
Visualization. 4. Data Wrangling. 5. Probability: An Introduction to Modeling
Uncertainty. 6. Descriptive Data Mining. 7. Statistical Inference. 8. Linear
Regression. 9. Time Series Analysis and Forecasting. 10. Predictive Data Mining:
Regression. 11. Predictive Data Mining: Classification. 12. Spreadsheet Modeling.
13. Monte Carlo Simulation. 14. Linear Optimization Models. 15. Integer Linear
Optimization Models. 16. Nonlinear Optimization Models. 17. Decision Analysis
,Question 1:
Which of the following best describes the primary goal of descriptive analytics?
a) To predict future outcomes based on historical data.
b) To identify relationships and patterns in past data.
c) To determine the best course of action given a set of constraints.
d) To automate decision-making processes.
Answer: b) To identify relationships and patterns in past data.
Question 2:
A company wants to understand the likelihood of customers churning within the
next quarter. Which type of analytics would be most appropriate for this task?
a) Descriptive analytics
b) Diagnostic analytics
, c) Predictive analytics
d) Prescriptive analytics
Answer: c) Predictive analytics
Question 3:
What is the purpose of data visualization in business analytics?
a) To perform complex statistical calculations.
b) To store and manage large datasets.
c) To communicate insights and patterns in an easily understandable format.
d) To ensure data accuracy and integrity.
Answer: c) To communicate insights and patterns in an easily understandable
format.
Question 4:
Which of the following is a common technique used in prescriptive analytics?
a) Regression analysis
b) Cluster analysis
c) Simulation
d) Hypothesis testing