Forum Discussion
Solved
Descriptive Statistics
Hey, i am trying to do a descriptive analysis on a dataset, but it says input data contains non-numerical data which is somewhat accurate because some of the part i am selecting has no input of d...
- Perhaps replace all the dashes with nothing (Home tab, Find & Select, Replace) before doing the stats?
Hey, Jan That was a good idea, although perhaps because i didn't show this specific picture but it essentially represents, something i can maybe ignore the dash, but the stars, not sure, is there a numerical way or is this data something i shouldn't try to do a descriptive statistics on.
And also, assuming i am able to do so, there is quite a bit of data that i would like to do a descriptive statistics on, is there a way to organise it better, i.e. not in separate sheets, etc. and is there a way to make it even faster?
Or are there certain, datasets that make sense to use descriptive statistics on?
Is the data layout of all those tabs identical? Perhaps this gives you some pointers: https://www.xelplus.com/combine-excel-sheets-power-query/