Others

Fix Excel Descriptive Statistics Alert in Data Analysis

Steven ParkerSteven Parker Nov 3, 2026 868 views

Question details

The user needs to resolve an alert prompt that blocks the creation of statistical reports when using the Excel Data Analysis tool.

How to Fix the Excel Descriptive Statistics Alert in Data Analysis
Product
Microsoft Excel
Device & OS
not provided
Scenario
Running descriptive statistics on a worksheet range using the built-in Data Analysis ToolPak.
Observed behavior
Excel displays an alert and fails to generate the descriptive statistics because the data orientation (grouped by rows vs. columns) is configured incorrectly for the selected input range.
Before you start

Ensure that your selected data range contains valid numeric values without empty or merged cells, and that the Data Analysis ToolPak add-in is actively enabled in your settings.

Solution 1Recommended

Adjust Data Orientation Grouping in Descriptive Statistics

Fix the alert by matching the tool's grouping setting with the actual layout of your dataset.

The Descriptive Statistics tool needs to know whether your distinct variables are organized horizontally across rows or vertically down columns. When this setting contradicts your highlighted input range, Excel throws an alert.

1
Open the Data Analysis Tool

Navigate to the Data tab on the main ribbon and click on 'Data Analysis' in the Analysis group.

2
Select Descriptive Statistics

Choose 'Descriptive Statistics' from the available analysis tools list and click OK to open the configuration dialog.

3
Verify the Input Range

Click inside the 'Input Range' box and highlight the exact cells containing your dataset. If you include headers, ensure the 'Labels in first row' box is checked.

4
Change the Grouping Setting

Under 'Grouped By', select 'Rows' if your data variables extend horizontally. If each variable is listed vertically in its own column, select 'Columns'. Click OK to generate your statistics.

Adjust Data Orientation Grouping in Descriptive Statistics
Tip for Header Labels: If you are switching from Columns to Rows, make sure to adjust your label settings accordingly, as Excel will now look for labels in the first column instead of the first row.
Perform Data Analysis in WPS Spreadsheets

Use WPS Spreadsheet for Seamless Data Analysis

WPS Spreadsheet features a highly compatible built-in Data Analysis tool that processes descriptive statistics accurately, helping you avoid confusing orientation alerts while working with large datasets.

  1. 1. Open Your Dataset: Launch WPS Office and open the workbook containing your statistical data in the Spreadsheet application.
  2. 2. Access Data Analysis: Navigate to the Data tab on the top menu ribbon and click the Data Analysis icon.
  3. 3. Run Statistics: Select Descriptive Statistics, input your exact data range, choose 'Grouped by Rows' or 'Grouped by Columns' based on your layout, and click OK.
Built-in Data Analysis tool for descriptive statistics and advanced mathematics100% compatible with Microsoft Excel formats (.xls, .xlsx, .csv)Intuitive UI that makes adjusting data orientation and input ranges simple
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say my Descriptive Statistics input range contains non-numeric data?

This alert triggers if your selected range includes text, blank cells, or special characters. Ensure you only select numbers, or check the 'Labels in first row/column' box if your selection includes text headers.

Where do I find the Data Analysis tool if it is missing from my Data tab?

Go to File > Options > Add-ins. At the bottom of the window, select 'Excel Add-ins' from the Manage drop-down and click Go. Check the box for 'Analysis ToolPak' and click OK to enable it on your ribbon.

Does changing the grouping from Columns to Rows alter my statistical results?

Yes. Grouping by rows treats each horizontal line as an independent variable, generating statistics for each row. Grouping by columns treats each vertical column as a variable. Choosing the wrong one will result in mathematically incorrect outputs or alerts.

Can I run descriptive statistics on non-contiguous ranges?

No, the Data Analysis ToolPak requires a single contiguous block of cells for the Input Range. You will need to move your data into adjacent columns or rows before running the tool.