Descriptive statistics (Analysis ToolPak) in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to open the Analysis ToolPak add-in in Excel.

Excel

Go to the [1] tab to find the Analysis ToolPak.

Drag options to blanks, or click blank then click option'

AData

BHome

CInsert

DReview

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing the Home tab instead of Data.

Looking under Insert tab.

The Analysis ToolPak is found under the Data tab in Excel.

2fill in blank

medium

Complete the step to select the descriptive statistics option in Analysis ToolPak.

Excel

After clicking Data Analysis, select [1] and click OK.

Drag options to blanks, or click blank then click option'

AHistogram

BRegression

CDescriptive Statistics

DCorrelation

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting Histogram instead of Descriptive Statistics.

Choosing Regression by mistake.

Descriptive Statistics is the option used to get summary statistics like mean and median.

3fill in blank

hard

Fix the error in the input range selection for descriptive statistics.

Excel

Input Range: =[1]

Drag options to blanks, or click blank then click option'

ASheet1!A1:A10

BA1-A10

CSheet1!1:A10

DA1:A10

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash instead of a colon in the range.

Omitting the sheet name when required.

The correct input range includes the sheet name and cell range separated by an exclamation mark.

4fill in blank

hard

Fill both blanks to correctly enable summary statistics and output range.

Excel

Check the box for [1] and set Output Range to [2].

Drag options to blanks, or click blank then click option'

ASummary statistics

BLabels in first row

C$D$1

D$A$1

Attempts:

3 left

💡 Hint

Common Mistakes

Not checking Summary statistics box.

Leaving output range blank or invalid.

You must check Summary statistics to get descriptive stats and specify an output cell like $D$1.

5fill in blank

hard

Fill all three blanks to correctly interpret the output table.

Excel

The mean is in row [1], column [2], and the standard deviation is in row [3].

Drag options to blanks, or click blank then click option'

A4

B2

C5

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing row numbers for mean and standard deviation.

Mixing up column numbers.

In the Analysis ToolPak output, mean is usually in row 1, column 2; standard deviation in row 5.