Fix Excel Descriptive Statistics Alert in Data Analysis
Question details
The user needs to resolve an alert prompt that blocks the creation of statistical reports when using the Excel Data Analysis tool.

- 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.
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.
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.
Navigate to the Data tab on the main ribbon and click on 'Data Analysis' in the Analysis group.
Choose 'Descriptive Statistics' from the available analysis tools list and click OK to open the configuration dialog.
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.
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.

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. Open Your Dataset: Launch WPS Office and open the workbook containing your statistical data in the Spreadsheet application.
- 2. Access Data Analysis: Navigate to the Data tab on the top menu ribbon and click the Data Analysis icon.
- 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.

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.




