Descriptive Statistics – Input Range Contains Non-Numeric Data 

Looking for ways to know how to input a range that contains non-numeric data in Descriptive Statistics in Excel? Sometimes, when we try to input data in Descriptive Statistics it shows an error that describes that the data is non-numeric. We can resolve this error by going through some quick steps. Here, you will find 6 ways to Input a range that contains non-numeric data in Descriptive Statistics in Excel.


What Is Descriptive Statistics?

Descriptive Statistics is used to summarize a given data found from any study. It can provide basic information and the internal relationship between the variables in a dataset.


Why Does “Input Range Contains Non-Numeric Data” Error Appear in Descriptive Statistics?

Descriptive Statistics can work only on numeric values. Therefore, when non-numeric data is used for Descriptive Statistics, it shows an error that instructs us to input a range that contains non-numeric data.


Download Practice Workbook


6 Possible Solutions for “Descriptive Statistics – Input Range Contains Non-Numeric Data” Error in Excel

Here, we have a dataset containing the Name and Age of some people. However, you can see that the values in Cell range C5:C12 are in Text Format.

Solutions for Descriptive Statistics - Input Range Contains Non-Numeric Data

As a result, when we input this cell range in descriptive Statistics it shows an error as shown below.

Error Box Instructing to Input Range Contains Non-Numerical Data in Descriptive Statistics

Now, we will show you how to input a range that contains non-numeric data in Descriptive Statistics in Excel using this dataset.


1. Using Number Format

In the first method, we will show you how to input a range that contains non-numeric data in Descriptive Statistics using Number Format.

Sometimes, you may find that the Data Analysis Command is not added in your Excel Workbook. Now, we will show you how to add the Data Analysis Command and input a non-numeric data range in Descriptive Statistics.

Go through the steps to do it on your own.


Step-01: Adding Data Analysis Command in Excel Workbook

We can do complex statistical and engineering analysis of data by using Data Analysis Command in Excel. To add Data Analysis Command in Excel workbook, we have to load Analysis ToolPak. Follow the steps given below to add Data analysis Command in your Excel workbook.

  • Firstly, click on the File tab.

Adding Data Analysis Command in Excel Workbook

  • Then, click on the Options tab.

  • Now, the Excel Options box will open.
  • After that, go to the Add-ins tab >> click on Analysis ToolPak.
  • Then, click on Go.
  • Next, the Add-ins box will appear.
  • After that, turn on the Analysis ToolPak option.
  • Finally, click on OK.


Step-02: Using Number Format to Input Non-Numeric Data Range

Now, we will show you how to change the Text Format to Number Format of the Cell range to input non-numeric data range in Descriptive Statistics.

Go through the steps given below to do it on your own.

  • In the beginning, select Cell range C5:C12.

Using Number Format to Input Non-Numeric Data Range

  • After that, go to the Home tab >> click on Number Format.

  • Then, select Number.

  • Now, you will see that Cell range C5:C12 is in Number Format.

Cell Range Converted to Number Format to Input Range Containing Non-Numerical Data

  • Next, go to the Data tab >> click on Data Analysis.

Opening Data Analysis Box to Input Non-Numerical Data Range in Descriptive Statistics

  • Then, the Data Analysis box will appear.
  • Now, select Descriptive Statistics.
  • After that, click on OK.

Opening Descriptive Statistics Box to Input Non-Numerical Data Range in Descriptive Statistics

  • Now, the Descriptive Statistics box will open.
  • Then, select Cell range C4:C12 in the Input Range box.
  • After that, turn on Labels in first row option.
  • Next, input Cell G4 as Output Range.
  • Afterward, select any Statistical option. Here, we will select Summary statistics.
  • Then, click on OK.

  • Finally, you will get your desired Descriptive Statistics analysis of the given data using Number Format.

Read More: If a Value Lies Between Two Numbers Then Return Expected Output in Excel


2. Applying Paste Special Feature

Now, we will show you how to remove the input range that contains non-numeric data errors in Descriptive Statistics by applying the Paste Special Feature.

Follow the steps given below to do it on your own

Steps:

  • Firstly, insert 1 in any Cell of your Excel worksheet. Here, we will insert 1 in Cell C14.

Applying Paste Special Feature

  • Then, select Cell C14 and click on the Copy button.

Using Copy Button to Input Range Containing Non Numeric Data in Descriptive Statistics

  • After that, select Cell range C5:C12 and Right-click on it.

  • Next, click on Paste Special >> select Paste Special.

