Welcome to your Data Analyst
Data Analyst
Which of the following is a key responsibility of a data analyst?
Building neural networks
Collecting, cleaning, and interpreting data
Managing cloud servers
Designing web applications
None
Data Analyst
What does the GROUP BY clause do in SQL?
Aggregates rows based on a column
Sorts rows alphabetically
Filters rows
Deletes duplicate rows
None
Data Analyst
What type of data visualization is best for showing the distribution of a single numeric variable?
Line chart
Histogram
Pie chart
Scatter plot
None
Data Analyst
Which of the following methods is used to handle missing data?
Transformation
Imputation
Duplication
Randomization
None
Data Analyst
In statistics, what does “mean” represent?
Most frequent value
Average value
Middle value
Minimum value
None
Data Analyst
Which function in Pandas is used to remove missing values?
fillna()
clean()
dropna()
replace()
None
Data Analyst
What is the purpose of a pivot table?
To summarize and reorganize data
To visualize relationships
To remove duplicates
To normalize data
None
Data Analyst
Which chart is best for comparing proportions between categories?
Histogram
Box plot
Pie chart
Scatter plot
None
Data Analyst
In SQL, which command is used to combine results from two tables?
MERGE
UNION
INTERSECT
CONNECT
None
Data Analyst
What is the range in statistics?
The median of the dataset
The difference between the largest and smallest values
The most frequent value
The total number of values
None
Data Analyst
What is correlation?
Measure of central tendency
Measure of relationship between two variables
Type of regression
Measure of data dispersion
None
Data Analyst
Which value of correlation coefficient indicates the strongest negative relationship?
0.2
0.8
-0.9
-0.1
None
Data Analyst
Which SQL clause is used to filter data after aggregation?
HAVING
GROUP BY
WHERE
ORDER BY
None
Data Analyst
What is multicollinearity in regression analysis?
Independent variables with low variance
Dependent variable with outliers
Variables that are highly correlated with each other
Data that contains missing values
None
Data Analyst
Which visualization best shows the relationship between two numerical variables?
Pie chart
Heatmap
Scatter plot
Bar chart
None
Data Analyst
What does the p-value represent in hypothesis testing?
The probability of the null hypothesis being true
The total number of samples
The mean of the data
The standard deviation
None
Data Analyst
Which of the following is an example of categorical data?
Temperature
Age
Weight
Country
None
Data Analyst
What is data normalization?
Cleaning text data
Scaling features to a common range
Combining datasets
Adding missing values
None
Data Analyst
Which Python library is best for creating interactive dashboards?
NumPy
Plotly
Seaborn
Matplotlib
None
Data Analyst
What does R² represent in linear regression?
Mean of dependent variable
Variance of residuals
Goodness of fit
Gradient of the slope
None
Data Analyst
Which SQL command is used to update existing records?
REPLACE
CHANGE
UPDATE
MODIFY
None
Data Analyst
What is outlier detection used for?
Finding missing values
Identifying abnormal data points
Normalizing data
Sorting values
None
Data Analyst
In hypothesis testing, what does the null hypothesis state?
Data is normally distributed
There is no relationship between variables
There is a relationship between variables
Variables are independent
None
Data Analyst
What is the main purpose of exploratory data analysis (EDA)?
To understand patterns and insights from data
To build predictive models
To clean data automatically
To train AI models
None
Data Analyst
What is time series analysis mainly used for?
Classifying images
Predicting future trends based on past data
Cleaning text data
Clustering data points
None
Common Jobs
Jobs
Referrals
My Profile
