NEW
Font size
WorksheetsBusiness Analytics Quiz
Total questions: 50
Worksheet time: 17mins
What is the primary goal of business analytics?
To replace human decision-making
To transform data into actionable insights
To increase data storage costs
To eliminate the need for data collection
Which of the following is NOT a type of analytics?
Descriptive
Predictive
Prescriptive
Speculative
Structured data refers to:
Data with no predefined format
Data organized in a fixed schema (e.g., tables)
Data collected from social media only
Data that can be analyzed
Data governance ensures:
Data quality and compliance
Faster data processing
Reducing data volume
Ignoring privacy laws
Which functional area uses analytics for customer segmentation?
Finance
Marketing
Human Resources
Operations
Which is a key challenge in data quality?
Missing values
High data volume
Fast processing speed
Colorful visualizations
Descriptive analytics answers:
"What happened?"
"What will happen?"
"What should we do?"
"Why ignore data?"
Data quality dimensions include:
Accuracy and completeness
Speed and cost
Color and font size
Number of spreadsheets
Ethical data use requires:
Ignoring user consent
Obtaining user consent
Hiding data sources
Selling raw data
Which is NOT a business analytics application?
Sentiment analysis
Fraud detection
Hardware repair
Demand forecasting
RDBMS stands for:
Relational Database Management System
Random Data Benchmarking System
Rapid Data Backup Method
Raw Data Business Model
Effective data visualization should:
Complicate the message
Simplify complex data
Use only text
Exclude labels
A bar chart is best for:
Highlighting outliers
Showing trends over time
Displaying correlations
Comparing categories
Which is a principle of good visualization?
Clutter
Clarity
Monochrome colors
Large fonts
A heatmap shows:
Intensity of values via color
Only text data
Geographical maps
Future predictions
ETL stands for:
Edit, Transfer, Loop
Enter, Track, Leave
Extract, Transform, Load
Export, Tag, Label
A primary key in a database:
Is always a text field
Uniquely identifies a record
Repeats across tables
Is optional
Which tool is NOT used for visualization?
Matplotlib
MySQL
Tableau
Power BI
A scatter plot shows:
Relationships between two variables
Only categorical data
Time-series trends
Hierarchical data
Data normalization reduces:
Data redundancy
Data volume
Data security
Data visualization
Measures of central tendency include:
Mean, median, mode
Variance, standard deviation
Correlation, covariance
Range, quartiles
Standard deviation measures:
The average value of a dataset
Data spread around the mean
Data entry speed
Number of outliers
Seasonality in data refers to:
Data entry errors
Random fluctuations
Repeating patterns at fixed intervals
Constant trends
A moving average helps to:
Ignore trends
Increase data variability
Delete historical data
Smooth out short-term fluctuations
Which is NOT a measure of dispersion?
Range
Mean
Variance
Standard deviation
Exploratory data analysis (EDA) aims to:
Delete raw data
Build predictive models
Discover patterns and anomalies
Create dashboards
A skewed distribution has:
A longer tail on one side
Perfect symmetry
No outliers
Uniform spread
Outliers in data can:
Distort analysis results
Improve model accuracy
Have no impact
Replace missing values
Which is a time series forecasting method?
A/B testing
ARIMA
K-means clustering
Sentiment analysis
A correlation coefficient ranges from:
-∞ to +∞
0 to 100
-1 to +1
1 to 10
Predictive modeling aims to:
Summarize past data
Forecast future outcomes
Delete raw data
Create visualizations
Simple linear regression involves:
Multiple independent variables
One independent variable
No dependent variables
Only categorical data
Which metric evaluates regression models?
P-value
R-squared
Mean absolute error
All of the above
Random forests improve accuracy by:
Using a single tree
Combining multiple trees
Ignoring features
Reducing data volume
Clustering groups data by:
Time stamps
Similarity
Data size
Randomness
Which is a classification algorithm?
Linear regression
ARIMA
Logistic regression
K-means
Overfitting occurs when a model:
Performs well on training data but poorly on test data
Ignores all features
Uses too little data
Has high bias
A confusion matrix evaluates:
Regression models
Classification models
Clustering models
Data storage
Which technique handles imbalanced datasets?
Oversampling
Deleting minority classes
Ignoring the issue
Using linear regression
Feature selection helps to:
Increase model complexity
Remove irrelevant features
Add noise
Ignore data quality
Python is commonly used in business analytics for:
Data manipulation
Hardware design
Graphic design
Writing novels
Pandas is used for:
Data visualization
Data manipulation (e.g., DataFrames)
Machine learning only
Web scraping only
NumPy is optimized for:
Text processing
Numerical operations
Creating PowerPoint slides
Database design
Which Python library is NOT for analytics?
Scikit-learn
TensorFlow
Pygame
Pandas
SQL is used to:
Query databases
Create visualizations
Build machine learning models
Edit images
API stands for:
Automated Program Interface
Application Programming Interface
Analytical Performance Index
Advanced Predictive Insights
Which is a data wrangling task?
Cleaning missing values
Building dashboards
Writing reports
Designing logos
Which is a limitation of Excel for analytics?
Handles small datasets only
Lacks visualization options
Cannot perform calculations
Too expensive
Which Python method reads CSV files?
open_csv()
read_csv()
import_csv()
load_csv()
Which is a key skill for a business analyst?
Hardware repair
Graphic design
Data storytelling
Music composition