Opening Paste Special Box to Input Range Containing Non Numeric Data in Descriptive Statistics

  • Now, the Paste Special box will appear.
  • Then, select All from Paste options.
  • Next, select Multiply from Operation options.
  • After that, click on OK.

  • Now, we will see that Cell range C5:C12 is in General Format.

  • Now, follow the same steps shown in Method 1 to insert Descriptive Statistical analysis of the dataset.
  • Finally, you will get your desired Descriptive Statistics of the given data by applying Paste Special Feature.


3. Using Error Check to See Non-Numeric Data

We can also use Error Check to see the non-numeric data and convert it into Number to input non-numeric data range in Descriptive Statistics.

Go through the steps given below to do it on your own.

Steps:

  • In the beginning, select Cell range C5:C12.

  • Then, click on the Error box.
  • Next, click on Convert to Number.

Using Error Check to See Non-Numeric Data to Input Range Containing Non Numeric Data in Descriptive Statistics

  • Now, we will see that Cell range C5:C12 is in General Format.

  • Now, follow the same steps shown in Method 1 to insert Descriptive Statistical analysis of the dataset.
  • Finally, using the Error box, you will get your desired Descriptive Statistics of the given data.

Read More: [Fixed!] Excel Links Not Working Unless Source Workbook Is Open


Similar Readings


4. Convert Text to Numeric Data with Text to Columns Feature

In the fourth method, we will show you how to convert Text to Numeric data with Text to Column Feature to input non-numeric data. Here, we have an additional column named Age in Number to input the Numerical data.

Convert Text to Numeric Data with Text to Columns Feature to Input Range Containing Non Numeric Data in Descriptive Statistics

Follow the steps given below to do it on your own dataset.

Steps:

  • Firstly, select Cell range C5:C12.
  • Then, go to the Data tab >> click on Data Tools >> select Text to Columns.

Opening Text to Columns box to Input Range Containing Non Numeric Data in Descriptive Statistics

  • Now, the Convert Text to Columns Wizard box will appear.
  • Next, select Delimited.
  • Then, click on Next.

  • Again, click on Next.

  • After that, select General as Column data format.
  • Then, input Cell D5 as Destination.
  • Next, click on Finish.

  • Now, we will see that Cell range C5:C12 is in General Format.

Converting Text to General Format to Input Range Containing Non Numeric Data in Descriptive Statistics

  • Then, follow the steps shown in Method 1 to open the Descriptive Statistics box.
  • Now, select Cell range D4:D12 as Input Range.
  • After that, turn on Labels In first row option.
  • Next, input Cell G4 as Output Range.
  • Afterward, select any Statistical option. Here, we will select Summary statistics.
  • Then, click on OK.

  • Finally, you will get your desired Descriptive Statistics of the given data using the Text to Column Feature.

Read More: How to Move Data from Row to Column in Excel (4 Easy Ways)


5. Use of Value Function

Next, we will show you how to input a range that contains non-numeric data in Descriptive Statistics in Excel using the Value Function. The Value Function is used to convert a numeric Text string into a Number.

Go through the steps given below to do it on your own.

Steps:

  • Firstly, select Cell D5.
  • Then, insert the following formula.
=VALUE(C5)

Use of Value Function to Input Range Containing Non Numeric Data in Descriptive Statistics

Here, in the Value function, we inserted Cell C5 as text.

  • Now, press ENTER.
  • After that, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Then, you will get all the values of Age in General Format.

  • Now, go through the steps shown in Method 3 to insert Descriptive Statistical analysis of the dataset.
  • Finally, you will get your desired Descriptive Statistics of the given data using the Value Function.


6. Using Mathematical Operation

In the final method, we will show you how to input a range that contains non-numeric data in Descriptive Statistics in Excel using Mathematical Operation.

Follow the steps given below to do it on your own dataset.

Steps:

  • Firstly, select Cell D5.
  • Then, insert the following formula.
=1*C5

Using Mathematical Operation to Input Range Containing Non Numeric Data in Descriptive Statistics

Here, we multiplied Cell C5 by 1 to convert the Text value into a Number.

  • Next, press ENTER.
  • After that, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Now, you will get all the values of Age in General Format.

  • Now, go through the steps shown in Method 3 to insert Descriptive Statistical analysis of the dataset.
  • Finally, you will get your desired Descriptive Statistics of the given data using the Mathematical Operation.

Read More: How to Calculate Root Mean Square Error in Excel


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


Conclusion

So, in this article, you will find 6 ways to input a range that contains non-numeric data in Descriptive Statistics in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Arin

Arin

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo