WGU D388 · Fundamentals of Spreadsheets and Data Presentations
WGU D388 Practice Questions – Set 2
50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.
0/50 answered0 correct
Question 1 of 50
Which of the following best defines a “sample” in statistics?
Correct answer: B) A small portion of the population
Explanation: A sample refers to a subset drawn from a larger population, allowing for statistical analysis without needing to study the entire population.
Question 2 of 50
In statistical terms, what is a “parameter”?
Correct answer: B) A numerical characteristic of a population
Explanation: A parameter is a numerical value that describes an entire population, while a statistic describes a sample.
Question 3 of 50
Which type of variable can take on an infinite number of values between any two observed values?
Correct answer: B) Continuous variable
Explanation: Continuous variables can assume an infinite number of values within a range, such as height or temperature.
Question 4 of 50
What is an example of categorical data?
Correct answer: C) Marital status
Explanation: Categorical data represents characteristics or qualities, such as marital status, which can be classified into groups.
Question 5 of 50
What is the purpose of the ordinal scale in measurement?
Correct answer: B) To rank data in a specific order
Explanation: The ordinal scale arranges categories in a meaningful order, but the differences between them are not quantifiable.
Question 6 of 50
In data analysis, what does “sampling” refer to?
Correct answer: B) Taking a subset from the population for analysis
Explanation: Sampling is the process of selecting a portion of the population to represent the whole, facilitating data analysis without requiring complete data.
Question 7 of 50
What is the main difference between probability sampling and non-probability sampling?
Correct answer: C) In probability sampling, every member has a chance of selection.
Explanation: Probability sampling ensures that every member of the population has an equal chance of being selected, enhancing the representativeness of the sample.
Question 8 of 50
What does a frequency distribution table show?
Correct answer: B) The number of occurrences of each category
Explanation: A frequency distribution table organizes data by categories and shows how many observations fall into each category.
Question 9 of 50
When presenting data graphically, which chart type is best for showing trends over time?
Correct answer: C) Line chart
Explanation: Line charts effectively display data points over time, allowing viewers to see trends and changes across intervals.
Question 10 of 50
What is the function of a “legend” in a chart?
Correct answer: B) To explain the data series represented
Explanation: The legend identifies different data series in a chart, helping viewers understand what each color or pattern represents.
Question 11 of 50
In Excel, which function would you use to remove extra spaces from a text string?
Correct answer: A) TRIM
Explanation: The TRIM function eliminates unnecessary spaces from text, making it cleaner for analysis and presentation.
Question 12 of 50
Which of the following is a characteristic of the median?
Correct answer: C) It represents the middle value in a sorted dataset.
Explanation: The median is the value that separates the higher half from the lower half of a dataset, providing a measure of central tendency that is not affected by outliers.
Question 13 of 50
When calculating the range of a dataset, which formula would you use?
Correct answer: A) Highest value – Lowest value
Explanation: The range is calculated by subtracting the smallest value from the largest value, indicating the spread of the dataset.
Question 14 of 50
What does the “cumulative frequency” in a frequency distribution indicate?
Correct answer: C) The running total of frequencies up to a specific point
Explanation: Cumulative frequency tracks the total number of observations that fall below or at each category, aiding in understanding data distribution.
Question 15 of 50
How can you calculate the weighted mean?
Correct answer: B) By applying different weights to different values before calculating the average
Explanation: The weighted mean accounts for the importance of each value by multiplying each value by its respective weight and then dividing by the total of the weights.
Question 16 of 50
In the context of statistics, what is an “outlier”?
Correct answer: B) A value that significantly deviates from other observations
Explanation: Outliers are extreme values that can skew data analysis and interpretations, necessitating careful examination.
Question 17 of 50
Which Excel function would you use to display the average of a range of cells?
Correct answer: C) =AVERAGE
Explanation: The AVERAGE function computes the mean of a specified range of numbers, providing a summary measure of central tendency.
Question 18 of 50
In statistical analysis, what does “inferential statistics” involve?
Correct answer: B) Making predictions or inferences about a population based on sample data
Explanation: Inferential statistics employs techniques that allow researchers to draw conclusions about a population based on observations from a sample.
Question 19 of 50
What does the term “data validation” refer to in Excel?
Correct answer: B) Restricting the type of data entered into a cell
Explanation: Data validation helps maintain data integrity by limiting the type of information that can be entered into a cell, preventing errors.
Question 20 of 50
When using the “Sort” feature in Excel, what is the result?
Correct answer: B) Data is rearranged in a specific order based on selected criteria.
Explanation: The Sort feature organizes data within a worksheet according to specified parameters, such as alphabetical or numerical order.
Question 21 of 50
Which of the following describes “quantitative data”?
Correct answer: B) Data that represents numerical values suitable for calculations
Explanation: Quantitative data involves measurable quantities that can be used in statistical calculations, like sums and averages.
Question 22 of 50
What is the main advantage of using multi-stage sampling?
Correct answer: C) It enables sampling across large and diverse populations.
Explanation: Multi-stage sampling is effective for large populations as it allows researchers to break down the sampling process into manageable stages, enhancing representativeness.
Question 23 of 50
How does a pie chart represent data?
Correct answer: B) As a percentage of a whole
Explanation: A pie chart visually represents parts of a whole, illustrating how each category contributes to the total by displaying data in proportionate slices.
Question 24 of 50
What is the purpose of using “conditional formatting” in Excel?
Correct answer: C) To visually highlight cells based on specific criteria
Explanation: Conditional formatting allows users to apply visual styles to cells that meet certain conditions, making it easier to identify trends, patterns, or anomalies in data.
Question 25 of 50
Which statistical method is primarily used to identify the relationship between two variables?
Correct answer: C) Correlation analysis
Explanation: Correlation analysis examines the strength and direction of the relationship between two variables, helping to identify patterns and potential causations.
Question 26 of 50
When analyzing a dataset, what does the term “variance” refer to?
Correct answer: B) A measure of how much data points differ from the mean
Explanation: Variance quantifies the dispersion of data points around the mean, indicating the degree of variability within the dataset.
Question 27 of 50
In Excel, what does the COUNTA function do?
Correct answer: B) Counts all non-empty cells in a range
Explanation: The COUNTA function tallies all cells that contain any data, regardless of the type, providing a count of non-empty cells.
Question 28 of 50
What does a histogram display?
Correct answer: C) The distribution of data points over specified intervals
Explanation: A histogram visually represents the frequency distribution of data points across defined intervals (bins), illustrating how data is distributed.
Question 29 of 50
Which of the following is a key feature of a scatter plot?
Correct answer: B) It displays data points in relation to two variables.
Explanation: Scatter plots plot individual data points on a two-dimensional graph, allowing for the visualization of relationships and patterns between two variables.
Question 30 of 50
When should you apply “data cleaning” to a dataset?
Correct answer: B) When preparing data for analysis
Explanation: Data cleaning ensures accuracy and consistency by identifying and correcting errors or inconsistencies in the dataset before analysis begins.
Question 31 of 50
In which scenario would you use a stratified sampling technique?
Correct answer: C) When the population is diverse and varied
Explanation: Stratified sampling is beneficial when the population has distinct subgroups (strata) that need to be represented accurately in the sample.
Question 32 of 50
How can outliers affect statistical analysis?
Correct answer: B) They can skew averages and misrepresent data trends.
Explanation: Outliers can disproportionately influence summary statistics like the mean, leading to misleading conclusions if not properly managed.
Question 33 of 50
Which Excel function allows you to concatenate text strings?
Correct answer: B) CONCATENATE
Explanation: The CONCATENATE function combines multiple text strings into one, allowing for the creation of more complex text entries in Excel.
Question 34 of 50
What does the term “data parsing” refer to in the context of data analysis?
Correct answer: B) Separating and structuring data for analysis
Explanation: Data parsing involves breaking down data into manageable parts and organizing it, making it ready for further analysis.
Question 35 of 50
When would you use the “SUMIF” function in Excel?
Correct answer: B) To conditionally sum values based on specific criteria
Explanation: The SUMIF function allows users to sum values in a range that meet defined conditions, providing more targeted aggregation of data.
Question 36 of 50
What is the key characteristic of descriptive statistics?
Correct answer: B) It summarizes and describes characteristics of a dataset.
Explanation: Descriptive statistics encompasses methods for summarizing and presenting data, such as calculating means and standard deviations, without inferring conclusions about the population.
Question 37 of 50
How do you calculate the standard deviation in a dataset?
Correct answer: B) By calculating the square root of the variance
Explanation: The standard deviation measures data dispersion by determining how spread out values are from the mean, and it is derived from the variance.
Question 38 of 50
In Excel, what does the VLOOKUP function do?
Correct answer: B) Looks up a value in a table and returns a corresponding value
Explanation: The VLOOKUP function searches for a value in the first column of a table and returns a corresponding value from a specified column in the same row.
Question 39 of 50
What does “data normalization” refer to?
Correct answer: C) Adjusting values to a common scale without distorting differences
Explanation: Data normalization helps make datasets comparable by adjusting values to a standard range, which is especially useful in statistical analyses and machine learning.
Question 40 of 50
What is the key function of a calculated column in Excel?
Correct answer: B) To automatically apply a formula to an entire column
Explanation: A calculated column uses a single formula applied to every cell in that column, ensuring consistent calculations across all rows.
Question 41 of 50
When should you use a line chart over a bar chart?
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 of 50
Which Excel function would you use to remove duplicates from a dataset?
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 of 50
What is the role of the “File” menu in Excel?
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 of 50
Which of the following describes “non-probability sampling”?
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 of 50
What is the primary function of a “data dashboard”?
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 of 50
Which type of analysis would be best for understanding the impact of one variable on another?
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 of 50
What does the term “skewness” refer to in statistics?
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 of 50
When creating a bar chart, what do the lengths of the bars represent?
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 of 50
How can Excel’s “PivotTable” be best utilized?
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 of 50
What is the purpose of using a frequency distribution table?
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.
Set 2 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).