Descriptive statistics (Analysis ToolPak) in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ data_output

intermediate

Output of Descriptive Statistics Summary

You use the Analysis ToolPak in Excel to generate descriptive statistics for a dataset of 10 numbers: 2, 4, 6, 8, 10, 12, 14, 16, 18, 20. What is the value of the Mean shown in the output?

A 12

B 10

C 11

D 9

💡 Hint

The mean is the average of all numbers added together divided by the count.

The sum of the numbers is 110. Dividing by 10 gives a mean of 11.

🧠 Conceptual

intermediate

Understanding Output Options in Analysis ToolPak

Which of the following statistics is NOT included by default when you run Descriptive Statistics in Excel's Analysis ToolPak?

A Mean

B Confidence Interval

C Standard Error

D Sum

💡 Hint

Check which statistics are automatically generated and which require extra steps.

The confidence interval is not included by default in the Analysis ToolPak descriptive statistics output.

📊 Formula Result

advanced

Interpreting Skewness from Analysis ToolPak Output

You run descriptive statistics on a dataset and see the skewness value is -1.5. What does this indicate about the data distribution?

A The data is skewed to the left (negative skew)

B The data is skewed to the right (positive skew)

C The data has no outliers

D The data is symmetric with no skew

💡 Hint

Negative skewness means the tail is longer on one side.

A negative skewness value means the data distribution has a longer tail on the left side.

❓ visualization

advanced

Histogram Interpretation from Analysis ToolPak

You create a histogram using Analysis ToolPak for exam scores. The histogram shows most bars concentrated on the left side with a long tail to the right. What does this tell you about the exam scores?

A Most students scored high, with few low scores (negative skew)

B Scores have no variation

C Scores are evenly distributed

D Most students scored low, with few high scores (positive skew)

💡 Hint

Look at where the bars cluster and the direction of the tail.

A histogram with bars on the left and a tail to the right shows positive skew, meaning most scores are low with some high outliers.

🎯 Scenario

expert

Choosing Correct Output Range for Descriptive Statistics

You have data in Excel from cells B2 to B21. You want to run Descriptive Statistics using Analysis ToolPak and output the results starting at cell D2. Which of the following steps correctly sets the input and output ranges?

A Input Range: B2:B21, Output Range: D2

B Input Range: B2:B20, Output Range: D2:D10

C Input Range: B1:B21, Output Range: D2

D Input Range: B2:B21, Output Range: D2:D15

💡 Hint

Input range should include all data cells. Output range is a single cell where output starts.

The input range must cover all data points (B2:B21). The output range is a single cell (D2) where the results will be placed.