-
web.groovymark@gmail.com
- November 21, 2024
Question 41
When should you use a line chart over a bar chart?
a) When comparing categorical data
b) When illustrating parts of a whole
c) When displaying data trends over time
d) When showing frequencies of categories
Correct Answer: c) When displaying data trends over time
Explanation: Line charts are ideal for showing how data points change over time, making them suitable for trend analysis
Question 42
Which Excel function would you use to remove duplicates from a dataset?
a) UNIQUE
b) REMOVE
c) DELETE
d) DISTINCT
Correct Answer: a) UNIQUE
Explanation: The UNIQUE function identifies and extracts distinct values from a range, effectively removing duplicates for cleaner data analysis.
Question 43
What is the role of the “File” menu in Excel?
a) To format data
b) To perform calculations
c) To manage workbooks and document settings
d) To create charts
Correct Answer: c) To manage workbooks and document settings
Explanation: The File menu provides options for opening, saving, and manipulating workbooks, as well as adjusting document properties and settings.
Question 44
Which of the following describes “non-probability sampling”?
a) Each member has an equal chance of selection.
b) Selection is based on the researcher’s judgment.
c) It always results in a larger sample size.
d) It is the most reliable sampling method.
Correct Answer: b) Selection is based on the researcher's judgment.
Explanation: Non-probability sampling relies on the researcher’s discretion to select samples, which can introduce bias and affect the representativeness of the data.
Question 45
What is the primary function of a “data dashboard”?
a) To store raw data
b) To provide real-time visualizations of key performance indicators
c) To analyze datasets
d) To perform statistical tests
Correct Answer: b) To provide real-time visualizations of key performance indicators
Explanation: Data dashboards aggregate and visually present key metrics and performance indicators, enabling quick insights and decision-making.
Question 46
Which type of analysis would be best for understanding the impact of one variable on another?
a) Descriptive analysis
b) Correlational analysis
c) Causal analysis
d) Exploratory analysis
Correct Answer: c) Causal analysis
Explanation: Causal analysis examines the cause-and-effect relationship between variables, helping to determine how one variable influences another.
Question 47
What does the term “skewness” refer to in statistics?
a) The average of a dataset
b) The measure of symmetry of the distribution
c) The total count of observations
d) The variability in data
Correct Answer: b) The measure of symmetry of the distribution
Explanation: Skewness indicates the direction and degree of asymmetry in a data distribution, revealing whether data points are concentrated on one side of the mean.
Question 48
When creating a bar chart, what do the lengths of the bars represent?
a) Categories of data
b) Frequency or values of the data
c) Average of the data
d) Median of the data
Correct Answer: b) Frequency or values of the data
Explanation: In a bar chart, the length of each bar corresponds to the frequency or value of the category it represents, allowing for easy comparison between categories.
Question 49
How can Excel’s “PivotTable” be best utilized?
a) To perform calculations on single data points
b) To visualize trends over time
c) To summarize and analyze large datasets effectively
d) To enter and store raw data
Correct Answer: c) To summarize and analyze large datasets effectively
Explanation: PivotTables allow users to dynamically summarize and analyze large amounts of data by reorganizing it into a more understandable format.
Question 50
What is the purpose of using a frequency distribution table?
a) To show raw data without summarization
b) To summarize and categorize data based on frequency of occurrence
c) To display data in graphical format
d) To perform complex calculations on data
Correct Answer: b) To summarize and categorize data based on frequency of occurrence
Explanation: A frequency distribution table organizes data into categories, allowing for quick identification of how many observations fall into each category.
