Back to Subject

Unit 11: Excel Data Analysis - Practice Quiz

ECAP792 60 Questions
0 Correct 0 Wrong 60 Left
0/60

1 In an Excel worksheet, what is the intersection of a row and a column called?

Introduction to Excel data analysis Easy
A. A workbook
B. A cell
C. A range
D. A formula

2 What is an Excel file containing one or more worksheets called?

Introduction to Excel data analysis Easy
A. A dashboard
B. A document
C. A database
D. A workbook

3 Which symbol normally begins a formula in Excel?

Introduction to Excel data analysis Easy
A. The hash sign (#)
B. The plus sign (+)
C. The equal sign (=)
D. The percent sign (%)

4 What is the Data Analysis ToolPak in Excel?

Data Analysis ToolPak Easy
A. A worksheet formatting tool
B. A cloud storage service
C. A statistical analysis add-in
D. A chart design template

5 After the Data Analysis ToolPak is enabled, where is its Data Analysis command usually found?

Data Analysis ToolPak Easy
A. On the Review tab
B. On the Home tab
C. On the Insert tab
D. On the Data tab

6 Which ToolPak option produces a summary containing measures such as the mean and standard deviation?

Data Analysis ToolPak Easy
A. Random Number Generation
B. Moving Average
C. Descriptive Statistics
D. Fourier Analysis

7 What must usually be done before using the Data Analysis ToolPak for the first time?

Data Analysis ToolPak Easy
A. Enable the add-in
B. Create a chart
C. Protect the worksheet
D. Convert cells to text

8 Which descriptive statistic represents the arithmetic average of a dataset?

Descriptive statistics Easy
A. Range
B. Mean
C. Mode
D. Median

9 Which statistic is the middle value when data is arranged in order?

Descriptive statistics Easy
A. Median
B. Range
C. Variance
D. Mean

10 Which statistic identifies the value that occurs most frequently?

Descriptive statistics Easy
A. Mean
B. Mode
C. Range
D. Median

11 What does standard deviation describe?

Descriptive statistics Easy
A. The spread of the values
B. The total number of values
C. The most frequent value
D. The largest observed value

12 What is the main purpose of ANOVA?

Analysis of variance (ANOVA) Easy
A. To sort text values
B. To compare group means
C. To create data labels
D. To count empty cells

13 What does the acronym ANOVA stand for?

Analysis of variance (ANOVA) Easy
A. Analysis of Variance
B. Arrangement of Values
C. Analysis of Variables
D. Average of Variances

14 A small ANOVA p-value typically provides evidence against which hypothesis?

Analysis of variance (ANOVA) Easy
A. All variables are text
B. All group means are equal
C. All observations are positive
D. All sample sizes are equal

15 What is regression analysis commonly used to examine?

Regression Easy
A. Duplicate worksheet names
B. Cell border thickness
C. Workbook file sizes
D. Relationships between variables

16 In simple linear regression, which variable is being predicted?

Regression Easy
A. The categorical label
B. The independent variable
C. The dependent variable
D. The worksheet variable

17 In the equation , what does represent?

Regression Easy
A. The intercept
B. The slope
C. The sample size
D. The residual

18 What does a histogram display?

Histogram Easy
A. The hierarchy of workbook sections
B. The sequence of worksheet formulas
C. The relationship between two text columns
D. The frequency distribution of numerical data

19 What are the intervals used to group values in a histogram called?

Histogram Easy
A. Series
B. Labels
C. Legends
D. Bins

20 What does the height of a histogram bar usually represent?

Histogram Easy
A. The worksheet's width
B. The bin's text label
C. The bin's frequency
D. The chart's title size

21 A worksheet contains customer IDs, regions, and sales amounts. You want to sort sales from largest to smallest while keeping each customer's data together. What should you do?

Introduction to Excel data analysis Medium
A. Convert the sales column to text before sorting the range
B. Select only the sales column and sort values descending
C. Select the entire data range and sort by the sales column
D. Copy the sales column elsewhere and sort the copied values

22 Sales amounts imported into Excel are left-aligned and formulas such as =AVERAGE(C2:C100) ignore them. What is the most likely solution?

Introduction to Excel data analysis Medium
A. Sort the sales entries from smallest to largest
B. Apply a currency format to the sales entries
C. Convert the sales entries from text to numeric values
D. Replace the formula with the COUNTA function

23 A data table grows every week, and charts should automatically include newly appended rows. Which Excel feature is most suitable?

Introduction to Excel data analysis Medium
A. Protect the worksheet containing the data range
B. Convert the data range into an Excel Table
C. Merge the heading cells above the data range
D. Freeze the first row of the data range

24 The Data Analysis command is not visible on Excel's Data tab. What should you do first?

Data Analysis ToolPak Medium
A. Enable the Analysis ToolPak through Excel Add-ins
B. Install a different worksheet function library
C. Create a PivotTable from the current worksheet
D. Change workbook calculation to automatic mode

25 A selected input range for a ToolPak analysis includes the heading Monthly Sales in its first row. Which setting should be selected?

Data Analysis ToolPak Medium
A. Summary statistics
B. Kth largest
C. Labels in first row
D. Confidence level for mean

26 You need to keep an analysis output separate from the source worksheet and avoid overwriting existing cells. Which output choice is best?

Data Analysis ToolPak Medium
A. Grouped By Columns
B. New Worksheet Ply
C. Output Range
D. Labels in First Row

27 A salary dataset has a mean of and a median of . Which interpretation is most reasonable?

Descriptive statistics Medium
A. Several high salaries may be pulling the mean upward
B. Several low salaries may be pulling the median upward
C. The salary values must all be close to the mean
D. The salary distribution must be perfectly symmetric

28 Two datasets have means of and , with standard deviations of and , respectively. Which dataset has greater relative variability?

Descriptive statistics Medium
A. The second, because its coefficient of variation is
B. The first, because its coefficient of variation is
C. The first, because its coefficient of variation is
D. The second, because its coefficient of variation is

29 The ToolPak reports a sample variance of for a dataset. What is the sample standard deviation?

Descriptive statistics Medium
A.
B.
C.
D.

30 Excel's Descriptive Statistics output gives a mean of and a Confidence Level (95.0%) value of . What is the corresponding confidence interval?

Descriptive statistics Medium
A. to
B. to
C. to
D. to

31 A company compares the mean delivery times of four warehouses using one-way ANOVA. What is the null hypothesis?

Analysis of variance (ANOVA) Medium
A. All four population mean delivery times are equal
B. Exactly one population mean is greater than the others
C. All four sample mean delivery times are different
D. At least two population variances are equal

32 An Excel ANOVA output reports and . What is the statistic?

Analysis of variance (ANOVA) Medium
A.
B.
C.
D.

33 A one-way ANOVA produces a p-value of at . Which conclusion is appropriate?

Analysis of variance (ANOVA) Medium
A. Retain the null; all population means are identical
B. Reject the null; every population mean must differ
C. Retain the null; the sample variances are unequal
D. Reject the null; at least one population mean differs

34 A researcher studies crop yield using two fertilizer types and three irrigation levels, with several plots under each combination. Which ToolPak procedure can test both main effects and their interaction?

Analysis of variance (ANOVA) Medium
A. ANOVA: Two-Factor With Replication
B. ANOVA: Single Factor
C. ANOVA: Two-Factor Without Replication
D. Descriptive Statistics

35 A regression of weekly sales on advertising spending gives an advertising coefficient of , where both variables are measured in thousands of dollars. How should the coefficient be interpreted?

Regression Medium
A. An extra in advertising predicts more in sales
B. Weekly sales rise by dollars for each advertising dollar
C. Advertising accounts for exactly of weekly sales
D. An extra in advertising predicts more in sales

36 An Excel regression output reports . What does this indicate?

Regression Medium
A. The model explains of the variation in the response
B. The correlation between the variables must equal
C. The model predicts the response correctly in of cases
D. The response increases by for each predictor unit

37 A regression coefficient has a p-value of when tested at . What is the best interpretation?

Regression Medium
A. The model has a prediction error equal to units
B. The predictor is not statistically significant at the level
C. The predictor has a statistically significant negative relationship
D. The predictor explains exactly of the response variation

38 A residual plot from a linear regression shows a clear U-shaped pattern. What does this most strongly suggest?

Regression Medium
A. The observations have been sorted incorrectly
B. The fitted intercept must be exactly zero
C. The response has no relationship with the predictor
D. A nonlinear relationship remains unmodeled

39 For Excel's Histogram ToolPak, the bin range contains , , and . Where is an observation of counted?

Histogram Medium
A. In the overflow bin because it equals a bin value
B. In the bin greater than and less than or equal to
C. In both adjacent bins because it equals a boundary
D. In the bin greater than and less than or equal to

40 A histogram of customer waiting times has most observations in lower-value bins and a long tail toward higher values. How should the distribution be described?

Histogram Medium
A. Negatively skewed
B. Approximately uniform
C. Perfectly symmetric
D. Positively skewed

41 A worksheet is filtered, and several additional rows are manually hidden. Which formula calculates the mean of only the currently visible values in B2:B100?

Introduction to Excel data analysis Hard
A. =SUBTOTAL(101,B2:B100)
B. =AVERAGE(B2:B100)
C. =AGGREGATE(1,4,B2:B100)
D. =SUBTOTAL(1,B2:B100)

42 Excel regression produces a slope of when sales are regressed on a column of daily dates. The date cells are then reformatted from daily dates to month names without changing their stored values. How should the slope be interpreted?

Introduction to Excel data analysis Hard
A. Sales increase by units per month.
B. The slope becomes invalid after date reformatting.
C. Sales increase by units per day.
D. Sales increase by units per date label.

43 A Descriptive Statistics input range contains 11 numeric observations, beginning with 100 in its first row. The user mistakenly selects Labels in first row. What is the most likely consequence?

Data Analysis ToolPak Hard
A. Excel treats 100 as a label and analyzes ten observations.
B. Excel retains 100 and labels the output with its address.
C. Excel rejects the range because labels must contain text.
D. Excel detects the numeric header and analyzes all observations.

44 A ToolPak regression report was generated from worksheet data. Several input observations are later corrected, but the report remains unchanged after recalculation. What action is required?

Data Analysis ToolPak Hard
A. Rerun the Regression analysis with the corrected input.
B. Enable iterative calculation for the regression output range.
C. Replace the output coefficients with array formulas.
D. Press F9 after converting the output into a table.

45 A variable has mean , sample standard deviation , skewness , and excess kurtosis . For , which set of descriptive statistics is correct?

Descriptive statistics Hard
A. Mean , standard deviation , skewness , kurtosis
B. Mean , standard deviation , skewness , kurtosis
C. Mean , standard deviation , skewness , kurtosis
D. Mean , standard deviation , skewness , kurtosis

46 The ToolPak reports a sample mean of and a 95% Confidence Level for Mean of . Which interpretation is correct?

Descriptive statistics Hard
A. The probability that the sample mean equals is 95%.
B. The population standard deviation is estimated to be .
C. Approximately 95% of observations lie in .
D. The estimated 95% confidence interval is .

47 Two samples have summaries and . If the raw observations are combined, what are the combined mean and sample variance?

Descriptive statistics Hard
A. Mean and variance
B. Mean and variance
C. Mean and variance
D. Mean and variance

48 A one-way ANOVA has three groups of five observations with means , , and . The within-group sum of squares is . What is the ANOVA statistic?

Analysis of variance (ANOVA) Hard
A.
B.
C.
D.

49 Three groups have sizes , , and and means , , and , respectively. Which grand mean must Excel use when calculating the between-group sum of squares?

Analysis of variance (ANOVA) Hard
A.
B.
C.
D.

50 Why can Excel's ANOVA: Two-Factor Without Replication not provide a separate test for interaction?

Analysis of variance (ANOVA) Hard
A. Interaction and random error are confounded with one observation per cell.
B. Interaction is included automatically in each factor's main effect.
C. Interaction requires both factors to have equal numbers of levels.
D. Interaction can be tested only when both factors are quantitative.

51 A balanced two-factor experiment has levels of factor A, levels of factor B, and observations per cell. What are the interaction and within-cell error degrees of freedom?

Analysis of variance (ANOVA) Hard
A. Interaction ; error
B. Interaction ; error
C. Interaction ; error
D. Interaction ; error

52 In a replicated experiment, the cell means are and for A1, but and for A2 across levels B1 and B2. Which conclusion best reflects this pattern?

Analysis of variance (ANOVA) Hard
A. Only factor A can be significant because its profiles cross.
B. Both main effects must be strong while interaction remains absent.
C. Both main effects may vanish while the interaction remains strong.
D. Only factor B can be significant because its means are reversed.

53 An Excel regression coefficient is with standard error and residual degrees of freedom. Given , what is its 95% confidence interval?

Regression Hard
A.
B.
C.
D.

54 A predictor is added to an ordinary least-squares regression using exactly the same observations. Which outcome is mathematically possible?

Regression Hard
A. Both measures must increase by the same amount.
B. increases while adjusted decreases.
C. decreases while adjusted increases.
D. Both measures must remain unchanged after addition.

55 A categorical predictor has three regions: North, South, and West. An Excel regression includes an intercept. Which encoding avoids perfect multicollinearity while retaining regional comparisons?

Regression Hard
A. Use three dummy variables and retain the model intercept.
B. Use one dummy variable that separates all three regions.
C. Use two dummy variables and treat one region as the reference.
D. Assign region codes , , and as one predictor.

56 A residual plot from an Excel linear regression shows residuals near zero for small and large fitted values but predominantly positive residuals in the middle. What is the strongest diagnosis?

Regression Hard
A. The response contains only normally distributed errors.
B. The predictors exhibit perfect pairwise multicollinearity.
C. The residual variance is constant across fitted values.
D. The linear specification is missing a curved relationship.

57 Excel's Regression tool is run with Constant is Zero selected. Why should its reported not be directly compared with the ordinary from a model containing an intercept?

Regression Hard
A. The intercept model excludes the response mean from all calculations.
B. The zero-intercept model may use an uncentered definition of .
C. The intercept model calculates from standardized coefficients.
D. The zero-intercept model always produces a negative residual sum.

58 The data are 0, 10, 10, 20, 20, 20, 31, and the ToolPak Histogram bin values are 10, 20, 30. What frequencies will Excel report for these bins and the More category?

Histogram Hard
A. 3, 0, 3, 1
B. 2, 3, 1, 1
C. 1, 2, 3, 1
D. 3, 3, 0, 1

59 An Excel FREQUENCY formula uses three bin limits: 10, 20, and 30. Why must its output array contain four cells?

Histogram Hard
A. The fourth cell counts observations equal to the smallest bin.
B. The fourth cell counts observations greater than the largest bin.
C. The fourth cell counts blank and nonnumeric input cells.
D. The fourth cell stores the total number of input observations.

60 Two histogram classes have widths and and frequencies and , respectively. If unequal-width classes must be compared without distorting visual area, what should their bar heights be?

Histogram Hard
A. and , using frequency density
B. and , using frequency area
C. and , using relative width
D. and , using raw frequency
Previous MCQ
Unit 10
Next MCQ
Unit 12