I have the same problem. I reference cells in another sheet using data analysis, hit ok, and it comes up with a contagious cell reference error. When I look at the cells I referenced, it's changed completely to "Data!R2C8:R62C12" Show
Have you fixed your problem? If so, how? @DougCooley 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. Descriptive Statistics – Input Range Contains Non-Numeric Data: 6 Possible SolutionsHere, 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. As a result, when we input this cell range in descriptive Statistics it shows an error as shown below. 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 FormatIn 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 WorkbookWe 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.
Step-02: Using Number Format to Input Non-Numeric Data RangeNow, 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.
2. Applying Paste Special FeatureNow, 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:
Read More: How to Create a Descriptive Statistics Table in Excel 3. Using Error Check to See Non-Numeric DataWe 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:
4. Convert Text to Numeric Data with Text to Columns FeatureIn 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. Follow the steps given below to do it on your own dataset. Steps:
Read More: How to Get Summary Statistics in Excel 5. Use of Value FunctionNext, 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:
Here, in the Value function, we inserted Cell C5 as text.
6. Using Mathematical OperationIn 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:
Here, we multiplied Cell C5 by 1 to convert the Text value into a Number.
Practice SectionIn this section, we are giving you the dataset to practice on your own and learn to use these methods. Download Practice Workbook ConclusionSo, 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. Thank you! |