Business Analytics and Operations Research Worksheet

Which of the following best describes the role of quantitative techniques in business analytics?

• Replacing managerial judgment entirely

• Providing data-driven support for decision-making

• Focusing only on financial data

• Eliminating uncertainty in business

In business analytics, integration of quantitative techniques primarily helps in:

• Increasing employee satisfaction

• Improving decision accuracy and efficiency

• Reducing organizational hierarchy

• Enhancing brand image

Which tool in Microsoft Excel is commonly used for solving optimization problems in operations research?

• Pivot Table

• Goal Seek

• Solver

• Data Validation

The Excel Solver tool is mainly used to:

• Create charts and graphs

• Perform data cleaning

• Find optimal solutions under constraints

• Store large datasets

Which programming language is widely used for statistical computing and data visualization in business analytics?

• Java

• C++

• R

• HTML

In operations research, Python is preferred because it:

• Is only used for web development

• Has powerful libraries for optimization and analysis

• Cannot handle large datasets

• Is slower than manual calculations

Prescriptive analytics primarily focuses on:

• Describing past data

• Predicting future trends

• Recommending actions for decision-making

• Storing business data

Which of the following is a key benefit of prescriptive analytics?

• It ignores constraints

• It provides actionable recommendations

• It only analyzes historical data

• It avoids the use of models

The integration of tools like Excel, R, and Python in operations research helps organizations to:

• Eliminate the need for managers

• Automate and enhance complex decision-making processes

• Reduce the use of data

• Focus only on qualitative analysis

Which type of analytics combines optimization models with business rules to suggest the best course of action?

• Descriptive analytics

• Diagnostic analytics

• Predictive analytics

• Prescriptive analytics