Mastering Data Analysis Concepts

What is the mean in descriptive statistics?

• The mean is the mode of a set of numbers.

• The mean is the median of a set of numbers.

• The mean is the average of a set of numbers.

• The mean is the range of a set of numbers.

Which chart is best for showing the distribution of data?

• Histogram

• Pie Chart

• Scatter Plot

• Line Graph

Maya is working on a project that involves analyzing customer feedback data. What is the purpose of data cleaning?

• The purpose of data cleaning is to improve data quality and ensure accuracy for analysis.

• To increase the amount of data collected.

• To create new data points for analysis.

• To simplify the data storage process.

How do you calculate the median in Excel?

• Use the formula =MEDIAN(range) in Excel.

• Calculate the median by sorting the data first.

• Use the formula =AVERAGE(range) in Excel.

• Use the formula =SUM(range) in Excel.

What function in SQL is used to count records?

• AVG()

• SUM()

• COUNT()

• MAX()

How can you remove duplicates in Excel?

• Use the 'Remove Duplicates' feature in the 'Data' tab.

• Copy the data to a new sheet and remove duplicates there.

• Manually delete each duplicate entry.

• Use the 'Sort' feature in the 'Data' tab.

What SQL command is used to retrieve data from a database?

• SELECT

• DELETE

• UPDATE

• INSERT

What type of graph would you use to compare categories?

• Bar graph

• Scatter plot

• Pie chart

• Line graph

Which type of chart is most effective for showing trends over time?

• Line Graph

• Bar Graph

• Pie Chart

• Histogram

What is the purpose of using pivot tables in data analysis?

• To summarize and analyze data efficiently.

• To create visual representations of data.

• To store large datasets.

• To perform complex calculations.