Descriptive statistics non-numeric data

Why does the data analysis toolkit not give me descriptive statistics?

I really expect every cell in that column to be numeric, yet the left aligned, non-zero numbers behave like text values (left align), where only the zero values behave like numerics, and the Data Analysis Toolkit won't give me Descriptive Statistics because the column contains non-numeric values

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.Highlight the data of interest. Anyways click on the little box that comes up in the corner and convert to number. Another trick is in another cell enter 1. Click on this cell then press Ctrl&C. Highlight the cells right click and select Paste Special. Then select multiple and Ok.

Descriptive Statistics

1. On the Data tab, in the Analysis group, click Data Analysis. Note: can't find the Data Analysis button? Click here to load the Analysis ToolPak add-in.
2. Select Descriptive Statistics and click OK.

In other words, if you are already on the sheet, and then: Go to Data / Data Analysis / Descriptive Statistics. Click on the drop-down arrow next to input range, then select your input range. Click on the input range again to expand the options box. Check the box for 'Labels in first row'. Select your other options and click on okay.

Categories