Forum Discussion
Data Point
When I apply the input range and the output range in Descriptive Statistics, I receive a message saying the input range must have at least one data point, I do not know how to apply a data point.
Mike
- To resolve an error in Excel's Descriptive Statistics tool, ensure the Data Analysis Toolpak is enabled, the input range is numeric, and the range does not contain merged cells. Apply the Descriptive Statistics tool by opening the toolpak, selecting Descriptive Statistics, entering the input range, specifying the output range, checking box options, and clicking OK. Common issues include empty data range, invalid range reference, and numeric data format. Check data for consistency and re-check the Data Analysis Toolpak if necessary.
