Data Import & Export

Fix Excel Descriptive Statistics Input Range Must Contain Data Error

Partner Editor Sep 25, 2026 874 views

Question details

The user encounters an error stating 'Input range must contain at least one data point' when attempting to use the Descriptive Statistics tool.

How to Fix Excel Descriptive Statistics 'Input Range Must Contain Data' Error

Product: Microsoft Excel
Device & OS: not provided
Scenario: Using the Data Analysis toolpak to generate descriptive statistics for a selected dataset.
Observed behavior: Excel blocks the operation and displays a warning dialog stating that the input range must contain at least one data point when the user clicks OK.

Before you start

Verify that your selected dataset actually contains numeric values, as the Descriptive Statistics tool cannot process ranges consisting entirely of text or blank cells.

Solution 1Recommended

Verify and Correct the Input Range Selection

Ensure the selected input range accurately targets numeric data and handles text headers correctly.

The most common cause of this error is selecting a range that contains only text, or failing to inform Excel that the first row of your selection contains text labels rather than data. The Descriptive Statistics tool requires numeric inputs to perform calculations.

Open the Data Analysis tool

Navigate to the Data tab on the ribbon and click on Data Analysis. Select 'Descriptive Statistics' from the list and click OK.

Reselect your input range

Click inside the 'Input Range' box, then click and drag on your worksheet to highlight only the cells containing the data you want to analyze.

Configure the label settings

If the first row of your selected range contains a text heading, you must check the box for 'Labels in first row'. If you only selected numeric data without the heading, leave this box unchecked.

Run the analysis

Choose your output options (such as 'Summary statistics') and click OK to generate the report.

Verify and Correct the Input Range Selection

Correct Labeling: Toggling the 'Labels in first row' checkbox properly prevents Excel from trying to calculate statistics on your text headers.

Solution 2

Convert Text-Formatted Numbers to Actual Numbers

Fix numbers that Excel is reading as text, which prevents the statistical tools from recognizing them as valid data points.

Solution 3

Remove Formulas Returning Empty Strings

Clear out formulas that generate blank outputs (""), as these can confuse the Data Analysis toolpak.

Data Analysis Solution

Generate Descriptive Statistics Easily in WPS Spreadsheet

WPS Spreadsheet provides a robust and user-friendly Data Analysis toolpak. It is perfectly compatible with Excel files, allowing you to generate descriptive statistics efficiently without frustrating range errors.

1. Open your data in WPS Spreadsheet: Launch WPS Office and open your workbook containing the dataset you wish to analyze.
2. Access the Data Analysis tool: Navigate to the Data tab on the top ribbon and click on the 'Data Analysis' button.
3. Select Descriptive Statistics: Choose 'Descriptive Statistics' from the available analysis tools list and click OK.
4. Configure and generate: Highlight your numeric data range, check 'Labels in first row' if you included headers, select your output location, and click OK to generate your statistics.

Built-in Data Analysis tools for quick and accurate statistical summaries.Highly compatible with Microsoft Excel (.xlsx and .xls) file formats.Clear, intuitive interface that makes selecting input ranges straightforward.Free and lightweight alternative for complex data processing tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel think my numbers are text?

Excel often formats numbers imported from CSV files, databases, or web exports as text strings to preserve formatting. You can convert them back by selecting the range, clicking the yellow warning icon, and choosing 'Convert to Number'.

Can Descriptive Statistics analyze multiple columns at once?

Yes, you can select a contiguous range spanning multiple columns. Just ensure you select 'Grouped by Columns' in the Descriptive Statistics dialog box so it calculates statistics for each column individually.

What happens if I have blank cells in the middle of my data?

The Descriptive Statistics tool generally ignores truly blank cells within a valid numeric range. However, if your range consists entirely of blank cells, or if those cells contain hidden spaces or formulas returning empty strings, the tool will throw an error.

Where do I find the Data Analysis button in Excel?

If you don't see the Data Analysis button under the Data tab, you need to enable the Analysis ToolPak. Go to File > Options > Add-ins, select 'Excel Add-ins' at the bottom, click Go, check 'Analysis ToolPak', and click OK.

Excel & Data Problems