D388 Fundamentals of Spreadsheets and Data Presentations - Set 5 - Part 1

Correct Answer: To make predictions or generalizations about a population based on sample data

Inferential statistics uses sample data to make inferences about a larger population, allowing researchers to draw conclusions beyond the immediate data set.

Correct Answer: A portion of the population selected for analysis

A sample is a subset drawn from a larger population, used for statistical analysis to infer characteristics about the whole population.

Correct Answer: Ratio

The ratio scale provides the highest level of measurement precision, including an absolute zero point and meaningful ratios between values.

Correct Answer: The average of all the values

The mean is calculated by summing all values in a dataset and dividing by the number of values, reflecting the central tendency.

Correct Answer: COUNT

The COUNT function counts only the cells containing numeric values within the specified range.

Correct Answer: To present data in a visual context to enhance understanding

Data visualization transforms raw data into graphical formats, making it easier for users to grasp insights and trends.

Correct Answer: The maximum and minimum values excluding outliers

In a box plot, whiskers extend to the highest and lowest values that are not considered outliers, providing insight into the spread of the main body of data.

Correct Answer: To illustrate the frequency of different categories

Bar charts are ideal for comparing discrete categories, using bars to represent the frequency or value associated with each category.

Correct Answer: To remove inaccuracies and inconsistencies from the dataset

Data cleaning ensures that the dataset is accurate and reliable before analysis, which is essential for producing valid results.

Correct Answer: T-test

A T-test is used to compare the means of two groups to determine if there is a statistically significant difference between them.

Correct Answer: The measure of symmetry of the distribution

Skewness quantifies how much a distribution deviates from symmetry, indicating the direction (left or right) of the skew.

Correct Answer: To indicate what each color or pattern represents

The legend clarifies the meaning of different colors or patterns used in the chart, helping viewers understand the data series.

Correct Answer: To show trends over time

Correct Answer: By comparing the values in the columns you select in the Remove Duplicates dialog

Remove Duplicates evaluates the columns you check in its dialog. Two rows are duplicates only if they match across all selected columns. If you check only one column, rows with the same value there are removed even if other columns differ; checking more columns makes the match more specific. The first occurrence is kept and later duplicates are deleted.

Correct Answer: Permanently deletes the duplicate rows rather than just hiding them

Remove Duplicates actually deletes the extra rows from the worksheet; it does not hide them the way a filter would. Because the removal is destructive, it is wise to work on a copy of the data or use a filter/formula approach first if you might need the duplicates later. Undo can reverse it immediately, but not after further edits.

Correct Answer: Split a single column of combined data (such as Smith, John) into multiple columns

Text to Columns parses one column into several by splitting on a delimiter (comma, space, tab, semicolon) or by fixed character widths. It is ideal for separating full names, addresses, or delimited imported data into distinct fields. To do the reverse, joining columns, you would use CONCAT, TEXTJOIN, or the ampersand operator instead.

Correct Answer: Splits data at specific character positions you set with break lines rather than at a delimiter

The Fixed width option lets you divide text based on column positions rather than a separating character. You click in the data preview to insert, move, or delete break lines at exact character positions. This is useful for legacy reports where fields align in fixed columns without commas or tabs between them.

Correct Answer: Finds the input value needed to make a formula produce a specific target result

Goal Seek works backward: you specify a formula cell, the target value you want it to equal, and one input cell to change. Excel iteratively adjusts that single input until the formula reaches the goal. For example, it can find the sales volume required to hit a target profit. It handles only one variable at a time.

Correct Answer: Scenario Manager

Scenario Manager stores multiple named scenarios, each holding a different set of values for a group of changing cells. You can switch between scenarios to see how results change and generate a summary report comparing them. This makes it well suited to modeling best-case, expected, and worst-case assumptions in a single workbook.

Correct Answer: Show how one or more formula results change as a single input value varies across a list

A one-variable data table substitutes a series of values into one input cell and records how the referenced formula(s) respond to each. The varying values run down a column or across a row, and Excel fills in the corresponding results. It's ideal for sensitivity analysis, such as seeing loan payments across a range of interest rates.